dbTalk Databases Forums  

SQL 2000 Cluster & Win 2003 Setup Issue

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL 2000 Cluster & Win 2003 Setup Issue in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Al
 
Posts: n/a

Default SQL 2000 Cluster & Win 2003 Setup Issue - 08-13-2004 , 11:03 AM






I am trying to install SQL 2K onto a Win 2003 Ent. Ed. machine to create an
Active-Passive node. The installation gets as far as the Remote Information
dialog for me to provide a valid administrator account. After putting in
valid details the setup crashes with no error.

The only clues I have are the App Event Log;

Faulting application _INS5576._MP, version 5.53.168.0, faulting module
unknown, version 0.0.0.0, fault address 0x00000000.

And the sqlstp.log file

16:44:05 Begin Setup
16:44:05 8.00.194
16:44:05 Mode = Normal
16:44:05 ModeType = NORMAL
16:44:05 GetDefinitionEx returned: 0, Extended: 0x0
16:44:05 ValueFTS returned: 1
16:44:05 ValuePID returned: 1
16:44:05 ValueLic returned: 1
16:44:05 System: Windows NT Enterprise Server
16:44:05 SQL Server ProductType: Enterprise Edition [0x3]
16:44:05 IsNTCluster returned: 1
16:44:05 Begin Action: SetupInitialize
16:44:05 End Action SetupInitialize
16:44:05 Begin Action: SetupInstall
16:44:05 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
16:44:05 CommonFilesDir=C:\Program Files\Common Files
16:44:05 Windows Directory=C:\WINDOWS\
16:44:05 Program Files=C:\Program Files\
16:44:05 TEMPDIR=C:\DOCUME~1\ADMINI~1.ADE\LOCALS~1\Temp\1\
16:44:05 Begin Action: SetupInstall
16:44:05 digpid size : 256
16:44:05 digpid size : 164
16:44:05 Begin Action: CheckFixedRequirements
16:44:05 Platform ID: 0xf00000
16:44:05 Version: 5.2.3790
16:44:05 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.186
16:44:05 End Action: CheckFixedRequirements
16:44:06 Begin Action: ShowDialogs
16:44:06 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
16:44:06 Begin Action ShowDialogsHlpr: 0x1
16:44:06 Begin Action: DialogShowSdWelcome
16:44:08 End Action DialogShowSdWelcome
16:44:08 Dialog 0x1 returned: 1
16:44:08 End Action ShowDialogsHlpr
16:44:08 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
16:44:08 Begin Action ShowDialogsHlpr: 0x2
16:44:08 Begin Action: DialogShowSdMachineName
16:44:21 ShowDlgMachine returned: 1
16:44:21 Name = GCISQL, Type = 0x10000008
16:44:21 Begin Action: CheckRequirements
16:44:21 Processor Architecture: x86 (Pentium)
16:44:21 ComputerName: NMR044BRASQL720
16:44:21 User Name: Administrator
16:44:21 IsAllAccessAllowed returned: 1
16:44:21 OS Language: 0x809
16:44:21 End Action CheckRequirements
16:44:21 This combination of Package and Operating System allows a full
product install.
16:44:21 End Action DialogShowSdMachineName
16:44:21 begin ShowDialogsUpdateMask
16:44:21 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
16:44:21 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
16:44:21 Dialog 0x2 returned: 0
16:44:21 End Action ShowDialogsHlpr
16:44:21 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
16:44:21 Begin Action ShowDialogsHlpr: 0x4
16:44:21 Begin Action: DialogShowSdInstallMode
16:44:21 InstallMode : 0x1
16:44:21 End Action DialogShowSdInstallMode
16:44:21 begin ShowDialogsUpdateMask
16:44:21 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
16:44:21 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:44:21 Dialog 0x4 returned: 1
16:44:21 End Action ShowDialogsHlpr
16:44:21 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
16:44:21 Begin Action ShowDialogsHlpr: 0x10
16:44:21 Begin Action: DialogShowSdRegisterUserEx
16:44:24 End Action DialogShowSdRegisterUserEx
16:44:24 begin ShowDialogsUpdateMask
16:44:24 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
16:44:24 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:44:24 Dialog 0x10 returned: 1
16:44:24 End Action ShowDialogsHlpr
16:44:24 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
16:44:24 Begin Action ShowDialogsHlpr: 0x20
16:44:24 Begin Action: DialogShowSdLicense
16:44:24 End Action DialogShowSdLicense
16:44:24 Dialog 0x20 returned: 1
16:44:24 End Action ShowDialogsHlpr
16:44:24 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
16:44:24 Begin Action ShowDialogsHlpr: 0x4000
16:44:24 Begin Action: DialogShowSdVirtualServer
16:46:27 ShowDlgVirtualServer returned: 0
16:46:27 Ipaddress = 10.64.119.84,255.255.255.0,Local Area Connection
16:46:27 szNewList = 10.64.119.84,255.255.255.0,Local Area Connection
16:46:27 szModifiedList =
16:46:27 szRemovedList =
16:46:27 End Action DialogShowSdVirtualServer
16:46:27 begin ShowDialogsUpdateMask
16:46:27 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
16:46:27 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:46:27 Dialog 0x4000 returned: 1
16:46:27 End Action ShowDialogsHlpr
16:46:27 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
16:46:27 Begin Action ShowDialogsHlpr: 0x8000
16:46:27 Begin Action : DialogShowSdDiskGroups
16:46:28 ShowDlgDiskGroups returned: 1
16:46:28 Disk Group = GCISQL
16:46:28 End Action : DialogShowSdDiskGroups
16:46:28 begin ShowDialogsUpdateMask
16:46:28 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
16:46:28 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:46:28 Dialog 0x8000 returned: 1
16:46:28 End Action ShowDialogsHlpr
16:46:28 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
16:46:28 Begin Action ShowDialogsHlpr: 0x10000
16:46:28 Begin Action: DialogShowSdClusterDef
16:46:30 ShowDlgClusterDef returned: 1
16:46:30 PrefOwners = NMR044BRASQL720,NMR044BRASQL719, NumIp = 2
16:46:30 Begin Action : ValidateNodeActions
16:46:30 Begin Action : ValidateNodeActions
16:46:30 End Action : ValidateNodeActions
16:46:30 End Action : ValidateNodeActions
16:46:30 End Action DialogShowSdClusterDef
16:46:30 begin ShowDialogsUpdateMask
16:46:30 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
16:46:30 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:46:30 Dialog 0x10000 returned: 1
16:46:30 End Action ShowDialogsHlpr
16:46:30 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
16:46:30 Begin Action ShowDialogsHlpr: 0x20000
16:46:30 Begin Action : Cluster Security - DlgAcct

My current research points to an InstallShield failure but the fixes I have
tried have so far be unsuccessful.

Al

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: SQL 2000 Cluster & Win 2003 Setup Issue - 08-13-2004 , 11:24 AM






Quick checklist.

Cluster host nodes are domain members (NOT Controllers)
All accounts are domain-level
Cluster service account is a local admin on all hosts.
Install account is local admin on all hosts
SQL Service account is local admin on all hosts.
You have logged into the console of each host using all three accounts.
You run the install from the node that owns the physical resource you are
installing SQL to.


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

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

"Al" <Al (AT) discussions (DOT) microsoft.com> wrote

Quote:
I am trying to install SQL 2K onto a Win 2003 Ent. Ed. machine to create
an
Active-Passive node. The installation gets as far as the Remote
Information
dialog for me to provide a valid administrator account. After putting in
valid details the setup crashes with no error.

The only clues I have are the App Event Log;

Faulting application _INS5576._MP, version 5.53.168.0, faulting module
unknown, version 0.0.0.0, fault address 0x00000000.

And the sqlstp.log file

16:44:05 Begin Setup
16:44:05 8.00.194
16:44:05 Mode = Normal
16:44:05 ModeType = NORMAL
16:44:05 GetDefinitionEx returned: 0, Extended: 0x0
16:44:05 ValueFTS returned: 1
16:44:05 ValuePID returned: 1
16:44:05 ValueLic returned: 1
16:44:05 System: Windows NT Enterprise Server
16:44:05 SQL Server ProductType: Enterprise Edition [0x3]
16:44:05 IsNTCluster returned: 1
16:44:05 Begin Action: SetupInitialize
16:44:05 End Action SetupInitialize
16:44:05 Begin Action: SetupInstall
16:44:05 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir
....
16:44:05 CommonFilesDir=C:\Program Files\Common Files
16:44:05 Windows Directory=C:\WINDOWS\
16:44:05 Program Files=C:\Program Files\
16:44:05 TEMPDIR=C:\DOCUME~1\ADMINI~1.ADE\LOCALS~1\Temp\1\
16:44:05 Begin Action: SetupInstall
16:44:05 digpid size : 256
16:44:05 digpid size : 164
16:44:05 Begin Action: CheckFixedRequirements
16:44:05 Platform ID: 0xf00000
16:44:05 Version: 5.2.3790
16:44:05 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.186
16:44:05 End Action: CheckFixedRequirements
16:44:06 Begin Action: ShowDialogs
16:44:06 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
16:44:06 Begin Action ShowDialogsHlpr: 0x1
16:44:06 Begin Action: DialogShowSdWelcome
16:44:08 End Action DialogShowSdWelcome
16:44:08 Dialog 0x1 returned: 1
16:44:08 End Action ShowDialogsHlpr
16:44:08 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
16:44:08 Begin Action ShowDialogsHlpr: 0x2
16:44:08 Begin Action: DialogShowSdMachineName
16:44:21 ShowDlgMachine returned: 1
16:44:21 Name = GCISQL, Type = 0x10000008
16:44:21 Begin Action: CheckRequirements
16:44:21 Processor Architecture: x86 (Pentium)
16:44:21 ComputerName: NMR044BRASQL720
16:44:21 User Name: Administrator
16:44:21 IsAllAccessAllowed returned: 1
16:44:21 OS Language: 0x809
16:44:21 End Action CheckRequirements
16:44:21 This combination of Package and Operating System allows a full
product install.
16:44:21 End Action DialogShowSdMachineName
16:44:21 begin ShowDialogsUpdateMask
16:44:21 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
16:44:21 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
16:44:21 Dialog 0x2 returned: 0
16:44:21 End Action ShowDialogsHlpr
16:44:21 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
16:44:21 Begin Action ShowDialogsHlpr: 0x4
16:44:21 Begin Action: DialogShowSdInstallMode
16:44:21 InstallMode : 0x1
16:44:21 End Action DialogShowSdInstallMode
16:44:21 begin ShowDialogsUpdateMask
16:44:21 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
16:44:21 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:44:21 Dialog 0x4 returned: 1
16:44:21 End Action ShowDialogsHlpr
16:44:21 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
16:44:21 Begin Action ShowDialogsHlpr: 0x10
16:44:21 Begin Action: DialogShowSdRegisterUserEx
16:44:24 End Action DialogShowSdRegisterUserEx
16:44:24 begin ShowDialogsUpdateMask
16:44:24 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
16:44:24 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:44:24 Dialog 0x10 returned: 1
16:44:24 End Action ShowDialogsHlpr
16:44:24 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
16:44:24 Begin Action ShowDialogsHlpr: 0x20
16:44:24 Begin Action: DialogShowSdLicense
16:44:24 End Action DialogShowSdLicense
16:44:24 Dialog 0x20 returned: 1
16:44:24 End Action ShowDialogsHlpr
16:44:24 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
16:44:24 Begin Action ShowDialogsHlpr: 0x4000
16:44:24 Begin Action: DialogShowSdVirtualServer
16:46:27 ShowDlgVirtualServer returned: 0
16:46:27 Ipaddress = 10.64.119.84,255.255.255.0,Local Area Connection
16:46:27 szNewList = 10.64.119.84,255.255.255.0,Local Area Connection
16:46:27 szModifiedList =
16:46:27 szRemovedList =
16:46:27 End Action DialogShowSdVirtualServer
16:46:27 begin ShowDialogsUpdateMask
16:46:27 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
16:46:27 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:46:27 Dialog 0x4000 returned: 1
16:46:27 End Action ShowDialogsHlpr
16:46:27 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
16:46:27 Begin Action ShowDialogsHlpr: 0x8000
16:46:27 Begin Action : DialogShowSdDiskGroups
16:46:28 ShowDlgDiskGroups returned: 1
16:46:28 Disk Group = GCISQL
16:46:28 End Action : DialogShowSdDiskGroups
16:46:28 begin ShowDialogsUpdateMask
16:46:28 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
16:46:28 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:46:28 Dialog 0x8000 returned: 1
16:46:28 End Action ShowDialogsHlpr
16:46:28 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
16:46:28 Begin Action ShowDialogsHlpr: 0x10000
16:46:28 Begin Action: DialogShowSdClusterDef
16:46:30 ShowDlgClusterDef returned: 1
16:46:30 PrefOwners = NMR044BRASQL720,NMR044BRASQL719, NumIp = 2
16:46:30 Begin Action : ValidateNodeActions
16:46:30 Begin Action : ValidateNodeActions
16:46:30 End Action : ValidateNodeActions
16:46:30 End Action : ValidateNodeActions
16:46:30 End Action DialogShowSdClusterDef
16:46:30 begin ShowDialogsUpdateMask
16:46:30 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
16:46:30 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:46:30 Dialog 0x10000 returned: 1
16:46:30 End Action ShowDialogsHlpr
16:46:30 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
16:46:30 Begin Action ShowDialogsHlpr: 0x20000
16:46:30 Begin Action : Cluster Security - DlgAcct

My current research points to an InstallShield failure but the fixes I
have
tried have so far be unsuccessful.

Al



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.