Re: SQL 2000 Problems on One Node Only

Tech-Archive recommends: Fix windows errors by optimizing your registry

This is the default instance on Win2003, not a named instance... The
setup logs look like:

sqlclstr.log:
ClusterGroupEnum(6): enter
ClusterGroupEnum(6): [SQL Server]
~~~ XXX OnlineClusterResource starts for SQL Server
~~~ ClusterResourceStart... tick=0, state=129
~~~ ClusterResourceStart... tick=1, state=129
**through**
~~~ ClusterResourceStart... tick=180, state=129
~~~ ClusterResourceStart... tick=181, state=4
~~~ XXX OnlineClusterResource failed
[sqlclusterSetup.cpp:1785] : 0xffffffff (-1): <<<FormatMessage failed:
317>>>
[sqlclusterSetup.cpp:1478] : 50049 (0xc381): <<<FormatMessage failed:
317>>>

dasetup.log:
....
State after Install:
Setup was Successful: 1
Setup Requires Reboot: 0
Setup Will Reboot the Machine: 0
Exiting: Setup is shutting down..

sqlstp16.log:
11:50:09 Begin Setup
11:50:09 8.00.194
11:50:09 Mode = Silent
11:50:09 ModeType = CLUSTER
11:50:09 Cluster node.
11:50:09 g_szIssPath=C:\WINDOWS\setup~0.iss
11:50:09 GetDefinitionEx returned: 0, Extended: 0x0
11:50:09 ValueFTS returned: 1
11:50:09 ValuePID returned: 1
11:50:09 ValueLic returned: 1
11:50:09 System: Windows NT Enterprise Server
11:50:09 SQL Server ProductType: Enterprise Edition [0x3]
11:50:09 IsNTCluster returned: 1
11:50:09 Begin Action: SetupInitialize
11:50:09 End Action SetupInitialize
11:50:09 Begin Action: SetupInstall
11:50:09 Reading
Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
11:50:09 CommonFilesDir=C:\Program Files\Common Files
11:50:09 Windows Directory=C:\WINDOWS\
11:50:09 Program Files=C:\Program Files\
11:50:09 TEMPDIR=C:\DOCUME~1\adminname\LOCALS~1\Temp\1\
11:50:09 Begin Action: SetupInstall
11:50:09 digpid size : 256
11:50:09 digpid size : 164
11:50:09 Begin Action: CheckFixedRequirements
11:50:09 Platform ID: 0xf00000
11:50:09 Version: 5.2.3790
11:50:09 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2480
11:50:09 End Action: CheckFixedRequirements
11:50:10 Begin Action: ShowDialogs
11:50:10 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
11:50:10 Begin Action ShowDialogsHlpr: 0x1
11:50:10 Begin Action: DialogShowSdWelcome
11:50:10 End Action DialogShowSdWelcome
11:50:10 Dialog 0x1 returned: 1
11:50:10 End Action ShowDialogsHlpr
11:50:10 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
11:50:10 Begin Action ShowDialogsHlpr: 0x2
11:50:10 Begin Action: DialogShowSdMachineName
11:50:10 [DlgMachine]
11:50:10 Result = 1
11:50:10 Type = 268435466
11:50:10 Name = Node1
11:50:10 ShowDlgMachine returned: 1
11:50:10 Name = Node1, Type = 0x1000000a
11:50:10 Begin Action: CheckRequirements
11:50:10 Processor Architecture: x86 (Pentium)
11:50:10 Service Pack: 256
11:50:10 ComputerName: Node1
11:50:10 User Name: adminname
11:50:10 IsAllAccessAllowed returned: 1
11:50:10 OS Language: 0x409
11:50:10 End Action CheckRequirements
11:50:10 This combination of Package and Operating System allows a full
product install.
11:50:10 End Action DialogShowSdMachineName
11:50:10 begin ShowDialogsUpdateMask
11:50:10 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
11:50:10 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
11:50:10 Dialog 0x2 returned: 0
11:50:10 End Action ShowDialogsHlpr
11:50:10 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
11:50:10 Begin Action ShowDialogsHlpr: 0x4
11:50:10 Begin Action: DialogShowSdInstallMode
11:50:10 [DlgInstallMode]
11:50:10 Result = 1
11:50:10 Type = 1
11:50:10 InstallMode : 0x1
11:50:10 End Action DialogShowSdInstallMode
11:50:10 begin ShowDialogsUpdateMask
11:50:10 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
11:50:10 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
11:50:10 Dialog 0x4 returned: 1
11:50:10 End Action ShowDialogsHlpr
11:50:10 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
11:50:10 Begin Action ShowDialogsHlpr: 0x10
11:50:10 Begin Action: DialogShowSdRegisterUserEx
11:50:10 End Action DialogShowSdRegisterUserEx
11:50:10 begin ShowDialogsUpdateMask
11:50:10 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
11:50:10 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
11:50:10 Dialog 0x10 returned: 1
11:50:10 End Action ShowDialogsHlpr
11:50:10 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
11:50:10 Begin Action ShowDialogsHlpr: 0x20
11:50:10 Begin Action: DialogShowSdLicense
11:50:10 End Action DialogShowSdLicense
11:50:10 Dialog 0x20 returned: 1
11:50:10 End Action ShowDialogsHlpr
11:50:10 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
11:50:10 Begin Action ShowDialogsHlpr: 0x4000
11:50:10 Begin Action: DialogShowSdVirtualServer
11:50:10 [DlgVirtServer]
11:50:10 Result = 1
11:50:10 VirtServerName = VIRTUALNAME
11:50:10 IpAddresses = virtual.ip,virtual.subnet,Network
11:50:14 ShowDlgVirtualServer returned: 0
11:50:14 Ipaddress = virtual.ip,virtual.subnet,Network
11:50:14 szNewList = virtual.ip,virtual.subnet,Network
11:50:14 szModifiedList =
11:50:14 szRemovedList =
11:50:14 End Action DialogShowSdVirtualServer
11:50:14 begin ShowDialogsUpdateMask
11:50:14 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
11:50:14 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
11:50:14 Dialog 0x4000 returned: 1
11:50:14 End Action ShowDialogsHlpr
11:50:14 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
11:50:14 Begin Action ShowDialogsHlpr: 0x8000
11:50:14 Begin Action : DialogShowSdDiskGroups
11:50:14 [DlgDiskGroups]
11:50:14 Result = 1
11:50:14 DiskGroupsName = VirtualDiskGroup
11:50:14 ShowDlgDiskGroups returned: 1
11:50:14 Disk Group = VirtualDiskGroup
11:50:14 End Action : DialogShowSdDiskGroups
11:50:14 begin ShowDialogsUpdateMask
11:50:14 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
11:50:14 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
11:50:14 Dialog 0x8000 returned: 1
11:50:14 End Action ShowDialogsHlpr
11:50:14 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
11:50:14 Begin Action ShowDialogsHlpr: 0x10000
11:50:14 Begin Action: DialogShowSdClusterDef
11:50:14 [DlgClusterDef]
11:50:14 Result = 1
11:50:14 nNumNodes = 2
11:50:14 VirtServerName = VirtualName
11:50:14 szPrefowners = Node1,Node2
11:50:14 ShowDlgClusterDef returned: 1
11:50:14 PrefOwners = Node1,Node2, NumIp = 0
11:50:14 End Action DialogShowSdClusterDef
11:50:14 begin ShowDialogsUpdateMask
11:50:14 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
11:50:14 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
11:50:14 Dialog 0x10000 returned: 1
11:50:14 End Action ShowDialogsHlpr
11:50:14 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
11:50:14 Begin Action ShowDialogsHlpr: 0x20000
11:50:14 Begin Action : Cluster Security - DlgAcct
11:50:14 [DlgAccount]
11:50:14 Result = 1
11:50:14 Domain = DomainName
11:50:14 DomainAcct = AdminName
11:50:14 DomainPwd
11:50:14 ValidateUser returned: 1, 0, 0x15c
11:50:14 IsAcctValidForCluster returned: 1, 0
11:50:14 End Action : Cluster Security - DlgAcct
11:50:14 begin ShowDialogsUpdateMask
11:50:14 nFullMask = 0x1bf7c037, nCurrent = 0x20000, nDirection = 1
11:50:14 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
11:50:14 Dialog 0x20000 returned: 1
11:50:14 End Action ShowDialogsHlpr
11:50:14 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
11:50:14 Begin Action ShowDialogsHlpr: 0x40000
11:50:14 Begin Action: DialogShowSdCliSvr
11:50:14 DisplaySystemPreReq
11:50:14 [DlgClientServer]
11:50:14 Result = 1
11:50:14 Type = 2
11:50:14 ShowDlgClientServerSelect returned: 1
11:50:14 Type : 0x2
11:50:14 End Action DialogShowSdCliSvr
11:50:14 begin ShowDialogsUpdateMask
11:50:14 nFullMask = 0x1bf7c037, nCurrent = 0x40000, nDirection = 1
11:50:14 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
11:50:14 Dialog 0x40000 returned: 1
11:50:14 End Action ShowDialogsHlpr
11:50:14 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
11:50:14 Begin Action ShowDialogsHlpr: 0x80000
11:50:14 Begin Action: DialogShowSdInstanceName
11:50:14 [DlgInstanceName]
11:50:14 Result = 1
11:50:14 InstanceName = MSSQLSERVER
11:50:14 Begin Action: ShowDlgInstanceName
11:50:15 End Action: ShowDlgInstanceName
11:50:15 ShowDlgInstanceName returned : 1
11:50:15 InstanceName : MSSQLSERVER
11:50:15 CreateSetupTopology(Node1), Handle : 0x1454e28, returned : 0
11:50:15 CreateSetupTopology returned : 0, Handle : 0x1454e28
11:50:15 Topology Type : 1, Return Value : 0
11:50:15 ST_GetPhysicalNode returned : 0, PNHandle : 0x1454e50
11:50:15 PN_EnumerateEx returned : 0
11:50:15 PN_GetSQLStates returned : 0, SqlStates : 0xc0200006
11:50:15 PN_StartScan [0x1454e50] returned : 0
11:50:15 PN_GetNext [0x1454e50] returned : 18, Handle: [0x0]
11:50:15 No more items in enumeration.
11:50:15 ReleaseSetupTopology
11:50:15 End Action DialogShowSdInstanceName
11:50:15 begin ShowDialogsUpdateMask
11:50:15 nFullMask = 0x1bffc037, nCurrent = 0x80000, nDirection = 1
11:50:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
11:50:15 Dialog 0x80000 returned: 1
11:50:15 End Action ShowDialogsHlpr
11:50:15 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
11:50:15 Begin Action ShowDialogsHlpr: 0x100000
11:50:15 Begin Action: DialogShowSdSetupType
11:50:15 Begin Action: Setup Type
11:50:15 [SetupTypeSQL]
11:50:15 Result = 303
11:50:15 szDir = C:\Program Files\Microsoft SQL Server
11:50:15 final szDir = C:\Program Files\Microsoft SQL Server
11:50:15 szDataDir = E:\Data\SQL\DB
11:50:15 final szDataDir = E:\Data\SQL\DB
11:50:15 End Action: Setup Type
11:50:15 Setup Type: Custom (303)
11:50:15 End Action DialogShowSdSetupType
11:50:15 begin ShowDialogsUpdateMask
11:50:15 nFullMask = 0x1bffc037, nCurrent = 0x100000, nDirection = 303
11:50:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
11:50:15 Dialog 0x100000 returned: 303
11:50:15 End Action ShowDialogsHlpr
11:50:15 ShowDialogsGetDialog returned: nCurrent=0x200000,index=21
11:50:15 Begin Action ShowDialogsHlpr: 0x200000
11:50:15 Begin Action: DialogShowSdComponentMult
11:50:15 basesys = 0, baseinst = 0, basedata = 0
11:50:15 Begin Action: Component Handler
11:50:15 ***** Silent Mode in Multi comps
11:50:15 [SQLComponentMult]
11:50:15 Result = 1
11:50:15 ComponentSelectItem(MgtTool\Wzcnflct): -103
11:50:15 End Action: Component Handler
11:50:15 End Action DialogShowSdComponentMult
11:50:15 begin ShowDialogsUpdateMask
11:50:15 nFullMask = 0x1bffc037, nCurrent = 0x200000, nDirection = 1
11:50:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
11:50:15 Dialog 0x200000 returned: 1
11:50:15 End Action ShowDialogsHlpr
11:50:15 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
11:50:15 Begin Action ShowDialogsHlpr: 0x400000
11:50:15 Begin Action: DlgServices
11:50:15 [DlgServices]
11:50:15 Result = 1
11:50:15 Local-Domain = 61680
11:50:15 AutoStart = 0
11:50:15 SQLDomain = DomainName
11:50:15 SQLDomainAcct = AdminName
11:50:15 SQLDomainPwd
11:50:15 ValidateUser returned: 1, 0, 0x15c
11:50:15 GrantRightAsService returned : 1, 0
11:50:15 AgtDomain = DomainName
11:50:15 AgtDomainAcct = AdminName
11:50:15 AgtDomainPwd
11:50:15 ValidateUser returned: 1, 0, 0x168
11:50:15 GrantRightAsService returned : 1, 0
11:50:15 End Action DlgServices
11:50:15 begin ShowDialogsUpdateMask
11:50:15 nFullMask = 0x1bffc037, nCurrent = 0x400000, nDirection = 1
11:50:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
11:50:15 Dialog 0x400000 returned: 1
11:50:15 End Action ShowDialogsHlpr
11:50:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
11:50:15 Begin Action ShowDialogsHlpr: 0x800000
11:50:15 Begin Action: DlgSQLSecurity
11:50:15 [DlgSQLSecurity]
11:50:15 Result = 1
11:50:15 ShowDlgSQLSecurity returned: 1
11:50:15 LoginMode = 1,szPwd
11:50:15 End Action DlgSQLSecurity
11:50:15 begin ShowDialogsUpdateMask
11:50:15 nFullMask = 0x1bffc037, nCurrent = 0x800000, nDirection = 1
11:50:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
11:50:15 Dialog 0x800000 returned: 1
11:50:15 End Action ShowDialogsHlpr
11:50:15 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
11:50:15 Begin Action ShowDialogsHlpr: 0x1000000
11:50:15 Begin Action: DlgCollation
11:50:15 [DlgCollation]
11:50:15 Result = 1
11:50:15 collation_name = Latin1_General_CI_AS
11:50:15 ShowDlgCollation returned: 1
11:50:15 collation_name = Latin1_General_CI_AS,locale_name = ,lcid =
0x0,SortId = 0,dwCompFlags = 0x0
11:50:15 End Action DlgCollation
11:50:15 begin ShowDialogsUpdateMask
11:50:15 nFullMask = 0x1bffc037, nCurrent = 0x1000000, nDirection = 1
11:50:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
11:50:15 Dialog 0x1000000 returned: 1
11:50:15 End Action ShowDialogsHlpr
11:50:15 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
11:50:15 Begin Action ShowDialogsHlpr: 0x2000000
11:50:15 Begin Action: DlgNetwork
11:50:15 Result = 1
11:50:15 [DlgServerNetwork]
11:50:15 NetworkLibs = 255
11:50:15 TCPPort =1433
11:50:15 TCPPrxy =
11:50:15 NMPPipeName =\\.\pipe\sql\query
11:50:15 ShowDlgNetwork returned: 1
11:50:15 [DlgServerNetwork]
11:50:15 NetworkLibs = 255
11:50:15 TCPPort = 1433
11:50:15 TCPPrxy = Default
11:50:15 NMPPipeName = \\.\pipe\sql\query
11:50:15 Result = 1
11:50:15 End Action DlgNetwork
11:50:15 begin ShowDialogsUpdateMask
11:50:15 nFullMask = 0x1bffc037, nCurrent = 0x2000000, nDirection = 1
11:50:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
11:50:15 Dialog 0x2000000 returned: 1
11:50:15 End Action ShowDialogsHlpr
11:50:15 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
11:50:15 Begin Action ShowDialogsHlpr: 0x8000000
11:50:15 Begin Action: DialogShowSdStartCopy
11:50:15 End Action DialogShowSdStartCopy
11:50:15 begin ShowDialogsUpdateMask
11:50:15 nFullMask = 0x1bffc037, nCurrent = 0x8000000, nDirection = 1
11:50:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
11:50:15 Dialog 0x8000000 returned: 1
11:50:15 End Action ShowDialogsHlpr
11:50:15 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
11:50:15 Begin Action ShowDialogsHlpr: 0x10000000
11:50:15 Begin Action: DialogShowSdLicenseMode
11:50:15 LicenseMode as read from ISS file : PERDEVICE
11:50:15 LicenseLimit as read from ISS file : 2
11:50:15 ShowDlgLicense returned: 1
11:50:15 ShowDlgLicense returned: LicenseMode = 0, LicenseLimit = 2
11:50:15 End Action DialogShowSdLicenseMode
11:50:15 Dialog 0x10000000 returned: 1
11:50:15 End Action ShowDialogsHlpr
11:50:15 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
11:50:15 End Action ShowDialogs
11:50:15 Begin Action ProcessBeforeDataMove:
11:50:15 DeinstallStart returned (C:\Program Files\Microsoft SQL
Server\MSSQL): 0
11:50:15 End Action ProcessBeforeDataMove:
11:50:15 Begin Action SetToolsComponentSelection:
11:50:15 CreateSetupTopology(Node1), Handle : 0x1455d28, returned : 0
11:50:15 CreateSetupTopology returned : 0, Handle : 0x1455d28
11:50:15 Topology Type : 1, Return Value : 0
11:50:15 ST_GetPhysicalNode returned : 0, PNHandle : 0x1453f40
11:50:15 PN_EnumerateEx returned : 0
11:50:15 PN_GetSQLStates returned : 0, SqlStates : 0xc0200006
11:50:15 PN_StartScan [0x1453f40] returned : 0
11:50:15 PN_GetNext [0x1453f40] returned : 18, Handle: [0x0]
11:50:15 No more items in enumeration.
11:50:15 ReleaseSetupTopology
11:50:15 End Action SetToolsComponentSelection:
11:50:15 Begin Action ProcessComponentSelection:
11:50:15 End Action ProcessComponentSelection
11:50:15 Begin Action LogSelectedComponents:
11:50:15 SQLProg
11:50:15 SQLProg\SQLServr
11:50:15 SQLProg\SQLServr\Help
11:50:15 SQLProg\SQLServr\SCMDev
11:50:15 SQLProg\SQLServr\SCMDev\SCMh
11:50:15 SQLProg\SQLServr\SCMDev\SCMX86Lb
11:50:15 SQLProg\SQLServr\SCMDev\SCMALb
11:50:15 SQLProg\SQLServr\Rs1033
11:50:15 SQLProg\SQLServr\RsIntl
11:50:15 SQLProg\SQLServr\ActiveX
11:50:15 SQLProg\SQLServr\System
11:50:15 SQLProg\Install
11:50:15 SQLProg\System
11:50:15 SQLProg\SvrExt
11:50:15 SQLProg\SvrExt\Help
11:50:16 SQLProg\SvrExt\SvrExtRs
11:50:16 SQLProg\SvrExt\ResIntl
11:50:16 SQLProg\Dat
11:50:16 SQLProg\DatSmpl
11:50:16 SQLProg\BaseSys
11:50:16 SQLProg\BaseBinn
11:50:16 SQLProg\MSSearch
11:50:16 SQLProg\MSSearch\Help
11:50:16 SQLProg\MSSearch\ActiveX
11:50:16 SQLProg\BaseInst
11:50:16 SQLProg\Perfmon
11:50:16 SQLProg\Perfmon\System
11:50:16 SQLProg\Root
11:50:16 MgtTool
11:50:16 MgtTool\SEM
11:50:16 MgtTool\SEM\HTML
11:50:16 MgtTool\SEM\MSD98
11:50:16 MgtTool\SEM\MSD98SYS
11:50:16 MgtTool\SEM\MSD98Res
11:50:16 MgtTool\SEM\MSD98Hlp
11:50:16 MgtTool\SEM\Help
11:50:16 MgtTool\SEM\Res1033
11:50:16 MgtTool\SEM\ResIntl
11:50:16 MgtTool\SEM\MSD98RsI
11:50:16 MgtTool\SEM\ActiveX
11:50:16 MgtTool\SEM\ActiveX\Res1033
11:50:16 MgtTool\SEM\ActiveX\ResIntl
11:50:16 MgtTool\SEM\Scripts
11:50:16 MgtTool\SEM\OLEDB
11:50:16 MgtTool\SEM\OLEDB\Res1033
11:50:16 MgtTool\SEM\OLEDB\ResIntl
11:50:16 MgtTool\Profiler
11:50:16 MgtTool\Profiler\Help
11:50:16 MgtTool\Profiler\Res1033
11:50:16 MgtTool\Profiler\ResIntl
11:50:16 MgtTool\Qryanlz
11:50:16 MgtTool\Qryanlz\Help
11:50:16 MgtTool\Qryanlz\Res1033
11:50:16 MgtTool\Qryanlz\ResIntl
11:50:16 MgtTool\DTCCLi
11:50:16 MgtTool\Wzcnflct
11:50:16 MgtTool\Wzcnflct\WzcnHlp
11:50:16 MgtTool\Wzcnflct\Wzcn1033
11:50:16 MgtTool\Wzcnflct\WzcnOthr
11:50:16 MgtTool\Wzcnflct\WzcnCmn
11:50:16 MgtTool\UtilSys
11:50:16 MgtTool\UtilBinn
11:50:16 Books
11:50:16 Books\Bookso
11:50:16 Books\Bookso\Utils
11:50:16 CoreRepl
11:50:16 CoreRepl\Res1033
11:50:16 CoreRepl\ResIntl
11:50:16 Core
11:50:16 Core\Res1033
11:50:16 Core\ResOther
11:50:16 Repostry
11:50:16 Repostry\RepstSys
11:50:16 Repostry\Res1033
11:50:16 Repostry\ResIntl
11:50:16 CoreMisc
11:50:16 CoreMisc\ActiveX
11:50:16 CoreMisc\ActiveX\Res1033
11:50:16 CoreMisc\ActiveX\ResIntl
11:50:16 CoreMisc\Res1033
11:50:16 Monarch
11:50:16 Monarch\Monr1033
11:50:16 Monarch\MonrIntl
11:50:16 Jet
11:50:16 CoreInst
11:50:16 CoreCOM
11:50:16 CoreCOM\Res1033
11:50:16 CoreCOM\ResIntl
11:50:16 CoreTool
11:50:16 CoreTool\Res1033
11:50:16 CoreTool\ResOther
11:50:16 DBLibCli
11:50:16 SFExt
11:50:16 SFExt\ActiveX
11:50:16 SFExt\ActiveX\Res1033
11:50:16 SFExt\ActiveX\ResIntl
11:50:16 SFExt\Res1033
11:50:16 SFExt\ResIntl
11:50:16 Trace
11:50:16 Trace\Res1033
11:50:16 Trace\ResOther
11:50:16 MiscCore
11:50:16 MC
11:50:16 MC\MC1033
11:50:16 MC\MCIntl
11:50:16 MC\Help
11:50:16 ClstSys
11:50:16 SQLMgr
11:50:16 SQLMgr\Res1033
11:50:16 SQLMgr\ResIntl
11:50:16 SvrTool
11:50:16 SvrTool\Res1033
11:50:16 SvrTool\ResIntl
11:50:16 DTSUI
11:50:16 DTSUI\Res1033
11:50:16 DTSUI\ResIntl
11:50:16 ClFTSys
11:50:16 ClFtdata
11:50:16 MSOlap
11:50:16 MSOlap\Res1033
11:50:16 MSOlap\ResIntl
11:50:16 ATL
11:50:16 ATL\winnt
11:50:16 ATL\win9x
11:50:16 MFC42U
11:50:16 VC
11:50:16 VB
11:50:16 SQLAdHlp
11:50:16 SQLAdHlp\Res1033
11:50:16 SQLAdHlp\ResOther
11:50:16 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
11:50:16 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
11:50:16 End Action LogSelectedComponents
11:50:16 SQL program folder: C:\Program Files\Microsoft SQL
Server\MSSQL
11:50:16 SQL data folder: E:\Data\SQL\DB\MSSQL
11:50:16 Windows system folder: C:\WINDOWS\system32\
11:50:16 Prog req: 21962, Data req: 31360, Sys req: 91361
11:50:16 Prog avail: 15646073, Data avail: 142522508, Sys avail:
15646073
11:50:16 Prog req vs. avail, 113323, 15646073
11:50:16 Data req vs. avail, 31360, 142522508
11:50:16 Sys req vs. avail, 91361, 15646073
11:50:16 DisplaySystemPreReq
11:50:16 Begin Action InstallPkgs:
11:50:16 Begin Action: Locked Connectivity Files Check
11:50:16 ConnectivityLocked returned: 0
11:50:16 The operation completed successfully.

11:50:16 End Action: Locked Connectivity Files Check
11:50:16 Setup is installing Microsoft Data Access Components (MDAC)
....
11:50:16 C:\TEMP\SQL\ENT\x86\Other\sqlredis.exe /q:a
11:50:29 ExitCode: 0
11:50:29 InstallMSSearch instance: MSSQLSERVER
11:50:29 Software\Microsoft\Search\Install:Version not present
11:50:29 MSSearch 2.0 or greater version check returned -1
11:50:29 Setup is installing the Microsoft Full-Text Search Engine ...
11:50:29 "C:\TEMP\SQL\ENT\x86\FullText\MSSearch\Search\SearchStp.exe"
/s /a:SQLServer
11:50:41 Process Exit Code: (0)
11:50:41 /Q:A /T:C:\DOCUME~1\AdminName\LOCALS~1\Temp\1\ixp001.tmp
11:50:41 Setup is installing HTML Help ...
11:50:41 HTML Help installer exit code: 0
11:51:03 End Action InstallPkgs
11:51:03 Begin Action MoveFileData:
11:51:03 Enabled SELFREGISTERBATCH
11:51:03 Enabled CORECOMPONENTHANDLING
11:51:30 Begin Action: MoveFileDataSpecial
11:51:31 End Action: MoveFileDataSpecial
11:51:31 End Action MoveFileData
11:51:31 Begin Action ProcessAfterDataMove:
11:51:31 C:\TEMP\SQL\ENT\x86\Binn\hhcol.exe C:\Program Files\Microsoft
SQL Server\80\Tools\Books
11:51:31 End Action ProcessAfterDataMove
11:51:31 Begin Action BuildServer:
11:51:31 C:\DOCUME~1AdminName\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe
-Silent 1 -Action 5 -ExePath "C:\Program Files\Microsoft SQL
Server\MSSQL\binn\sqlservr.exe" -Service "MSSQLSERVER"
11:51:31 Process Exit Code: (0)
11:51:31 Begin Action: CreateRegistrySetSQL
11:51:31 End Action: CreateRegistrySetSQL
11:51:31 Begin Action: RegWriteSetupEntry
11:51:31 End Action: RegWriteSetupEntry
11:51:31 Begin Action: CreateSer
11:51:31 End Action: CreateSer
11:51:31 Begin Action: SkuIt
11:51:31 End Action: SkuIt
11:51:31 SetFileSecuritySQLAndAdmin for E:\Data\SQL\DB\MSSQL returned:
0, 0
11:51:31 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL
Server\MSSQL returned: 0, 0
11:51:31 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
11:51:31 Begin Action: UpdateSystemPath
11:51:31 Path successfully updated.
11:51:31
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program
Files\Microsoft SQL Server\80\Tools\BINN
11:51:31 End Action: UpdateSystemPath
11:51:31 Grant Right for DomainName\AdminName returned : 1, 0
11:51:31 Grant Right for DomainName\AdminName returned : 1, 0
11:51:31 Grant Right for DomainName\AdminName returned : 1, 0
11:51:31 Grant Right for DomainName\AdminName returned : 1, 0
11:51:31 Grant Right for DomainName\AdminName returned : 1, 0
11:51:32 C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp16.log" -I
MSSQLSERVER -V 1 -M 0 -Q "Latin1_General_CI_AS" -H 721164 -U sa -P
###############################################################################


Starting Service ...

Latin1_General_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=Node1;UID=sa;PWD=;database=master

Configuring Server ...

EXEC sp_grantlogin N'BUILTIN\Administrators'

[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'BUILTIN\Administrators'.

EXEC sp_addsrvrolemember N'BUILTIN\Administrators', 'sysadmin'

[Microsoft][ODBC SQL Server Driver][SQL Server]'BUILTIN\Administrators'
added to role 'sysadmin'.

update master.dbo.spt_server_info set attribute_value = @@version where
attribute_id = 2

EXEC sp_grantlogin N'DomainName\AdminName'

[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'DomainName\AdminName'.

EXEC sp_addsrvrolemember N'DomainName\AdminName', 'sysadmin'

[Microsoft][ODBC SQL Server Driver][SQL Server]'DomainName\AdminName'
added to role 'sysadmin'.

EXEC sp_addserver N'Node1', local

EXEC sp_configure 'allow updates', 1

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to
install.

reconfigure with override

update master.dbo.sysaltfiles set size=1024 where name=N'tempdev'

EXEC sp_configure 'allow updates', 0

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to
install.

reconfigure with override

Disconnecting from Server ...

Stopping Service ...

SQL Server has been successfully configured!

###############################################################################

11:52:03 Process Exit Code: (0)
11:52:03 End Action BuildServer
11:52:03 Begin Action SelfRegiser
11:52:03 DLLRegisterServer atl.dll: 0, 0x0
11:52:10 Return code: 0
11:52:10 Begin Action SelfRegisterOnCluster
11:52:10 End Action SelfRegisterOnCluster
11:52:10 Begin Action RegisterSvrReplFiles
11:52:10 End Action RegisterSvrReplFiles
11:52:10 Begin Action SelfRegisterCOMShared
11:52:10 End Action SelfRegisterCOMShared
11:52:10 End Action SelfRegister
11:52:10 Begin Action SetupRegistry:
11:52:10 SNMP service has been detected.
11:52:10 Begin Action RegWriteInstalledInstances:
11:52:10 End Action RegWriteInstalledInstances
11:52:10 Register this installation of SQL Server with MDAC
11:52:10 Completed registering this installation of SQL Server with
MDAC
11:52:10 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\SQLServerAgent returned: 0, 0
11:52:10 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Replication returned: 0, 0
11:52:10 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Providers returned: 0, 0
11:52:10 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Setup returned: 0, 0
11:52:10 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\Tracking returned: 0, 0
11:52:10 Updating SQL Licensing Control Panel information
11:52:10 Done updating SQL Licensing Control Panel information
11:52:10 SetRegSecuritySQLAndAdmin for
System\CurrentControlset\Services\MSSQLSERVER returned: 0, 0
11:52:10 SetRegSecuritySQLAndAdmin for Software\Microsoft\Windows
NT\CurrentVersion\Perflib returned: 0, 0
11:52:10 SetRegSecuritySQLAndAdmin for SOFTWARE\Clients\Mail returned:
0, 0
11:52:10 End Action SetupRegistry
11:52:10 Begin Action PostSetupRegistry:
11:52:10 C:\DOCUME~1\AdminName\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe
-Silent 1 -Action 7 -Service MSSQLSERVER -SvcStartType 1 -SvcAccount
"DomainName\AdminName" -SvcEPwd
11:52:10 Process Exit Code: (0)
11:52:10 C:\DOCUME~1\AdminName\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe
-Silent 1 -Action 5 -Service "SQLSERVERAGENT" -Dependencies MSSQLSERVER
-ExePath "C:\Program Files\Microsoft SQL
Server\MSSQL\binn\sqlagent.exe" -SvcAccount "DomainName\AdminName"
-SvcEPwd
11:52:15 Process Exit Code: (0)
11:52:16 SetupSQLExecSecurity returned: 0
11:52:16 PerfmonLoad returned: 0
11:52:16 C:\PROGRA~1\Microsoft SQL Server\80\Tools\Binn\dcomscm.exe
/RegServer
11:52:16 Process Exit Code: (0)
11:52:16 MSSearch ApplicationName: SQLServer
11:52:16 C:\TEMP\SQL\ENT\x86\FullText\ftsetup.exe SQLServer
DomainName\AdminName 1 0 1 0
11:52:16 C:\TEMP\SQL\ENT\x86\FullText\ftsetup.exe SQLServer
DomainName\AdminName 1 0 1 0
11:52:17 Process Exit Code: (0)
11:52:17 FulltextSetup returned: 0
11:52:17 C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqladhlp.exe -i -lcid 1033
11:52:17 Process Exit Code: (0)
11:52:17 End Action PostSetupRegistry
11:52:17 Begin Action SetupFolders:
11:52:17 C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft SQL Server\Enterprise Manager
11:52:17 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Enterprise
Manager
11:52:17 Tracking\Shortcuts\Enterprise Manager
11:52:17 C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft SQL Server\Query Analyzer
11:52:17 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Query
Analyzer
11:52:17 Tracking\Shortcuts\Query Analyzer
11:52:17 C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft SQL Server\Profiler
11:52:17 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Profiler
11:52:17 Tracking\Shortcuts\Profiler
11:52:17 C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft SQL Server\Client Network Utility
11:52:17 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Client
Network Utility
11:52:17 Tracking\Shortcuts\Client Network Utility
11:52:17 C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft SQL Server\Configure SQL XML Support in IIS
11:52:17 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Configure
SQL XML Support in IIS
11:52:17 Tracking\Shortcuts\Configure SQL XML Support in IIS
11:52:17 C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft SQL Server\Import and Export Data
11:52:17 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Import and
Export Data
11:52:17 Tracking\Shortcuts\Import and Export Data
11:52:17 C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft SQL Server\Service Manager
11:52:17 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Service
Manager
11:52:17 Tracking\Shortcuts\Service Manager
11:52:17 C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft SQL Server\Server Network Utility
11:52:17 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Server
Network Utility
11:52:17 Tracking\Shortcuts\Server Network Utility
11:52:17 C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft SQL Server\Books Online
11:52:17 Software\Microsoft\MSSQLServer\Tracking\Shortcuts\Books Online
11:52:17 Tracking\Shortcuts\Books Online
11:52:17 Microsoft SQL Server Folder refreshed.
11:52:17 End Action SetupFolders
11:52:17 Action CleanUpInstall:
11:52:17 Uninstall command: C:\WINDOWS\IsUninst.exe -f"C:\Program
Files\Microsoft SQL Server\MSSQL\Uninst.isu" -c"C:\Program
Files\Microsoft SQL Server\MSSQL\sqlsun.dll" -msql.mif i=MSSQLSERVER
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA4-5A21-11d2-9DAD-00C04F79D434}
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{6DC86044-0C71-11d3-9E18-00C04F79D434}
11:52:17 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDA8-5A21-11d2-9DAD-00C04F79D434} (2)
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA8-5A21-11d2-9DAD-00C04F79D434}
11:52:17 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDA9-5A21-11d2-9DAD-00C04F79D434} (2)
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{E07FDDA9-5A21-11d2-9DAD-00C04F79D434}
11:52:17 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAA-5A21-11d2-9DAD-00C04F79D434} (2)
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAA-5A21-11d2-9DAD-00C04F79D434}
11:52:17 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAB-5A21-11d2-9DAD-00C04F79D434} (2)
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAB-5A21-11d2-9DAD-00C04F79D434}
11:52:17 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAC-5A21-11d2-9DAD-00C04F79D434} (2)
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAC-5A21-11d2-9DAD-00C04F79D434}
11:52:17 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDAF-5A21-11d2-9DAD-00C04F79D434} (2)
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{E07FDDAF-5A21-11d2-9DAD-00C04F79D434}
11:52:17 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDBE-5A21-11d2-9DAD-00C04F79D434} (2)
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
11:52:17 Software\Microsoft\Microsoft SQL
Server\80\Tools\Tracking\{E07FDDBF-5A21-11d2-9DAD-00C04F79D434} (2)
11:52:17
Software\Microsoft\MSSQLServer\Tracking\{E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
11:52:17 StatsGenerate returned: 2
11:52:17 StatsGenerate
(0x0,0x1,0xf00000,0x100,1033,303,0x0,0x1000000a,0,0,0
11:52:17 StatsGenerate -1,AdminName)
11:52:17 Installation Succeeded

Thanks again, for all your help!

.

Relevant Pages