August 2, 2007 at 10:27 am
I am trying to setup SQL Server 2000 on Windows 2003 R2 (SP1). The installation fails after I give all the required information. The sqlstp.log file has the following entries.
16:37:19 Setup is performing required operations on cluster nodes. This may take a few minutes...
16:37:19 C:\DOCUME~1\ZZZ_IN~1\LOCALS~1\Temp\2\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini
16:37:57 Process Exit Code: (2) The system cannot find the file specified.
As per the KB Article http://support.microsoft.com/kb/301520 , SQL Server 2000 is not supported on Windows 2003 Terminal server Application server.
I have setup the Windows cluster run under Remote Administration Mode but still the setup fails.
Can anyone please suggest a way out?
August 2, 2007 at 11:02 am
I would like to check whether or not the windows cluster is in a good shape. Try to move or failover the nodes and see whether or not the cluser functions well.
August 2, 2007 at 11:10 am
The cluster is in good shape. I am able to failover to/from the other node. I tried the failover by restarting the primary and was able to get the services on to the other node.
Is there anything else I should try to check the cluster's shape?
August 7, 2007 at 7:35 am
A long shot, but make sure your Networks (i.e. friendly name for NICs in 'Network Connections') are named EXACTLY the same on each Node, e.g. "Public', "Heatbeat1" etc. Even a space after one of the names on a Node (hard to see) can cause SQL Clustered Setup to fail, even though the Cluster itself (MSCS) appears to be behaving itself.
August 7, 2007 at 1:23 pm
I had blank spaces in the Friendly Network names 'Public Cluster Connection' and 'Private Cluster Connection' and tried removing them. I renamed them as 'PublicClusterConnection' and 'PrivateClusterConnection'. Even after doing so, the installation failed with the exact same message.
I have the following message on the sqlstp.log
[DlgVirtServer]
Result = 1
VirtServerName = PRODSQLVS
IpAddresses = 10.130.20.99,255.255.255.0,PublicClusterConnection
ShowDlgVirtualServer returned: -1
ShowDlgVirtualServer: GetLastError returned: 87
The parameter is incorrect.
End Action DialogShowSdVirtualServer
End Action ShowDialogs
Action CleanUpInstall:
StatsGenerate returned: 2
StatsGenerate (0x0,0x1,0xf00000,0x100,1033,0,0x0,0x1000000a,0,0,0
StatsGenerate -1,cluster_sql)
Installation Failed.
Can anyone please suggest a workaround?
October 1, 2007 at 3:15 am
Take a look at this guide.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
Best regards
Diego
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply