A problem of install SQL server on win2003 cluster | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

A problem of install SQL server on win2003 cluster

I have two HP DL560 server running on windows 2003 cluster. The cluster and the MSDTC service is running well. When I just installed SQL server 2000 enterprise on the windows 2003 server,I met a problem.I want to install the SQL server with virtual server mode.After the installation shield register me to input the virual server name,server’s IP address,volume of database saved,possible cluster node and administrator’s password,when I click "next" to continue,the installation is canceled automatic.After several minutes,the "sqlsetup" process is killed by system.
But if the server is running without cluster,the installation program can complete finish.
What a strange thing it is. It have puzzled me for three days now.
Please help me, thanks a lot! I am glad to meet you

SQL creates a log file on your c: drive called something like sqlsetup.log? (others may correct me here) check if there are any errors in here…? also I assume that there are no error message in the event logs? Cheers
Twan
Thanks for your answer,I will check it.
And did anyone meet this problem ?
I am glad to meet you
Hi ya,<br /><br />no I’ve installed 4 w2k3 clusters with no real issues, nothing as sever as this anyway <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br />Cheers<br />Twan
I have never seen this issue either. If I were faced with it, I would probably rebuild my servers from scrath, paying particular attention to all the details to ensure I wasn’t making any mistakes. Also, be sure all of your hardware is on the Microsoft HCL. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
Same problem here. When we installed the SQL-Instances at the Windows 2003 cluster, sometimes the installation aborted with a "performance-error" message. After some trying, all seven instances were finally installed correctly on the cluster. But as we installed SP3a after, the same strange behavior occured. The installation of the SP aborted three times. After some trying we got the SPs running. We also use HP Proliant DL560 as nodes. Everything is on the MS HCL.
All in all we have three two-node-cluster (six DL560). All servers are absolut identical. On every cluster the OS is Win2003 with several SQL2000 SP3a instances installed. Strange Installation occured on Cluster two and three. Cluster one went fine. Now everything is installed on the clusters, cluster2 is still making trouble while cluster1 and cluster 2 are OK. When initiating a failover on cluster2 all instance move to the other node except one instance. Alway the last instance to be moved fails on the other node (exactly the SQL Agent ressource fails) and moves back to zhe original node. After rebooting both nodes the behaviour is gone and i can move all instances. Some hours later the same happens again: alls groups are movable, except one. It not always the same ressource, its alway the last one. Does anybody have an idea?
Greetings from Germany (sorry for my english)
Tolwyn
I have not seen this behavior. But if I did, I would be on the phone immediately with Microsoft Support to figure it out. This is definitely not normal. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
Thanks for all answer.
Yesterday afternoon I reinstalled my two HP DL 560 with OS windows 2000 advanced server.Then I configed two-nodes cluster and the cluster went fine.But when I installed SQL server 2000 enterprise ,the same issue occured.What a strange thing!I just paste the "sqlstp.log".I hope you can read it and give some way to resolve this hard question.
The log created by the time when I installed SQL on my second node.
the log is:
17:48:00 Begin Setup
17:48:00 8.00.194
17:48:00 Mode = Normal
17:48:00 ModeType = NORMAL
17:48:00 GetDefinitionEx returned: 0, Extended: 0x0
17:48:00 ValueFTS returned: 1
17:48:00 ValuePID returned: 1
17:48:00 ValueLic returned: 1
17:48:00 System: Windows NT Enterprise Server
17:48:00 SQL Server ProductType: Enterprise Edition [0x3]
17:48:00 IsNTCluster returned: 0
17:48:00 Begin Action: SetupInitialize
17:48:00 End Action SetupInitialize
17:48:00 Begin Action: SetupInstall
17:48:00 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesDir …
17:48:00 CommonFilesDir=C:program FilesCommon Files
17:48:00 Windows Directory=C:WINDOWS17:48:00 Program Files=C:program Files17:48:00 TEMPDIR=C:WINDOWSTEMP17:48:00 Begin Action: SetupInstall
17:48:00 digpid size : 256
17:48:00 digpid size : 164
17:48:00 Begin Action: CheckFixedRequirements
17:48:00 Platform ID: 0xf00000
17:48:00 Version: 5.2.3790
17:48:00 File Version – C:WINDOWSsystem32shdocvw.dll: 6.0.3790.0
17:48:00 End Action: CheckFixedRequirements
17:48:01 Begin Action: ShowDialogs
17:48:01 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
17:48:01 Begin Action ShowDialogsHlpr: 0x1
17:48:01 Begin Action: DialogShowSdWelcome
17:48:02 End Action DialogShowSdWelcome
17:48:02 Dialog 0x1 returned: 1
17:48:02 End Action ShowDialogsHlpr
17:48:02 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
17:48:02 Begin Action ShowDialogsHlpr: 0x2
17:48:02 Begin Action: DialogShowSdMachineName
17:48:07 ShowDlgMachine returned: 1
17:48:07 Name = CLUSTER-SERVER1, Type = 0x1
17:48:07 Begin Action: CheckRequirements
17:48:07 Processor Architecture: x86 (Pentium)
17:48:07 ComputerName: CLUSTER-SERVER1
17:48:07 User Name: Administrator
17:48:07 IsAllAccessAllowed returned: 1
17:48:07 OS Language: 0x804
17:48:07 End Action CheckRequirements
17:48:07 This combination of Package and Operating System allows a full product install.
17:48:07 CreateSetupTopology(CLUSTER-SERVER1), Handle : 0x16940f8, returned : 0
17:48:07 CreateSetupTopology returned : 0, Handle : 0x16940f8
17:48:07 Topology Type : 1, Return Value : 0
17:48:07 ST_GetPhysicalNode returned : 0, PNHandle : 0x1694148
17:48:07 PN_EnumerateEx returned : 0
17:48:07 PN_GetSQLStates returned : 0, SqlStates : 0x0
17:48:07 PN_StartScan [0x1694148] returned : 0
17:48:07 PN_GetNext [0x1694148] returned : 18, Handle: [0x0]
17:48:07 No more items in enumeration.
17:48:07 ReleaseSetupTopology
17:48:07 Named instance limit: 100, quota: 0
17:48:07 End Action DialogShowSdMachineName
17:48:07 begin ShowDialogsUpdateMask
17:48:07 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
17:48:07 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
17:48:07 Dialog 0x2 returned: 0
17:48:07 End Action ShowDialogsHlpr
17:48:07 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
17:48:07 Begin Action ShowDialogsHlpr: 0x4
17:48:07 Begin Action: DialogShowSdInstallMode
17:48:09 ShowDlgInstallMode returned: 1
17:48:09 InstallMode : 0x1
17:48:09 End Action DialogShowSdInstallMode
17:48:09 begin ShowDialogsUpdateMask
17:48:09 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
17:48:09 Updated Dialog Mask: 0x1bf40037, Disable Back = 0x1
17:48:09 Dialog 0x4 returned: 1
17:48:09 End Action ShowDialogsHlpr
17:48:09 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
17:48:09 Begin Action ShowDialogsHlpr: 0x10
17:48:09 Begin Action: DialogShowSdRegisterUserEx
17:48:11 End Action DialogShowSdRegisterUserEx
17:48:11 Dialog 0x10 returned: 1
17:48:11 End Action ShowDialogsHlpr
17:48:11 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
17:48:11 Begin Action ShowDialogsHlpr: 0x20
17:48:11 Begin Action: DialogShowSdLicense
17:48:12 End Action DialogShowSdLicense
17:48:12 Dialog 0x20 returned: 1
17:48:12 End Action ShowDialogsHlpr
17:48:12 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
17:48:12 Begin Action ShowDialogsHlpr: 0x40000
17:48:12 Begin Action: DialogShowSdCliSvr
17:48:12 DisplaySystemPreReq
17:48:14 ShowDlgClientServerSelect returned: 1
17:48:14 Type : 0x2
17:48:14 End Action DialogShowSdCliSvr
17:48:14 begin ShowDialogsUpdateMask
17:48:14 nFullMask = 0x1bf40037, nCurrent = 0x40000, nDirection = 1
17:48:14 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
17:48:14 Dialog 0x40000 returned: 1
17:48:14 End Action ShowDialogsHlpr
17:48:14 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
17:48:14 Begin Action ShowDialogsHlpr: 0x80000
17:48:14 Begin Action: DialogShowSdInstanceName
17:48:14 Begin Action: ShowDlgInstanceName
17:48:15 End Action: ShowDlgInstanceName
17:48:15 ShowDlgInstanceName returned : 1
17:48:15 InstanceName : MSSQLSERVER
17:48:15 CreateSetupTopology(CLUSTER-SERVER1), Handle : 0x16940f8, returned : 0
17:48:15 CreateSetupTopology returned : 0, Handle : 0x16940f8
17:48:15 Topology Type : 1, Return Value : 0
17:48:15 ST_GetPhysicalNode returned : 0, PNHandle : 0x1694148
17:48:15 PN_EnumerateEx returned : 0
17:48:15 PN_GetSQLStates returned : 0, SqlStates : 0x0
17:48:15 PN_StartScan [0x1694148] returned : 0
17:48:15 PN_GetNext [0x1694148] returned : 18, Handle: [0x0]
17:48:15 No more items in enumeration.
17:48:15 ReleaseSetupTopology
17:48:15 End Action DialogShowSdInstanceName
17:48:15 begin ShowDialogsUpdateMask
17:48:15 nFullMask = 0x1bfc0037, nCurrent = 0x80000, nDirection = 1
17:48:15 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
17:48:15 Dialog 0x80000 returned: 1
17:48:15 End Action ShowDialogsHlpr
17:48:15 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
17:48:15 Begin Action ShowDialogsHlpr: 0x100000
17:48:15 Begin Action: DialogShowSdSetupType
17:48:15 Begin Action: Setup Type
17:48:44 Action Exit Handler:
17:48:46 StatsGenerate returned: 2
17:48:46 StatsGenerate (0x0,0x1,0xf00000,0x0,2052,303,0×0,0x1,0,0,0
17:48:46 StatsGenerate -1,Administrator) —————-
thanks a lot for all of you I am glad to meet you
the newest log file of today is:
10:47:29 Begin Setup
10:47:29 8.00.194
10:47:29 Mode = Normal
10:47:29 ModeType = NORMAL
10:47:29 GetDefinitionEx returned: 0, Extended: 0x0
10:47:29 ValueFTS returned: 1
10:47:29 ValuePID returned: 1
10:47:29 ValueLic returned: 1
10:47:29 System: Windows NT Enterprise Server
10:47:29 SQL Server ProductType: Enterprise Edition [0x3]
10:47:29 IsNTCluster returned: 1
10:47:29 Begin Action: SetupInitialize
10:47:29 End Action SetupInitialize
10:47:29 Begin Action: SetupInstall
10:47:29 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesDir …
10:47:29 CommonFilesDir=C:program FilesCommon Files
10:47:29 Windows Directory=C:WINNT10:47:29 Program Files=C:program Files10:47:29 TEMPDIR=C:WINNTTEMP10:47:29 Begin Action: SetupInstall
10:47:29 digpid size : 256
10:47:29 digpid size : 164
10:47:29 Begin Action: CheckFixedRequirements
10:47:29 Platform ID: 0xf00000
10:47:29 Version: 5.0.2195
10:47:29 File Version – C:WINNTSystem32shdocvw.dll: 5.0.2920.0
10:47:29 End Action: CheckFixedRequirements
10:47:29 Begin Action: ShowDialogs
10:47:29 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
10:47:29 Begin Action ShowDialogsHlpr: 0x1
10:47:29 Begin Action: DialogShowSdWelcome
10:47:31 End Action DialogShowSdWelcome
10:47:31 Dialog 0x1 returned: 1
10:47:31 End Action ShowDialogsHlpr
10:47:31 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
10:47:31 Begin Action ShowDialogsHlpr: 0x2
10:47:31 Begin Action: DialogShowSdMachineName
10:47:46 ShowDlgMachine returned: 1
10:47:46 Name = CNLMG-SQL, Type = 0x10000008
10:47:46 Begin Action: CheckRequirements
10:47:46 Processor Architecture: x86 (Pentium)
10:47:46 ComputerName: CLUSTER-SERVER2
10:47:46 User Name: Administrator
10:47:46 IsAllAccessAllowed returned: 1
10:47:46 OS Language: 0x804
10:47:46 End Action CheckRequirements
10:47:46 This combination of Package and Operating System allows a full product install.
10:47:46 End Action DialogShowSdMachineName
10:47:46 begin ShowDialogsUpdateMask
10:47:46 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
10:47:46 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
10:47:46 Dialog 0x2 returned: 0
10:47:46 End Action ShowDialogsHlpr
10:47:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
10:47:46 Begin Action ShowDialogsHlpr: 0x4
10:47:46 Begin Action: DialogShowSdInstallMode
10:47:46 InstallMode : 0x1
10:47:46 End Action DialogShowSdInstallMode
10:47:46 begin ShowDialogsUpdateMask
10:47:46 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
10:47:46 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
10:47:46 Dialog 0x4 returned: 1
10:47:46 End Action ShowDialogsHlpr
10:47:46 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
10:47:46 Begin Action ShowDialogsHlpr: 0x10
10:47:46 Begin Action: DialogShowSdRegisterUserEx
10:48:16 End Action DialogShowSdRegisterUserEx
10:48:16 begin ShowDialogsUpdateMask
10:48:16 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
10:48:16 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
10:48:16 Dialog 0x10 returned: 1
10:48:16 End Action ShowDialogsHlpr
10:48:16 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
10:48:16 Begin Action ShowDialogsHlpr: 0x20
10:48:16 Begin Action: DialogShowSdLicense
10:48:20 End Action DialogShowSdLicense
10:48:20 Dialog 0x20 returned: 1
10:48:20 End Action ShowDialogsHlpr
10:48:20 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
10:48:20 Begin Action ShowDialogsHlpr: 0x4000
10:48:20 Begin Action: DialogShowSdVirtualServer
10:48:41 ShowDlgVirtualServer returned: 0
10:48:41 Ipaddress = 202.197.81.229,255.255.255.240,1ºÅÍø¿¨
10:48:41 szNewList = 202.197.81.229,255.255.255.240,1ºÅÍø¿¨
10:48:41 szModifiedList =
10:48:41 szRemovedList =
10:48:41 End Action DialogShowSdVirtualServer
10:48:41 begin ShowDialogsUpdateMask
10:48:41 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
10:48:41 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
10:48:41 Dialog 0x4000 returned: 1
10:48:41 End Action ShowDialogsHlpr
10:48:41 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
10:48:41 Begin Action ShowDialogsHlpr: 0x8000
10:48:41 Begin Action : DialogShowSdDiskGroups
10:48:46 ShowDlgDiskGroups returned: 1
10:48:46 Disk Group = group 0
10:48:46 End Action : DialogShowSdDiskGroups
10:48:46 begin ShowDialogsUpdateMask
10:48:46 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
10:48:46 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
10:48:46 Dialog 0x8000 returned: 1
10:48:46 End Action ShowDialogsHlpr
10:48:46 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
10:48:46 Begin Action ShowDialogsHlpr: 0x10000
10:48:46 Begin Action: DialogShowSdClusterDef
10:48:47 ShowDlgClusterDef returned: 1
10:48:47 PrefOwners = CLUSTER-SERVER2,CLUSTER-SERVER1, NumIp = 2
10:48:47 Begin Action : ValidateNodeActions
10:48:47 Begin Action : ValidateNodeActions
10:48:47 End Action : ValidateNodeActions
10:48:47 End Action : ValidateNodeActions
10:48:47 End Action DialogShowSdClusterDef
10:48:47 begin ShowDialogsUpdateMask
10:48:47 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
10:48:47 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
10:48:47 Dialog 0x10000 returned: 1
10:48:47 End Action ShowDialogsHlpr
10:48:47 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
10:48:47 Begin Action ShowDialogsHlpr: 0x20000
10:48:47 Begin Action : Cluster Security – DlgAcct I am glad to meet you
Have a look here:
http://www.mcse.ms/message1181335.html Especially:
PRB: Installation of a named instance of SQL Server 2000 virtual server on a Windows 2003-based cluster fails
http://support.microsoft.com/?id=815431 SQL Server 2000 cluster does not install on Windows Server 2003-based computers where Terminal Services is installed
http://support.microsoft.com/?id=301520

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |