A problem of install SQL server on win2003 cluster

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

A problem of install SQL server on win2003 cluster

Author

Topic

muchengxue
Starting Member

2 Posts

Posted - 2004-11-12 : 03:33:35

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!

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-11-12 : 13:10:50

I don't mean to hijack your thread, but I'm having issues with MSDTC install. The docs say that MSDTC needs it's own IP, Disks, etc.
How large of a disk does it need? 1GB? 20GB??
Can it be shared with something else?

With your problem, did you look at the Event log and I think there's a SQL install log file someplace on your machine. Look for all .Log files.

Thanks!
Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-11-12 : 17:23:50

What errors do you see in your sqlstp.log? this is located in your windows directory.

-ec

muchengxue
Starting Member

2 Posts

Posted - 2004-11-14 : 07:50:26

There are no errors appeared.I just looked the sqlstp.log.Because the installation had not went to copy the files,so the sqlsetup.log was not created.
The following is sqlstp.log:
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 Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
10:47:29 CommonFilesDir=C:\Program Files\Common Files
10:47:29 Windows Directory=C:\WINNT10:47:29 Program Files=C:\Program Files10:47:29 TEMPDIR=C:\WINNT\TEMP10: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:\WINNT\System32\shdocvw.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

----------------
Did it is anything wrong?
Please tell me about it.
Thanks a lot!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources