Groups | Blog | Home
all groups > sql server clustering > february 2004 >

sql server clustering : Cannot install on Windows 2003 cluster


Ole
2/1/2004 6:47:24 AM
I have trouble installing default as well as named
instances og SQL Server 2000 on Windows 2003 cluster. I've
tried on a couple of different systems with the same
result.

The setup fails every time while creating virtual server
resources.

Here's the tail of sqlstp.log:
15:13:22 Begin Action : CreateVirtualServerResources
15:13:35 End Action : CreateVirtualServerResources
15:13:35 CreateVirtualServerResources returned: 2
15:14:01 An error occurred while creating virtual server
resources for clustering. The system cannot find the file
specified.

And sqlclstr.log:
CreateSQLResourceTypes: called ClusterEnum(15),
status=0x103
ClusterGetClusterDiskInfo: i=0
ClusterEnum(0): enter
ClusterEnum(0): [Disk D:]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo:
ClusterResourcePhysDiskGetDevNames
ccNodeName=1024 ccGroupName=1024
szNodeName=[BEAUTY] szGroupName=[Cluster Group]
csNodeName=[BEAUTY] csGroupName=[Cluster Group]
csNodeName=[BEAUTY].csGroupName=[Cluster Group]
ClusterGetClusterDiskInfo: i=1
ClusterEnum(1): enter
ClusterEnum(1): [Disk F:]
ClusterGetClusterDiskInfo: GetClassType
ClusterGetClusterDiskInfo:
ClusterResourcePhysDiskGetDevNames
ccNodeName=1024 ccGroupName=1024
szNodeName=[BEAUTY] szGroupName=[Group 1]
csNodeName=[BEAUTY] csGroupName=[Group 1]
csNodeName=[BEAUTY].csGroupName=[Group 1]
ClusterCreateVirtualSQLSvrGroup1: vs->hresNet=0x0
[sqlclusterSetup.cpp:291] : 2 (0x2): The system cannot
find the file specified.

[sqlclusterSetup.cpp:352] : 2 (0x2): The system cannot
find the file specified.

[sqlclusterSetup.cpp:1366] : 2 (0x2): The system cannot
find the file specified.

Best regards,
Ole
PAblo E. Colazurdo
2/2/2004 1:48:03 AM
[quoted text, click to view]

Can you give more details your configuration? What drive are you trying
to install the SQL on?
Any erros on the Event Viewer?
The results from command line command: cluster RES /PROP
and cluster RES /STATUS

I think thios would be enough to understand your configuration and what
could be failing there

Cheers,
Ole
2/2/2004 1:45:54 PM
Hi Pablo,

The issue has been resolved now: It appeared, that the MS
Search resource type was completely missing from the
Windows 2003 cluster. The error "The system cannot find
the file specified." was raised when the SQL setup program
was looking for the MS Search resource type in the cluster
database.

Unregistering and then re-registering Gathercl.dll brought
back the MS Search resource type - and after that the
setup completed without problems.

Thanks,
Ole

[quoted text, click to view]
Geoff N.Hiten
2/2/2004 4:15:29 PM
Make sure you have logged in to each server with the install account and the
service account. Otherwise, there may be some directories that SQL Setup
needs for temporary use that are not created yet.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

[quoted text, click to view]

AddThis Social Bookmark Button