Error during Synchronization

While synchronizing data between the PDA and MS SQL Server database, using Active Sync connection, the sync process fails at times and displays an empty error message box and occasionally it shows the following exception:

Error During Synchronization:

A native exception occurred.

ExceptionCode:0xc0000005

ExceptionAddress:0x01627b28

Reading: 0x1e000000

OK to terminate

CANCEL to debug

Moreover the .SDF file on the PDA gets corrupted. The ActiveSync connection drops as soon as the sync process fails. Later when the .SDF file is deleted and restored the synchronization is successful.

Note: The replication monitor in the SQL Server indicates that the synchronization was successful even when the above error occurs.

========================================================
** Sample code where the app crashes we encounter the issue:

Public Sub Synchronize (ByVal vShowMessage As Boolean)

Dim ce As SqlCeReplication = Nothing

Try

ce = New SqlCeReplication

'Set Internet properties.

ce.InternetUrl = vInternetURL ' "http://xx.xx.xx.xx/SQLCE/sscesa20.dll"

'Set Publisher properties.

ce.Publisher = vPublisher

ce.PublisherLogin = vPublisherLogin '"sa"

ce.PublisherPassword = vPublisherPassword '"xxxxxx"

ce.PublisherSecurityMode = SecurityType.DBAuthentication

ce.PublisherNetwork = NetworkType.DefaultNetwork

ce.PublisherDatabase = vPublisherDatabase

ce.Publication = vPub_Name

'Set Subscriber properties.

ce.Subscriber = vSub_Name

ce.SubscriberConnectionString = "Data Source=" & DB_PATH & vDatabase_Name

If File.Exists(DB_PATH & vDatabase_Name) = False Then

ce.AddSubscription(AddOption.CreateDatabase)

End If

ce.Synchronize()

Catch ex As SqlCeException

If vShowMessage = True Then

MsgBox(ex.Message)

End If

Throw ex

Catch ex1 As Exception

If vShowMessage = True Then

MsgBox(ex1.Message)

End If

Throw ex1

Finally

ce = Nothing

End Try

End Sub

This has been tracked and answered in "SQL Server Replication" forum under the following threads:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=96703
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=96832

Thanks,
Laxmi NRO, MSFT, SQL Mobile

Error during Synchronization

While synchronizing data between the PDA and MS SQL Server database, using Active Sync connection, the sync process fails at times and displays an empty error message box and occasionally it shows the following exception:

Error During Synchronization:

A native exception occurred.

ExceptionCode:0xc0000005

ExceptionAddress:0x01627b28

Reading: 0x1e000000

OK to terminate

CANCEL to debug

Moreover the .SDF file on the PDA gets corrupted. The ActiveSync connection drops as soon as the sync process fails. Later when the .SDF file is deleted and restored the synchronization is successful.

Note: The replication monitor in the SQL Server indicates that the synchronization was successful even when the above error occurs.

========================================================
** Sample code where the app crashes we encounter the issue:

Public Sub Synchronize (ByVal vShowMessage As Boolean)

Dim ce As SqlCeReplication = Nothing

Try

ce = New SqlCeReplication

'Set Internet properties.

ce.InternetUrl = vInternetURL ' "http://xx.xx.xx.xx/SQLCE/sscesa20.dll"

'Set Publisher properties.

ce.Publisher = vPublisher

ce.PublisherLogin = vPublisherLogin '"sa"

ce.PublisherPassword = vPublisherPassword '"xxxxxx"

ce.PublisherSecurityMode = SecurityType.DBAuthentication

ce.PublisherNetwork = NetworkType.DefaultNetwork

ce.PublisherDatabase = vPublisherDatabase

ce.Publication = vPub_Name

'Set Subscriber properties.

ce.Subscriber = vSub_Name

ce.SubscriberConnectionString = "Data Source=" & DB_PATH & vDatabase_Name

If File.Exists(DB_PATH & vDatabase_Name) = False Then

ce.AddSubscription(AddOption.CreateDatabase)

End If

ce.Synchronize()

Catch ex As SqlCeException

If vShowMessage = True Then

MsgBox(ex.Message)

End If

Throw ex

Catch ex1 As Exception

If vShowMessage = True Then

MsgBox(ex1.Message)

End If

Throw ex1

Finally

ce = Nothing

End Try

End Sub

This has been tracked and answered in "SQL Server Replication" forum under the following threads:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=96703
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=96832

Thanks,
Laxmi NRO, MSFT, SQL Mobilesql

Error during Instance Install

Building an Active/Active/Passive SQL 2000 cluster on top of a 3 node 2003
server cluster. As I go to install I end up getting a "An error occured
while creating virtual server resources for clustering. The system cannot
find the file specified."
I've gone through KB 815431 and made sure the named piped alias is
configured properly and it appears to be working correctly. Let me know if
anyone has any ideas. Here's my sqlstp.log up to the point of the error.
16:12:58 Begin Setup
16:12:58 8.00.194
16:12:58 Mode = Normal
16:12:58 ModeType = NORMAL
16:12:58 GetDefinitionEx returned: 0, Extended: 0x0
16:12:58 ValueFTS returned: 1
16:12:58 ValuePID returned: 1
16:12:58 ValueLic returned: 1
16:12:58 System: Windows NT Enterprise Server
16:12:58 SQL Server ProductType: Enterprise Edition [0x3]
16:12:58 IsNTCluster returned: 1
16:12:58 Begin Action: SetupInitialize
16:12:58 End Action SetupInitialize
16:12:58 Begin Action: SetupInstall
16:12:58 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
16:12:58 CommonFilesDir=C:\Program Files\Common Files
16:12:58 Windows Directory=C:\WINDOWS\
16:12:58 Program Files=C:\Program Files\
16:12:58 TEMPDIR=C:\WINDOWS\TEMP\
16:12:58 Begin Action: SetupInstall
16:12:58 digpid size : 256
16:12:58 digpid size : 164
16:12:58 Begin Action: CheckFixedRequirements
16:12:58 Platform ID: 0xf00000
16:12:58 Version: 5.2.3790
16:12:58 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.279
16:12:58 End Action: CheckFixedRequirements
16:12:58 Begin Action: ShowDialogs
16:12:58 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
16:12:58 Begin Action ShowDialogsHlpr: 0x1
16:12:58 Begin Action: DialogShowSdWelcome
16:13:01 End Action DialogShowSdWelcome
16:13:01 Dialog 0x1 returned: 1
16:13:01 End Action ShowDialogsHlpr
16:13:01 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
16:13:01 Begin Action ShowDialogsHlpr: 0x2
16:13:01 Begin Action: DialogShowSdMachineName
16:13:15 ShowDlgMachine returned: 1
16:13:15 Name = NPBSQLC7, Type = 0x10000008
16:13:15 Begin Action: CheckRequirements
16:13:15 Processor Architecture: x86 (Pentium)
16:13:15 ComputerName: NPBSQL6
16:13:15 User Name: <Removed>
16:13:15 IsAllAccessAllowed returned: 1
16:13:15 OS Language: 0x409
16:13:15 End Action CheckRequirements
16:13:15 This combination of Package and Operating System allows a full
product install.
16:13:15 End Action DialogShowSdMachineName
16:13:15 begin ShowDialogsUpdateMask
16:13:15 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
16:13:15 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
16:13:15 Dialog 0x2 returned: 0
16:13:15 End Action ShowDialogsHlpr
16:13:15 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
16:13:15 Begin Action ShowDialogsHlpr: 0x4
16:13:15 Begin Action: DialogShowSdInstallMode
16:13:15 InstallMode : 0x1
16:13:15 End Action DialogShowSdInstallMode
16:13:15 begin ShowDialogsUpdateMask
16:13:15 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
16:13:15 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:15 Dialog 0x4 returned: 1
16:13:15 End Action ShowDialogsHlpr
16:13:15 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
16:13:15 Begin Action ShowDialogsHlpr: 0x10
16:13:15 Begin Action: DialogShowSdRegisterUserEx
16:13:17 End Action DialogShowSdRegisterUserEx
16:13:17 begin ShowDialogsUpdateMask
16:13:17 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
16:13:17 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:17 Dialog 0x10 returned: 1
16:13:17 End Action ShowDialogsHlpr
16:13:17 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
16:13:17 Begin Action ShowDialogsHlpr: 0x20
16:13:17 Begin Action: DialogShowSdLicense
16:13:17 End Action DialogShowSdLicense
16:13:17 Dialog 0x20 returned: 1
16:13:17 End Action ShowDialogsHlpr
16:13:17 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
16:13:17 Begin Action ShowDialogsHlpr: 0x4000
16:13:17 Begin Action: DialogShowSdVirtualServer
16:13:27 ShowDlgVirtualServer returned: 0
16:13:27 Ipaddress = 10.10.0.58,255.255.252.0,SQL2 Public Team
16:13:27 szNewList = 10.10.0.58,255.255.252.0,SQL2 Public Team
16:13:27 szModifiedList =
16:13:27 szRemovedList =
16:13:27 End Action DialogShowSdVirtualServer
16:13:27 begin ShowDialogsUpdateMask
16:13:27 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
16:13:27 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:27 Dialog 0x4000 returned: 1
16:13:27 End Action ShowDialogsHlpr
16:13:27 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
16:13:27 Begin Action ShowDialogsHlpr: 0x8000
16:13:27 Begin Action : DialogShowSdDiskGroups
16:13:30 ShowDlgDiskGroups returned: 1
16:13:30 Disk Group = NPBSQLC7
16:13:30 End Action : DialogShowSdDiskGroups
16:13:30 begin ShowDialogsUpdateMask
16:13:30 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
16:13:30 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:30 Dialog 0x8000 returned: 1
16:13:30 End Action ShowDialogsHlpr
16:13:30 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
16:13:30 Begin Action ShowDialogsHlpr: 0x10000
16:13:30 Begin Action: DialogShowSdClusterDef
16:13:31 ShowDlgClusterDef returned: 1
16:13:31 PrefOwners = NPBSQL6,NPBSQL7,NPBSQL8, NumIp = 3
16:13:31 Begin Action : ValidateNodeActions
16:13:31 Begin Action : ValidateNodeActions
16:13:31 End Action : ValidateNodeActions
16:13:31 End Action : ValidateNodeActions
16:13:31 End Action DialogShowSdClusterDef
16:13:31 begin ShowDialogsUpdateMask
16:13:31 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
16:13:31 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:31 Dialog 0x10000 returned: 1
16:13:31 End Action ShowDialogsHlpr
16:13:31 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
16:13:31 Begin Action ShowDialogsHlpr: 0x20000
16:13:31 Begin Action : Cluster Security - DlgAcct
16:13:39 ShowDlgAcct returned: 1
16:13:39 [DlgAccount]
16:13:39 Domain = <Removed>
16:13:40 DomainAcct = <Removed>
16:13:40 DomainPwd
16:13:40 Result = 1
16:13:40 End Action : Cluster Security - DlgAcct
16:13:40 begin ShowDialogsUpdateMask
16:13:40 nFullMask = 0x1bf7c037, nCurrent = 0x20000, nDirection = 1
16:13:40 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
16:13:40 Dialog 0x20000 returned: 1
16:13:40 End Action ShowDialogsHlpr
16:13:40 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
16:13:40 Begin Action ShowDialogsHlpr: 0x40000
16:13:40 Begin Action: DialogShowSdCliSvr
16:13:40 DisplaySystemPreReq
16:13:40 ShowDlgClientServerSelect returned: 1
16:13:40 Type : 0x2
16:13:40 End Action DialogShowSdCliSvr
16:13:40 begin ShowDialogsUpdateMask
16:13:40 nFullMask = 0x1bf7c037, nCurrent = 0x40000, nDirection = 1
16:13:40 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:13:40 Dialog 0x40000 returned: 1
16:13:40 End Action ShowDialogsHlpr
16:13:40 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
16:13:40 Begin Action ShowDialogsHlpr: 0x80000
16:13:40 Begin Action: DialogShowSdInstanceName
16:13:40 Begin Action: ShowDlgInstanceName
16:13:46 End Action: ShowDlgInstanceName
16:13:46 ShowDlgInstanceName returned : 1
16:13:46 InstanceName : INSTANCEC7
16:13:46 End Action DialogShowSdInstanceName
16:13:46 begin ShowDialogsUpdateMask
16:13:46 nFullMask = 0x1bffc037, nCurrent = 0x80000, nDirection = 1
16:13:46 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:13:46 Dialog 0x80000 returned: 1
16:13:46 End Action ShowDialogsHlpr
16:13:46 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
16:13:46 Begin Action ShowDialogsHlpr: 0x100000
16:13:46 Begin Action: DialogShowSdSetupType
16:13:46 Begin Action: Setup Type
16:13:50 [SetupTypeSQL]
16:13:50 szDir = C:\Program Files\Microsoft SQL Server
16:13:50 szDir = C:\Program Files\Microsoft SQL Server
16:13:50 Result = 303
16:13:50 szDataDir = R:\Program Files\Microsoft SQL Server
16:13:50 szDataDir = R:\Program Files\Microsoft SQL Server
16:13:50 End Action: Setup Type
16:13:50 Setup Type: Custom (303)
16:13:50 End Action DialogShowSdSetupType
16:13:50 begin ShowDialogsUpdateMask
16:13:50 nFullMask = 0x1bffc037, nCurrent = 0x100000, nDirection = 303
16:13:50 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:13:50 Dialog 0x100000 returned: 303
16:13:50 End Action ShowDialogsHlpr
16:13:50 ShowDialogsGetDialog returned: nCurrent=0x200000,index=21
16:13:50 Begin Action ShowDialogsHlpr: 0x200000
16:13:50 Begin Action: DialogShowSdComponentMult
16:13:50 basesys = 0, baseinst = 0, basedata = 0
16:13:50 Begin Action: Component Handler
16:13:54 SQL program folder: C:\Program Files\Microsoft SQL
Server\MSSQL$INSTANCEC7
16:13:54 SQL data folder: R:\Program Files\Microsoft SQL
Server\MSSQL$INSTANCEC7
16:13:54 Windows system folder: C:\WINDOWS\system32\
16:13:54 Prog req: 22162, Data req: 34432, Sys req: 181286
16:13:54 Prog avail: 28555808, Data avail: 61083436, Sys avail: 28555808
16:13:54 Prog req vs. avail, 203448, 28555808
16:13:54 Data req vs. avail, 34432, 61083436
16:13:54 Sys req vs. avail, 181286, 28555808
16:13:54 DisplaySystemPreReq
16:13:54 [SQLComponentMult]
16:13:56 Component =
16:13:56 Result = 1
16:13:56 End Action: Component Handler
16:13:56 End Action DialogShowSdComponentMult
16:13:56 begin ShowDialogsUpdateMask
16:13:56 nFullMask = 0x1bffc037, nCurrent = 0x200000, nDirection = 1
16:13:56 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:13:56 Dialog 0x200000 returned: 1
16:13:56 End Action ShowDialogsHlpr
16:13:56 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
16:13:56 Begin Action ShowDialogsHlpr: 0x400000
16:13:56 Begin Action: DlgServices
16:14:15 ShowDlgServices returned: 1
16:14:15 [DlgServices]
16:14:15 Local-Domain= 61680
16:14:15 AutoStart= 0
16:14:15 SQLDomain= <Removed>
16:14:15 SQLDomainAcct= <Removed>
16:14:15 SQLDomainPwd
16:14:15 AgtDomain= <Removed>
16:14:15 AgtDomainAcct= <Removed>
16:14:15 AgtDomainPwd
16:14:15 Result= 1
16:14:15 End Action DlgServices
16:14:15 begin ShowDialogsUpdateMask
16:14:15 nFullMask = 0x1bffc037, nCurrent = 0x400000, nDirection = 1
16:14:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:14:15 Dialog 0x400000 returned: 1
16:14:15 End Action ShowDialogsHlpr
16:14:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
16:14:15 Begin Action ShowDialogsHlpr: 0x800000
16:14:15 Begin Action: DlgSQLSecurity
16:14:19 ShowDlgSQLSecurity returned: 1
16:14:19 LoginMode = 1,szPwd
16:14:19 End Action DlgSQLSecurity
16:14:19 begin ShowDialogsUpdateMask
16:14:19 nFullMask = 0x1bffc037, nCurrent = 0x800000, nDirection = 1
16:14:19 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:14:19 Dialog 0x800000 returned: 1
16:14:19 End Action ShowDialogsHlpr
16:14:19 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
16:14:19 Begin Action ShowDialogsHlpr: 0x1000000
16:14:19 Begin Action: DlgCollation
16:14:24 ShowDlgCollation returned: 1
16:14:24 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = ,lcid =
0x409,SortId = 52,dwCompFlags = 0x30001
16:14:24 End Action DlgCollation
16:14:24 begin ShowDialogsUpdateMask
16:14:24 nFullMask = 0x1bffc037, nCurrent = 0x1000000, nDirection = 1
16:14:24 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:14:24 Dialog 0x1000000 returned: 1
16:14:24 End Action ShowDialogsHlpr
16:14:24 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
16:14:24 Begin Action ShowDialogsHlpr: 0x2000000
16:14:24 Begin Action: DlgNetwork
16:14:29 ShowDlgNetwork returned: 1
16:14:29 [DlgServerNetwork]
16:14:29 NetworkLibs = 255
16:14:29 TCPPort = 0
16:14:29 TCPPrxy = Default
16:14:29 NMPPipeName = \\.\pipe\MSSQL$INSTANCEC7\sql\query
16:14:29 Result = 1
16:14:29 End Action DlgNetwork
16:14:29 begin ShowDialogsUpdateMask
16:14:29 nFullMask = 0x1bffc037, nCurrent = 0x2000000, nDirection = 1
16:14:29 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:14:29 Dialog 0x2000000 returned: 1
16:14:29 End Action ShowDialogsHlpr
16:14:29 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
16:14:29 Begin Action ShowDialogsHlpr: 0x8000000
16:14:29 Begin Action: DialogShowSdStartCopy
16:14:30 End Action DialogShowSdStartCopy
16:14:30 begin ShowDialogsUpdateMask
16:14:30 nFullMask = 0x1bffc037, nCurrent = 0x8000000, nDirection = 1
16:14:30 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
16:14:30 Dialog 0x8000000 returned: 1
16:14:30 End Action ShowDialogsHlpr
16:14:30 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
16:14:30 Begin Action ShowDialogsHlpr: 0x10000000
16:14:30 Begin Action: DialogShowSdLicenseMode
16:14:34 ShowDlgLicense returned: 1
16:14:34 ShowDlgLicense returned: LicenseMode = 0, LicenseLimit = 999
16:14:34 End Action DialogShowSdLicenseMode
16:14:34 Dialog 0x10000000 returned: 1
16:14:34 End Action ShowDialogsHlpr
16:14:34 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
16:14:34 End Action ShowDialogs
16:14:34 Setup is installing Microsoft Distributed Transaction Coordinator
(MSDTC) ...
16:14:34 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
"C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\Other\dtcsetup.exe" -LogFile
"C:\WINDOWS\sqlstp.log" -CtxAcct "<Removed>" -<Removed>
16:14:34 Process Exit Code: (0)
16:14:34 Begin Action : ClusterSetupHelper
16:14:34 Begin Action : CreateClustISSFiles
16:14:34 End Action : CreateClustISSFiles
16:14:34 Begin Action : ClusterWriteRemIni
16:14:34 End Action : ClusterWriteRemIni
16:14:34 Begin Action : Run setup on cluster nodes
[args]
NumRemoteServers=3
Server.1=NPBSQL6
Server.2=NPBSQL7
Server.3=NPBSQL8
[Server.1]
NumRemoteServices=1
1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
1.server=NPBSQL6
1.script=\\NPBSQL6\admin$\NPBSQL6_INSTANCEC7.iss
1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
"\\NPBSQL6\admin$\setup.log" -e "stpsilnt._ex" -b -x "C:\WINDOWS\TEMP\"
1.user=<Removed>
1.password=<Removed>
1.name=<Removed>
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
[Server.2]
NumRemoteServices=1
1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
1.server=NPBSQL7
1.script=\\NPBSQL6\admin$\NPBSQL7_INSTANCEC7.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
"\\NPBSQL7\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
1.user=<Removed>
1.password=095b2c9b3941a75cd961
1.name=SQLSetup2
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
[Server.3]
NumRemoteServices=1
1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
1.server=NPBSQL8
1.script=\\NPBSQL6\admin$\NPBSQL8_INSTANCEC7.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
"\\NPBSQL8\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
1.user=<Removed>
1.password=095b2c9b3941a75cd961
1.name=SQLSetup3
1.sqlsetup=Y
1.copyexe=cnvsvc3.exe
16:14:34 Setup is performing required operations on cluster nodes. This may
take a few minutes...
16:14:34 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini
16:16:41 Process Exit Code: (0)
16:16:41 Begin Action : GetRemsetupRetCode
16:16:41 Installation return status on NPBSQL6 : 0
16:16:41 Installation return status on NPBSQL7 : 0
16:16:41 Installation return status on NPBSQL8 : 0
16:16:41 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 05/18/05 16:14:34 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x78] created for execution.
CThread::Process [0x78]
CThreadPool::RunUntilCompleteHlpr create thread, index=1
Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe k=Nb
k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
\\NPBSQL6\admin$\NPBSQL6_INSTANCEC7.iss -f2 "\\NPBSQL6\admin$\setup.log" -e
"stpsilnt._ex" -b -x "C:\WINDOWS\TEMP\"' (NPBSQL6) ...
CThread::Run thread [0x80] created for execution.
CThread::Process [0x80]
CThreadPool::RunUntilCompleteHlpr create thread, index=2
CThread::Run thread [0x84] created for execution.
CThread::Process [0x84]
CThreadPool::RunUntilCompleteHlpr start thread [0x78],index=0
CThreadPool::RunUntilCompleteHlpr start thread [0x80],index=1
CThreadPool::RunUntilCompleteHlpr start thread [0x84],index=2
Script file copied to '\\NPBSQL8\ADMIN$\NPBSQL8_INSTANCEC7.iss' successfully.
Script file copied to '\\NPBSQL7\ADMIN$\NPBSQL7_INSTANCEC7.iss' successfully.
Installing remote service (NPBSQL8)...
Installing remote service (NPBSQL7)...
Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
k=ClSec k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
\\NPBSQL8\ADMIN$\NPBSQL8_INSTANCEC7.iss -f2 "\\NPBSQL8\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\"' (NPBSQL8) ...
Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
k=ClSec k=Rm k=Cl -SMS -s -f
"\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
\\NPBSQL7\ADMIN$\NPBSQL7_INSTANCEC7.iss -f2 "\\NPBSQL7\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\"' (NPBSQL7) ...
CRemoteProcess::RunUntilComplete [0x84] exit code: 0
Remote process exit code was '0' (NPBSQL8).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x84]
Thread [0x84] exit code: [0x0]
CRemoteProcess::RunUntilComplete [0x80] exit code: 0
Remote process exit code was '0' (NPBSQL7).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x80]
Thread [0x80] exit code: [0x0]
CProcess::RunUntilComplete [0x78] exit code: 0
Remote process exit code was '0' (NPBSQL6).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x78]
Thread [0x78] exit code: [0x0]
CThreadPool::RunUntilComplete returned 0
CThreadPool::RunUntilComplete execution level=1, need execution: 0
Disconnecting from remote machine (NPBSQL6)...
Service removed successfully.
Remote files could not be removed.
#### SQL Server Remote Setup - Stop Time 05/18/05 16:16:07 ####
Disconnecting from remote machine (NPBSQL7)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 05/18/05 16:16:24 ####
Disconnecting from remote machine (NPBSQL8)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 05/18/05 16:16:41 ####
16:16:41 End Action : Run setup on cluster nodes
16:16:41 SetClusterSecuritySQL (<Removed>) and (<Removed>) returned: 0
16:16:41 Begin Action : CreateVirtualServerResources
16:16:49 End Action : CreateVirtualServerResources
16:16:49 CreateVirtualServerResources returned: 2
SQL Clusters sometimes don't like installing from a network share. Burn a
CD and physically place it in the node you are running install on.
Geoff N. Hiten
Microsoft SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:22BF14DE-8ECE-48FD-BCF9-6D811C6F8277@.microsoft.com...
> Building an Active/Active/Passive SQL 2000 cluster on top of a 3 node 2003
> server cluster. As I go to install I end up getting a "An error occured
> while creating virtual server resources for clustering. The system cannot
> find the file specified."
> I've gone through KB 815431 and made sure the named piped alias is
> configured properly and it appears to be working correctly. Let me know
> if
> anyone has any ideas. Here's my sqlstp.log up to the point of the error.
> 16:12:58 Begin Setup
> 16:12:58 8.00.194
> 16:12:58 Mode = Normal
> 16:12:58 ModeType = NORMAL
> 16:12:58 GetDefinitionEx returned: 0, Extended: 0x0
> 16:12:58 ValueFTS returned: 1
> 16:12:58 ValuePID returned: 1
> 16:12:58 ValueLic returned: 1
> 16:12:58 System: Windows NT Enterprise Server
> 16:12:58 SQL Server ProductType: Enterprise Edition [0x3]
> 16:12:58 IsNTCluster returned: 1
> 16:12:58 Begin Action: SetupInitialize
> 16:12:58 End Action SetupInitialize
> 16:12:58 Begin Action: SetupInstall
> 16:12:58 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir
> ...
> 16:12:58 CommonFilesDir=C:\Program Files\Common Files
> 16:12:58 Windows Directory=C:\WINDOWS\
> 16:12:58 Program Files=C:\Program Files\
> 16:12:58 TEMPDIR=C:\WINDOWS\TEMP\
> 16:12:58 Begin Action: SetupInstall
> 16:12:58 digpid size : 256
> 16:12:58 digpid size : 164
> 16:12:58 Begin Action: CheckFixedRequirements
> 16:12:58 Platform ID: 0xf00000
> 16:12:58 Version: 5.2.3790
> 16:12:58 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.279
> 16:12:58 End Action: CheckFixedRequirements
> 16:12:58 Begin Action: ShowDialogs
> 16:12:58 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
> 16:12:58 Begin Action ShowDialogsHlpr: 0x1
> 16:12:58 Begin Action: DialogShowSdWelcome
> 16:13:01 End Action DialogShowSdWelcome
> 16:13:01 Dialog 0x1 returned: 1
> 16:13:01 End Action ShowDialogsHlpr
> 16:13:01 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
> 16:13:01 Begin Action ShowDialogsHlpr: 0x2
> 16:13:01 Begin Action: DialogShowSdMachineName
> 16:13:15 ShowDlgMachine returned: 1
> 16:13:15 Name = NPBSQLC7, Type = 0x10000008
> 16:13:15 Begin Action: CheckRequirements
> 16:13:15 Processor Architecture: x86 (Pentium)
> 16:13:15 ComputerName: NPBSQL6
> 16:13:15 User Name: <Removed>
> 16:13:15 IsAllAccessAllowed returned: 1
> 16:13:15 OS Language: 0x409
> 16:13:15 End Action CheckRequirements
> 16:13:15 This combination of Package and Operating System allows a full
> product install.
> 16:13:15 End Action DialogShowSdMachineName
> 16:13:15 begin ShowDialogsUpdateMask
> 16:13:15 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
> 16:13:15 Updated Dialog Mask: 0xbf3c037, Disable Back = 0x1
> 16:13:15 Dialog 0x2 returned: 0
> 16:13:15 End Action ShowDialogsHlpr
> 16:13:15 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
> 16:13:15 Begin Action ShowDialogsHlpr: 0x4
> 16:13:15 Begin Action: DialogShowSdInstallMode
> 16:13:15 InstallMode : 0x1
> 16:13:15 End Action DialogShowSdInstallMode
> 16:13:15 begin ShowDialogsUpdateMask
> 16:13:15 nFullMask = 0xbf3c037, nCurrent = 0x4, nDirection = 1
> 16:13:15 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:15 Dialog 0x4 returned: 1
> 16:13:15 End Action ShowDialogsHlpr
> 16:13:15 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
> 16:13:15 Begin Action ShowDialogsHlpr: 0x10
> 16:13:15 Begin Action: DialogShowSdRegisterUserEx
> 16:13:17 End Action DialogShowSdRegisterUserEx
> 16:13:17 begin ShowDialogsUpdateMask
> 16:13:17 nFullMask = 0x1bf7c037, nCurrent = 0x10, nDirection = 1
> 16:13:17 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:17 Dialog 0x10 returned: 1
> 16:13:17 End Action ShowDialogsHlpr
> 16:13:17 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
> 16:13:17 Begin Action ShowDialogsHlpr: 0x20
> 16:13:17 Begin Action: DialogShowSdLicense
> 16:13:17 End Action DialogShowSdLicense
> 16:13:17 Dialog 0x20 returned: 1
> 16:13:17 End Action ShowDialogsHlpr
> 16:13:17 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
> 16:13:17 Begin Action ShowDialogsHlpr: 0x4000
> 16:13:17 Begin Action: DialogShowSdVirtualServer
> 16:13:27 ShowDlgVirtualServer returned: 0
> 16:13:27 Ipaddress = 10.10.0.58,255.255.252.0,SQL2 Public Team
> 16:13:27 szNewList = 10.10.0.58,255.255.252.0,SQL2 Public Team
> 16:13:27 szModifiedList =
> 16:13:27 szRemovedList =
> 16:13:27 End Action DialogShowSdVirtualServer
> 16:13:27 begin ShowDialogsUpdateMask
> 16:13:27 nFullMask = 0x1bf7c037, nCurrent = 0x4000, nDirection = 1
> 16:13:27 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:27 Dialog 0x4000 returned: 1
> 16:13:27 End Action ShowDialogsHlpr
> 16:13:27 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
> 16:13:27 Begin Action ShowDialogsHlpr: 0x8000
> 16:13:27 Begin Action : DialogShowSdDiskGroups
> 16:13:30 ShowDlgDiskGroups returned: 1
> 16:13:30 Disk Group = NPBSQLC7
> 16:13:30 End Action : DialogShowSdDiskGroups
> 16:13:30 begin ShowDialogsUpdateMask
> 16:13:30 nFullMask = 0x1bf7c037, nCurrent = 0x8000, nDirection = 1
> 16:13:30 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:30 Dialog 0x8000 returned: 1
> 16:13:30 End Action ShowDialogsHlpr
> 16:13:30 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
> 16:13:30 Begin Action ShowDialogsHlpr: 0x10000
> 16:13:30 Begin Action: DialogShowSdClusterDef
> 16:13:31 ShowDlgClusterDef returned: 1
> 16:13:31 PrefOwners = NPBSQL6,NPBSQL7,NPBSQL8, NumIp = 3
> 16:13:31 Begin Action : ValidateNodeActions
> 16:13:31 Begin Action : ValidateNodeActions
> 16:13:31 End Action : ValidateNodeActions
> 16:13:31 End Action : ValidateNodeActions
> 16:13:31 End Action DialogShowSdClusterDef
> 16:13:31 begin ShowDialogsUpdateMask
> 16:13:31 nFullMask = 0x1bf7c037, nCurrent = 0x10000, nDirection = 1
> 16:13:31 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:31 Dialog 0x10000 returned: 1
> 16:13:31 End Action ShowDialogsHlpr
> 16:13:31 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
> 16:13:31 Begin Action ShowDialogsHlpr: 0x20000
> 16:13:31 Begin Action : Cluster Security - DlgAcct
> 16:13:39 ShowDlgAcct returned: 1
> 16:13:39 [DlgAccount]
> 16:13:39 Domain = <Removed>
> 16:13:40 DomainAcct = <Removed>
> 16:13:40 DomainPwd
> 16:13:40 Result = 1
> 16:13:40 End Action : Cluster Security - DlgAcct
> 16:13:40 begin ShowDialogsUpdateMask
> 16:13:40 nFullMask = 0x1bf7c037, nCurrent = 0x20000, nDirection = 1
> 16:13:40 Updated Dialog Mask: 0x1bf7c037, Disable Back = 0x1
> 16:13:40 Dialog 0x20000 returned: 1
> 16:13:40 End Action ShowDialogsHlpr
> 16:13:40 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
> 16:13:40 Begin Action ShowDialogsHlpr: 0x40000
> 16:13:40 Begin Action: DialogShowSdCliSvr
> 16:13:40 DisplaySystemPreReq
> 16:13:40 ShowDlgClientServerSelect returned: 1
> 16:13:40 Type : 0x2
> 16:13:40 End Action DialogShowSdCliSvr
> 16:13:40 begin ShowDialogsUpdateMask
> 16:13:40 nFullMask = 0x1bf7c037, nCurrent = 0x40000, nDirection = 1
> 16:13:40 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:13:40 Dialog 0x40000 returned: 1
> 16:13:40 End Action ShowDialogsHlpr
> 16:13:40 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
> 16:13:40 Begin Action ShowDialogsHlpr: 0x80000
> 16:13:40 Begin Action: DialogShowSdInstanceName
> 16:13:40 Begin Action: ShowDlgInstanceName
> 16:13:46 End Action: ShowDlgInstanceName
> 16:13:46 ShowDlgInstanceName returned : 1
> 16:13:46 InstanceName : INSTANCEC7
> 16:13:46 End Action DialogShowSdInstanceName
> 16:13:46 begin ShowDialogsUpdateMask
> 16:13:46 nFullMask = 0x1bffc037, nCurrent = 0x80000, nDirection = 1
> 16:13:46 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:13:46 Dialog 0x80000 returned: 1
> 16:13:46 End Action ShowDialogsHlpr
> 16:13:46 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
> 16:13:46 Begin Action ShowDialogsHlpr: 0x100000
> 16:13:46 Begin Action: DialogShowSdSetupType
> 16:13:46 Begin Action: Setup Type
> 16:13:50 [SetupTypeSQL]
> 16:13:50 szDir = C:\Program Files\Microsoft SQL Server
> 16:13:50 szDir = C:\Program Files\Microsoft SQL Server
> 16:13:50 Result = 303
> 16:13:50 szDataDir = R:\Program Files\Microsoft SQL Server
> 16:13:50 szDataDir = R:\Program Files\Microsoft SQL Server
> 16:13:50 End Action: Setup Type
> 16:13:50 Setup Type: Custom (303)
> 16:13:50 End Action DialogShowSdSetupType
> 16:13:50 begin ShowDialogsUpdateMask
> 16:13:50 nFullMask = 0x1bffc037, nCurrent = 0x100000, nDirection = 303
> 16:13:50 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:13:50 Dialog 0x100000 returned: 303
> 16:13:50 End Action ShowDialogsHlpr
> 16:13:50 ShowDialogsGetDialog returned: nCurrent=0x200000,index=21
> 16:13:50 Begin Action ShowDialogsHlpr: 0x200000
> 16:13:50 Begin Action: DialogShowSdComponentMult
> 16:13:50 basesys = 0, baseinst = 0, basedata = 0
> 16:13:50 Begin Action: Component Handler
> 16:13:54 SQL program folder: C:\Program Files\Microsoft SQL
> Server\MSSQL$INSTANCEC7
> 16:13:54 SQL data folder: R:\Program Files\Microsoft SQL
> Server\MSSQL$INSTANCEC7
> 16:13:54 Windows system folder: C:\WINDOWS\system32\
> 16:13:54 Prog req: 22162, Data req: 34432, Sys req: 181286
> 16:13:54 Prog avail: 28555808, Data avail: 61083436, Sys avail: 28555808
> 16:13:54 Prog req vs. avail, 203448, 28555808
> 16:13:54 Data req vs. avail, 34432, 61083436
> 16:13:54 Sys req vs. avail, 181286, 28555808
> 16:13:54 DisplaySystemPreReq
> 16:13:54 [SQLComponentMult]
> 16:13:56 Component =
> 16:13:56 Result = 1
> 16:13:56 End Action: Component Handler
> 16:13:56 End Action DialogShowSdComponentMult
> 16:13:56 begin ShowDialogsUpdateMask
> 16:13:56 nFullMask = 0x1bffc037, nCurrent = 0x200000, nDirection = 1
> 16:13:56 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:13:56 Dialog 0x200000 returned: 1
> 16:13:56 End Action ShowDialogsHlpr
> 16:13:56 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
> 16:13:56 Begin Action ShowDialogsHlpr: 0x400000
> 16:13:56 Begin Action: DlgServices
> 16:14:15 ShowDlgServices returned: 1
> 16:14:15 [DlgServices]
> 16:14:15 Local-Domain = 61680
> 16:14:15 AutoStart = 0
> 16:14:15 SQLDomain = <Removed>
> 16:14:15 SQLDomainAcct = <Removed>
> 16:14:15 SQLDomainPwd
> 16:14:15 AgtDomain = <Removed>
> 16:14:15 AgtDomainAcct = <Removed>
> 16:14:15 AgtDomainPwd
> 16:14:15 Result = 1
> 16:14:15 End Action DlgServices
> 16:14:15 begin ShowDialogsUpdateMask
> 16:14:15 nFullMask = 0x1bffc037, nCurrent = 0x400000, nDirection = 1
> 16:14:15 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:14:15 Dialog 0x400000 returned: 1
> 16:14:15 End Action ShowDialogsHlpr
> 16:14:15 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
> 16:14:15 Begin Action ShowDialogsHlpr: 0x800000
> 16:14:15 Begin Action: DlgSQLSecurity
> 16:14:19 ShowDlgSQLSecurity returned: 1
> 16:14:19 LoginMode = 1,szPwd
> 16:14:19 End Action DlgSQLSecurity
> 16:14:19 begin ShowDialogsUpdateMask
> 16:14:19 nFullMask = 0x1bffc037, nCurrent = 0x800000, nDirection = 1
> 16:14:19 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:14:19 Dialog 0x800000 returned: 1
> 16:14:19 End Action ShowDialogsHlpr
> 16:14:19 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
> 16:14:19 Begin Action ShowDialogsHlpr: 0x1000000
> 16:14:19 Begin Action: DlgCollation
> 16:14:24 ShowDlgCollation returned: 1
> 16:14:24 collation_name = SQL_Latin1_General_CP1_CI_AS,locale_name = ,lcid
> =
> 0x409,SortId = 52,dwCompFlags = 0x30001
> 16:14:24 End Action DlgCollation
> 16:14:24 begin ShowDialogsUpdateMask
> 16:14:24 nFullMask = 0x1bffc037, nCurrent = 0x1000000, nDirection = 1
> 16:14:24 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:14:24 Dialog 0x1000000 returned: 1
> 16:14:24 End Action ShowDialogsHlpr
> 16:14:24 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
> 16:14:24 Begin Action ShowDialogsHlpr: 0x2000000
> 16:14:24 Begin Action: DlgNetwork
> 16:14:29 ShowDlgNetwork returned: 1
> 16:14:29 [DlgServerNetwork]
> 16:14:29 NetworkLibs = 255
> 16:14:29 TCPPort = 0
> 16:14:29 TCPPrxy = Default
> 16:14:29 NMPPipeName = \\.\pipe\MSSQL$INSTANCEC7\sql\query
> 16:14:29 Result = 1
> 16:14:29 End Action DlgNetwork
> 16:14:29 begin ShowDialogsUpdateMask
> 16:14:29 nFullMask = 0x1bffc037, nCurrent = 0x2000000, nDirection = 1
> 16:14:29 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:14:29 Dialog 0x2000000 returned: 1
> 16:14:29 End Action ShowDialogsHlpr
> 16:14:29 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
> 16:14:29 Begin Action ShowDialogsHlpr: 0x8000000
> 16:14:29 Begin Action: DialogShowSdStartCopy
> 16:14:30 End Action DialogShowSdStartCopy
> 16:14:30 begin ShowDialogsUpdateMask
> 16:14:30 nFullMask = 0x1bffc037, nCurrent = 0x8000000, nDirection = 1
> 16:14:30 Updated Dialog Mask: 0x1bffc037, Disable Back = 0x1
> 16:14:30 Dialog 0x8000000 returned: 1
> 16:14:30 End Action ShowDialogsHlpr
> 16:14:30 ShowDialogsGetDialog returned: nCurrent=0x10000000,index=28
> 16:14:30 Begin Action ShowDialogsHlpr: 0x10000000
> 16:14:30 Begin Action: DialogShowSdLicenseMode
> 16:14:34 ShowDlgLicense returned: 1
> 16:14:34 ShowDlgLicense returned: LicenseMode = 0, LicenseLimit = 999
> 16:14:34 End Action DialogShowSdLicenseMode
> 16:14:34 Dialog 0x10000000 returned: 1
> 16:14:34 End Action ShowDialogsHlpr
> 16:14:34 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
> 16:14:34 End Action ShowDialogs
> 16:14:34 Setup is installing Microsoft Distributed Transaction Coordinator
> (MSDTC) ...
> 16:14:34 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
> "C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\Other\dtcsetup.exe" -LogFile
> "C:\WINDOWS\sqlstp.log" -CtxAcct "<Removed>" -<Removed>
> 16:14:34 Process Exit Code: (0)
> 16:14:34 Begin Action : ClusterSetupHelper
> 16:14:34 Begin Action : CreateClustISSFiles
> 16:14:34 End Action : CreateClustISSFiles
> 16:14:34 Begin Action : ClusterWriteRemIni
> 16:14:34 End Action : ClusterWriteRemIni
> 16:14:34 Begin Action : Run setup on cluster nodes
> [args]
> NumRemoteServers=3
> Server.1=NPBSQL6
> Server.2=NPBSQL7
> Server.3=NPBSQL8
> [Server.1]
> NumRemoteServices=1
> 1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
> 1.server=NPBSQL6
> 1.script=\\NPBSQL6\admin$\NPBSQL6_INSTANCEC7.iss
> 1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
> "\\NPBSQL6\admin$\setup.log" -e "stpsilnt._ex" -b -x "C:\WINDOWS\TEMP\"
> 1.user=<Removed>
> 1.password=<Removed>
> 1.name=<Removed>
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc1.exe
> [Server.2]
> NumRemoteServices=1
> 1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
> 1.server=NPBSQL7
> 1.script=\\NPBSQL6\admin$\NPBSQL7_INSTANCEC7.iss
> 1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
> "\\NPBSQL7\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
> 1.user=<Removed>
> 1.password=095b2c9b3941a75cd961
> 1.name=SQLSetup2
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc2.exe
> [Server.3]
> NumRemoteServices=1
> 1.app=\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
> 1.server=NPBSQL8
> 1.script=\\NPBSQL6\admin$\NPBSQL8_INSTANCEC7.iss
> 1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1 %s -f2
> "\\NPBSQL8\admin$\setup.log" -e "stpsilnt._ex" -x "C:\"
> 1.user=<Removed>
> 1.password=095b2c9b3941a75cd961
> 1.name=SQLSetup3
> 1.sqlsetup=Y
> 1.copyexe=cnvsvc3.exe
> 16:14:34 Setup is performing required operations on cluster nodes. This
> may
> take a few minutes...
> 16:14:34 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe
> C:\WINDOWS\remsetup.ini
> 16:16:41 Process Exit Code: (0)
> 16:16:41 Begin Action : GetRemsetupRetCode
> 16:16:41 Installation return status on NPBSQL6 : 0
> 16:16:41 Installation return status on NPBSQL7 : 0
> 16:16:41 Installation return status on NPBSQL8 : 0
> 16:16:41 End Action : GetRemsetupRetCode
> #### SQL Server Remote Setup - Start Time 05/18/05 16:14:34 ####
> CThreadPool::RunUntilCompleteHlpr create thread, index=0
> CThread::Run thread [0x78] created for execution.
> CThread::Process [0x78]
> CThreadPool::RunUntilCompleteHlpr create thread, index=1
> Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe k=Nb
> k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
> \\NPBSQL6\admin$\NPBSQL6_INSTANCEC7.iss -f2
> "\\NPBSQL6\admin$\setup.log" -e
> "stpsilnt._ex" -b -x "C:\WINDOWS\TEMP\"' (NPBSQL6) ...
> CThread::Run thread [0x80] created for execution.
> CThread::Process [0x80]
> CThreadPool::RunUntilCompleteHlpr create thread, index=2
> CThread::Run thread [0x84] created for execution.
> CThread::Process [0x84]
> CThreadPool::RunUntilCompleteHlpr start thread [0x78],index=0
> CThreadPool::RunUntilCompleteHlpr start thread [0x80],index=1
> CThreadPool::RunUntilCompleteHlpr start thread [0x84],index=2
> Script file copied to '\\NPBSQL8\ADMIN$\NPBSQL8_INSTANCEC7.iss'
> successfully.
> Script file copied to '\\NPBSQL7\ADMIN$\NPBSQL7_INSTANCEC7.iss'
> successfully.
> Installing remote service (NPBSQL8)...
> Installing remote service (NPBSQL7)...
> Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
> k=ClSec k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
> \\NPBSQL8\ADMIN$\NPBSQL8_INSTANCEC7.iss -f2
> "\\NPBSQL8\admin$\setup.log" -e
> "stpsilnt._ex" -x "C:\"' (NPBSQL8) ...
> Running '\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setupsql.exe
> k=ClSec k=Rm k=Cl -SMS -s -f
> "\\NPB2KNAS1\APPS\APPS-IT\SQL\SQL2K_~1\x86\setup\setup.ins" -f1
> \\NPBSQL7\ADMIN$\NPBSQL7_INSTANCEC7.iss -f2
> "\\NPBSQL7\admin$\setup.log" -e
> "stpsilnt._ex" -x "C:\"' (NPBSQL7) ...
> CRemoteProcess::RunUntilComplete [0x84] exit code: 0
> Remote process exit code was '0' (NPBSQL8).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x84]
> Thread [0x84] exit code: [0x0]
> CRemoteProcess::RunUntilComplete [0x80] exit code: 0
> Remote process exit code was '0' (NPBSQL7).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x80]
> Thread [0x80] exit code: [0x0]
> CProcess::RunUntilComplete [0x78] exit code: 0
> Remote process exit code was '0' (NPBSQL6).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x78]
> Thread [0x78] exit code: [0x0]
> CThreadPool::RunUntilComplete returned 0
> CThreadPool::RunUntilComplete execution level=1, need execution: 0
> Disconnecting from remote machine (NPBSQL6)...
> Service removed successfully.
> Remote files could not be removed.
> #### SQL Server Remote Setup - Stop Time 05/18/05 16:16:07 ####
> Disconnecting from remote machine (NPBSQL7)...
> Service removed successfully.
> Remote files removed successfully.
> #### SQL Server Remote Setup - Stop Time 05/18/05 16:16:24 ####
> Disconnecting from remote machine (NPBSQL8)...
> Service removed successfully.
> Remote files removed successfully.
> #### SQL Server Remote Setup - Stop Time 05/18/05 16:16:41 ####
>
> 16:16:41 End Action : Run setup on cluster nodes
> 16:16:41 SetClusterSecuritySQL (<Removed>) and (<Removed>) returned: 0
> 16:16:41 Begin Action : CreateVirtualServerResources
> 16:16:49 End Action : CreateVirtualServerResources
> 16:16:49 CreateVirtualServerResources returned: 2
>
>
|||Thanks for the quick reply. I did try copying the install folder over
locally and ended up with the same error message.
"Geoff N. Hiten" wrote:

> SQL Clusters sometimes don't like installing from a network share. Burn a
> CD and physically place it in the node you are running install on.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:22BF14DE-8ECE-48FD-BCF9-6D811C6F8277@.microsoft.com...
>
>
|||Make sure both the SQL Service account and the install account are domain
accounts with administrators group membership on all nodes. Check the TMP
and TEMP system variable paths on all nodes. Log in to each server with
each account at least once before installing.
Geoff N. Hiten
Microsoft SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:D22ECFA7-0ECC-492E-98E9-60D3BBBF4A12@.microsoft.com...[vbcol=seagreen]
> Thanks for the quick reply. I did try copying the install folder over
> locally and ended up with the same error message.
> "Geoff N. Hiten" wrote:
|||Thansk again for the response!
I have logged onto each machine previous with the install account. As for
the accounts. The install account I'm using is the Domain Admin account, so
that should be alright. Also, the network accounts I'm using for both the
SQLService and the Cluster service are in the node's Local Admins group.
On all the nodes the TEMP and TMP variables for the Install account is
listed as %USERPROFILE%\Local Settings\Temp. For the system it's
%SystemRoot%\TEMP
I changed them all to %SystemRoot%\TEMP (Replaced %systemroot% with the
actual path name as well.)
Still got the error message right after it tries to create the cluster
resources.
Now previously I had an install of SQL installed on these nodes that were
SP'd up to 3a. Could that be causing any of the issues?
"Geoff N. Hiten" wrote:

> Make sure both the SQL Service account and the install account are domain
> accounts with administrators group membership on all nodes. Check the TMP
> and TEMP system variable paths on all nodes. Log in to each server with
> each account at least once before installing.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:D22ECFA7-0ECC-492E-98E9-60D3BBBF4A12@.microsoft.com...
>
>
|||Hmm, I'm wondering if it does have something to do with some SP3a files stuck
on that local machine. I attempted to install it to just a single node as
per http://support.microsoft.com/default...b;en-us;318672 and still
got the same error.
Not sure how I can dig out any files, at this point a full re-install may be
in order.
"Geoff N. Hiten" wrote:

> Make sure both the SQL Service account and the install account are domain
> accounts with administrators group membership on all nodes. Check the TMP
> and TEMP system variable paths on all nodes. Log in to each server with
> each account at least once before installing.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:D22ECFA7-0ECC-492E-98E9-60D3BBBF4A12@.microsoft.com...
>
>
|||An old install with incomplete removal might cause some issues.
This article will help remove any trace of the old SQL installation:
How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/default...b;en-us;290991
Geoff N. Hiten
Microsoft SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:E981A9F3-B54A-4D0A-AEEC-AA218EA2E717@.microsoft.com...[vbcol=seagreen]
> Thansk again for the response!
> I have logged onto each machine previous with the install account. As for
> the accounts. The install account I'm using is the Domain Admin account,
> so
> that should be alright. Also, the network accounts I'm using for both the
> SQLService and the Cluster service are in the node's Local Admins group.
> On all the nodes the TEMP and TMP variables for the Install account is
> listed as %USERPROFILE%\Local Settings\Temp. For the system it's
> %SystemRoot%\TEMP
> I changed them all to %SystemRoot%\TEMP (Replaced %systemroot% with the
> actual path name as well.)
> Still got the error message right after it tries to create the cluster
> resources.
> Now previously I had an install of SQL installed on these nodes that were
> SP'd up to 3a. Could that be causing any of the issues?
> "Geoff N. Hiten" wrote:
|||One other thing I once ran into:
Check C:\Documents and Settings
Maybe on one node you logged on locally before, and the other not. You might
have differences. e.g.:
Node A
Administrator
Administrator.domain
Node B
Administrator
The profile-directory for the account you are using has to be the same on
both nodes. It's kind of tricky ...
Chau chau,
Pascalos
"Chris" wrote:
[vbcol=seagreen]
> Hmm, I'm wondering if it does have something to do with some SP3a files stuck
> on that local machine. I attempted to install it to just a single node as
> per http://support.microsoft.com/default...b;en-us;318672 and still
> got the same error.
> Not sure how I can dig out any files, at this point a full re-install may be
> in order.
> "Geoff N. Hiten" wrote:

Error attempting to add server to Active Directory

While attempting to add a SQL Server to the Active Directory, I
received an error stating that the MSSQLServerADHelper service could
not be started. The service is set to manual startup. When I attempt
to start the service myself, I get the following error that I cannot
find any information on in the KB:
The MSSQLServerADHelp service terminated with the service-specific
error 3221225572.
Also searched for $C0000064 in hopes that the error was listed in hex,
to no avail.
Any ideas what the problem is?
Thanks,
Brandon
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)Issue appears to be related to security. I changed the SQLServer and
SQLAgent startup account to administrator and tried again, and it
successfully added itself to AD through Enterprise Manager.
I think the security for the old security account is messed up. I am
going to remove it and try again.
Brandon
--
"In the beginning the universe was created. This has made a lot of
people very angry, and has been widely regarded as a bad move." -
Douglas Noel Adams (1952-2001)|||please refer to:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/architec/8_ar_cs_9mhx.asp
this behaviour is by design, you cannot start
MSSQLServerADHelp service manually, it is started by sql
server or analyis services whenever needed and then stopes
it when done.
Make sure the start up account for MSSQLServerADHelp is
Local System, and also that the server is member of a AD
domain. and sql server service start up account should
have permission to start MSSQLServerADHelp service.
>--Original Message--
>While attempting to add a SQL Server to the Active
Directory, I
>received an error stating that the MSSQLServerADHelper
service could
>not be started. The service is set to manual startup.
When I attempt
>to start the service myself, I get the following error
that I cannot
>find any information on in the KB:
>The MSSQLServerADHelp service terminated with the service-
specific
>error 3221225572.
>Also searched for $C0000064 in hopes that the error was
listed in hex,
>to no avail.
>Any ideas what the problem is?
>Thanks,
>Brandon
>--
>"In the beginning the universe was created. This has
made a lot of
>people very angry, and has been widely regarded as a bad
move." -
>Douglas Noel Adams (1952-2001)
>
>.
>

Error Adding SQL Server to Active Directory

Hi,
I've just installed SQL 2000 SE on a server and specified seperate domain
accounts for the services to run under. Now when I go to the server
properties and the Active Directory tab to add the server to AD I get the
following error:
SQL Server Enterprise Manager could not add server '(local)' to Active
Directory. Error 22039: xpadsi.exe failed.
Anyone else had this problem?
Thanks - Dave.yes. did you ever work out how to fix it ?
"Dave Rhodes" wrote:

> Hi,
> I've just installed SQL 2000 SE on a server and specified seperate domain
> accounts for the services to run under. Now when I go to the server
> properties and the Active Directory tab to add the server to AD I get the
> following error:
> SQL Server Enterprise Manager could not add server '(local)' to Active
> Directory. Error 22039: xpadsi.exe failed.
> Anyone else had this problem?
> Thanks - Dave.
>
>

Error Adding SQL Server to Active Directory

Hi,
I've just installed SQL 2000 SE on a server and specified seperate domain
accounts for the services to run under. Now when I go to the server
properties and the Active Directory tab to add the server to AD I get the
following error:
SQL Server Enterprise Manager could not add server '(local)' to Active
Directory. Error 22039: xpadsi.exe failed.
Anyone else had this problem?
Thanks - Dave.yes. did you ever work out how to fix it ?
"Dave Rhodes" wrote:
> Hi,
> I've just installed SQL 2000 SE on a server and specified seperate domain
> accounts for the services to run under. Now when I go to the server
> properties and the Active Directory tab to add the server to AD I get the
> following error:
> SQL Server Enterprise Manager could not add server '(local)' to Active
> Directory. Error 22039: xpadsi.exe failed.
> Anyone else had this problem?
> Thanks - Dave.
>
>

Error Adding SQL Server to Active Directory

Hi,
I've just installed SQL 2000 SE on a server and specified seperate domain
accounts for the services to run under. Now when I go to the server
properties and the Active Directory tab to add the server to AD I get the
following error:
SQL Server Enterprise Manager could not add server '(local)' to Active
Directory. Error 22039: xpadsi.exe failed.
Anyone else had this problem?
Thanks - Dave.
yes. did you ever work out how to fix it ?
"Dave Rhodes" wrote:

> Hi,
> I've just installed SQL 2000 SE on a server and specified seperate domain
> accounts for the services to run under. Now when I go to the server
> properties and the Active Directory tab to add the server to AD I get the
> following error:
> SQL Server Enterprise Manager could not add server '(local)' to Active
> Directory. Error 22039: xpadsi.exe failed.
> Anyone else had this problem?
> Thanks - Dave.
>
>