Re: Installing SQL Server 2008 on a cluster



I found at least one potential workaround for this. It does appear to be a
bug with the SQL installer.

In my case it was failing consistently no matter what the results of running
the validation test. Finally I deleted all files out of
C:\Windows\Cluster\Reports on both nodes and ran it again. I verified there
was just one report in the above directory. But running the check again
failed saying there were errors or no verification report.

I then ran Process Monitor and filtered to only capture setup100.exe. I
reran the checks and it failed as expected. In the Process Monitor output I
did a search for Validation and found where it was trying to access the
validation report. It had the path right, but the name it was using was
differenct than the name of my report. Instead of "Validation Data For Node
Set C1DE6...xml" it was looking for "Validation Data For Node Set
D1A1B...xml". I couldn't find any references to this other ID anywhere.

I then copied the real Validation Data report on both nodes and renamed them
to be what the setup was expecting to fine. I reran the install checks and
this time it made it all the way through without error.

"bass_player" wrote:

I dont even see that KB number (KB953748) on the Microsoft support site.
Can you check the Cluster Events under Failover Cluster Management and see
if there is anything related? Try re-running the Validate a Configuration
wizard once more on your existing cluster nodes and see if it will generate
related errors

"rl" <rl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2F15C5BD-7E51-48B4-AE11-97AFC5B5F99A@xxxxxxxxxxxxxxxx
Windows 2008.

"Geoff N. Hiten" wrote:

Are you using WIndows 2003 or 2008 clustering?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"rl" <rl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5C305DF5-41A2-453E-9266-31D5350EBCDF@xxxxxxxxxxxxxxxx
Hello all,

Iam receiving a message while installing the SQL Server 2008 in a
cluster
environment.

Error : "Microsoft Cluster Service (MSCS) cluster verification errors"
failed. The cluster either has not been verified or there are errors or
failures in the verification report. Refer to KB953748 or SQL server
books
online for more information"

to resolve this I ran the "validate the cluster" tests under failover
cluster management. The validation was successful without any warnings
or
errors. Even then I still get the same error.

Could someone please help me out. I have been spending 2 days on this
and
just can't find a solution to this.

Thanks,
rl







.



Relevant Pages

  • Re: Installing SQL Server 2008 on a cluster
    ... The best fix is to run any SQL CU before installing SQL 2008. ... The CU "pre-patches" the installer and fixes the cluster install bugs. ... failed saying there were errors or no verification report. ... did a search for Validation and found where it was trying to access the ...
    (microsoft.public.sqlserver.clustering)
  • Re: Windows 2008 Verification of Failover Cluster...
    ... Then I started Cluster Validation Wizzard again and unchecked failing test. ... After that I was able to install SQL 2008. ... the verification report. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Windows 2008 Verification of Failover Cluster...
    ... The problem occured for me on a fresh install of Windows 2008 with a brand ... new cluster scripted from a batch file. ... I go to run an install of SQL 2008 ... First of all I have to find source of this error in Cluster validation ...
    (microsoft.public.sqlserver.clustering)
  • Re: Windows 2008 Verification of Failover Cluster...
    ... I followed all the steps metioned below and the validation passed ... The problem occured for me on a fresh install of Windows 2008 with a brand ... new cluster scripted from a batch file. ... I go to run an install of SQL 2008 ...
    (microsoft.public.sqlserver.clustering)
  • Re: Windows 2008 Verification of Failover Cluster...
    ... I haven't seen a Windows 2008 specific validation document. ... the basic functionality of a cluster isn't any different than in Windows 2005. ... You will need to go ahead and create a new applicaiton group and move the disk resourceinto that group before installing SQL. ...
    (microsoft.public.sqlserver.clustering)

Loading