Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / Other Technologies / Clustering / September 2005

Tip: Looking for answers? Try searching our database.

SQL SP4 Instalation Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JesusRP - 25 Jul 2005 13:35 GMT
I have a 2 node windows cluster, and few days ago 1 node died, after install
again the node that failed, when i want to install the SP4 of SQL I can´t
beacuse "not all operations could be reached in all nodes". I have this
errors on the new node that i have installed.

SETUP.LOG
[InstallShield Silent]
Version=v5.00.000
File=Log File
[ResponseResult]
ResultCode=-12

SQLSP0.LOG
17:55:44 Begin Setup
17:55:44 Version on Media: 8.00.2039
17:55:44 Mode = Silent
17:55:44 ModeType = CLUSTER
17:55:44 Cluster node.
17:55:44 Cluster secondary node.
17:55:44 Cluster secondary node.
17:55:45 g_szIssPath=C:\WINNT\setup~0.iss
17:55:45 Loading library - sqlsut.dll (#L1)
17:55:45 Begin: SetupInitialize()
17:55:45 End: SetupInitialize()
17:55:45 Begin:  CheckFixedRequirements()
17:55:45 Platform ID: 0xf00000
17:55:45 Version: 5.0.2195
17:55:45 File Version - C:\WINNT\system32\shdocvw.dll: 6.0.2800.1658
17:55:45 End:  CheckFixedRequirements()
17:55:45 Processor Architecture: x86 (Pentium)
17:55:45 Service Pack:  1024
17:55:45 ComputerName: *********
17:55:45 User Name: *********
17:55:45 IsAllAccessAllowed returned: 1
17:55:45 OS Language: 0xc0a
17:55:45 Begin:  SetupInstall()
17:55:45 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
17:55:45 CommonFilesDir=C:\Archivos de programa\Archivos comunes
17:55:45 Windows Directory=C:\WINNT\
17:55:45 Program Files=C:\Archivos de programa\
17:55:45 TEMPDIR=C:\DOCUME~1\USUARI~2.GAR\CONFIG~1\Temp\
17:55:45 End:  SetupInstall()
17:55:45 Begin:  ShowDialogs()
17:55:45 Initial Dialog Mask: 0x8300037, Disable Back=0x1
17:55:45 Begin Action ShowDialogsHlpr: 0x1
17:55:45 Begin Action:  DialogShowSdWelcome
17:55:45 End Action  DialogShowSdWelcome
17:55:45 Dialog 0x1 returned: 1
17:55:45 End Action ShowDialogsHlpr
17:55:45 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
17:55:45 Begin Action ShowDialogsHlpr: 0x2
17:55:45 Begin Action:  DialogShowSdMachineName
17:55:45 [DlgMachine]
17:55:45 Result = 1
17:55:45 Type = 536870922
17:55:45 Name = ********
17:55:45 ShowDlgMachine returned: 1
17:55:45 Could not find out whether the SQL Server was online
17:55:45 Name = ********, Type = 0x2000000a
17:55:45 End Action  DialogShowSdMachineName
17:55:45 begin ShowDialogsUpdateMask
17:55:45 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 1
17:55:46 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
17:55:46 Dialog 0x2 returned: 1
17:55:46 End Action ShowDialogsHlpr
17:55:46 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
17:55:46 Begin Action ShowDialogsHlpr: 0x4
17:55:46 Begin Action:  DialogShowSdInstallMode
17:55:46 [DlgInstallMode]
17:55:46 Result = 1
17:55:46 Type = 2
17:55:46 ShowDlgInstallMode returned: 1
17:55:46 InstallMode : 0x2
17:55:46 End Action  DialogShowSdInstallMode
17:55:46 begin ShowDialogsUpdateMask
17:55:46 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
17:55:46 Updated Dialog Mask: 0xb034607, Disable Back = 0x1
17:55:46 Dialog 0x4 returned: 1
17:55:46 End Action ShowDialogsHlpr
17:55:46 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
17:55:46 Begin Action ShowDialogsHlpr: 0x200
17:55:46 Begin Action:  DialogShowSdInstanceName
17:55:46 [DlgInstanceName]
17:55:46 Result = 1
17:55:46 InstanceName = BDEXP1
17:55:46 Begin Action: ShowDlgInstanceName
17:55:46 SKU is : Enterprise Edition
17:55:46 End Action: ShowDlgInstanceName
17:55:46 ShowDlgInstanceName returned : 67
17:55:46 InstanceName : BDEXP1
17:55:46 End Action  DialogShowSdInstanceName
17:55:46 begin ShowDialogsUpdateMask
17:55:46 nFullMask = 0xb034607, nCurrent = 0x200, nDirection = 67
17:55:46 Updated Dialog Mask: 0xb034603, Disable Back = 0x1
17:55:46 Dialog 0x200 returned: 67
17:55:46 End Action ShowDialogsHlpr
17:55:46 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
17:55:46 Begin Action ShowDialogsHlpr: 0x400
17:55:46 Begin Action:  DialogShowSdMaintain
17:55:46 [DlgMaintainInstall]
17:55:46 Result = 1
17:55:46 Type = 12
17:55:46 ShowDlgMaintainInstall returned : 1
17:55:46 Type : 0xc
17:55:46 CreateSetupTopology(********), Handle : 0x19a51a0, returned : 0
17:55:46 CreateSetupTopology returned : 0, Handle : 0x19a51a0
17:55:46 Topology Type : 1, Return Value : 0
17:55:46 ST_GetPhysicalNode returned : 0, PNHandle : 0x19a4288
17:55:46 PN_EnumerateEx returned : 0
17:55:46 PN_GetSQLStates returned : 0, SqlStates : 0x88020020
17:55:46 PN_GetInstance for BDEXP1 [0x19a4288] returned : 0
17:55:46 SQLI_GetPackageId [0x19a6440] returned : 0, PackageId = 0x3
17:55:46 SQLI_GetVersion [0x19a6440] returned : 0, Version = 8.00.194
17:55:46 SQLI_GetSQLStates for BDEXP1 [0x19a6440] returned : 0, SQLStates:
0x420808
17:55:46 SQLI_GetInstallPath [0x19a6440] returned : 0, Path = C:\Archivos de
programa\Microsoft SQL Server\MSSQL$BDEXP1
17:55:46 SQLI_GetDataPath [0x19a6440] returned : 0, DataPath = S:\Archivos
de programa\Microsoft SQL Server\MSSQL$BDEXP1
17:55:46 SQLI_GetVersion [0x19a6440] returned : 0, Version = 8.00.194
17:55:46 SQLI_GetRegKeyRoot [0x19a6440] returned : 0, RegKeyRoot =
Software\Microsoft\Microsoft SQL Server\BDEXP1
17:55:46 SQLI_GetPackageName [0x19a6440] returned : 0, szPackage =
Enterprise Edition
17:55:46 SQLI_GetPackageId [0x19a6440] returned : 0, PackageId = 0x3
17:55:46 Previous Install Path:    C:\Archivos de programa\Microsoft SQL
Server\MSSQL$BDEXP1
17:55:46 Previous Install Data:    S:\Archivos de programa\Microsoft SQL
Server\MSSQL$BDEXP1
17:55:46 Previous Install Version: 8.00.194
17:55:46 ReleaseSetupTopology
17:55:46 End Action  DialogShowSdMaintain
17:55:46 begin ShowDialogsUpdateMask
17:55:46 nFullMask = 0xb034603, nCurrent = 0x400, nDirection = 1
17:55:46 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
17:55:46 Dialog 0x400 returned: 1
17:55:46 End Action ShowDialogsHlpr
17:55:46 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
17:55:46 Begin Action ShowDialogsHlpr: 0x2000
17:55:46 Begin Action:  DialogShowSdUpgrade
17:55:46 [DlgUpgrade]
17:55:46 Result = 1
17:55:46 ShowDlgUpgrade returned : 1
17:55:46 Checking databases on instance 'BDEXP1'
17:55:46 Authenticate access
17:55:46 Begin SDPassword Dialog
17:55:46 Begin: CheckSAPassword
17:55:46 WARNING : No Blank SA Pwd
17:55:46 End: CheckSAPassword
17:55:46 Begin: SdShowSp3WrngDlg

on the 2 node all ok.
Some one know how solution that. Thanks.
Reply to this Message
Geoff N. Hiten - 27 Jul 2005 14:47 GMT
It appears that SQL still has installation information about the old node.
You may need to run the SQL installer to remove the node information from
the existing SQL installation.  Once all traces of the old node are gone
from SQL you can install to the new node.

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

>I have a 2 node windows cluster, and few days ago 1 node died, after
>install
[quoted text clipped - 152 lines]
> on the 2 node all ok.
> Some one know how solution that. Thanks.
Reply to this Message
JesusRP - 28 Jul 2005 10:36 GMT
I really do that, i remove the node like microsoft cluster failover guide and
I install sql server twice. The SQL 200.80.194.0 it´s rally installed but
when i try to install the SQL SP4 in the node that its running i get that
error. I dont thik so that its a problem with the instalation of SQL, it´s
install ok.

"Geoff N. Hiten" escribió:

> It appears that SQL still has installation information about the old node.
> You may need to run the SQL installer to remove the node information from
[quoted text clipped - 161 lines]
> > on the 2 node all ok.
> > Some one know how solution that. Thanks.
Reply to this Message
Geoff N. Hiten - 28 Jul 2005 14:19 GMT
There is an additional step to removing SQL from a failed node besides just
removing the node from the cluster.  That was the step I referred to.  If
SQL thinks it is still installed on the old node, even if the node is no
longer part of the cluster, the SP install will fail.

You may also want to try running SP4 from the new node.  It should do a
local binary-only upgrade.

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

Try running the SQL SP4 installer from the new node.
>I really do that, i remove the node like microsoft cluster failover guide
>and
[quoted text clipped - 179 lines]
>> > on the 2 node all ok.
>> > Some one know how solution that. Thanks.
Reply to this Message
JesusRP - 12 Aug 2005 10:00 GMT
I had installed a single instace of sql in the new node, and all is ok no
problen to install sql + sql sp4.
Again i desintall the new node from sql server setup and i remove al
directories, and all references in registry to SQL server and to the old
references that i had in the cluster instance. (only one i can´t remove,
thats name is LEGACY_INSTACENAME, but no service with that name in
hardware/services). After that i intall again sql setup and add the new node
to the cluster without problems (SQL 2K). I saw that in cluster manager after
i install the sql no apears in the group of the sql instace the new node but
in the sql server setup it´s ok. After that I try to install again the
sql2ksp4 with the same result, in the new node the setup.log fail with
result=-12.
Some idea?

"Geoff N. Hiten" escribió:

> There is an additional step to removing SQL from a failed node besides just
> removing the node from the cluster.  That was the step I referred to.  If
[quoted text clipped - 192 lines]
> >> > on the 2 node all ok.
> >> > Some one know how solution that. Thanks.
Reply to this Message
Geoff N. Hiten - 12 Aug 2005 10:50 GMT
According to the Install log, you appear to be running Windows 2003.  Have
you looked at this article:

Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/default.aspx?scid=kb;en-us;815431

If that doesn't work, reply and attach the latest log.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

>I had installed a single instace of sql in the new node, and all is ok no
> problen to install sql + sql sp4.
[quoted text clipped - 222 lines]
>> >> > on the 2 node all ok.
>> >> > Some one know how solution that. Thanks.
Reply to this Message
JesusRP - 16 Aug 2005 09:08 GMT
I have 2 windows 2000 advanced server sp4

The sqlsp.log in the old node:
17:12:45 Begin Setup
17:12:45 Version on Media: 8.00.2039
17:12:45 Mode = Normal
17:12:45 ModeType = NORMAL
17:12:45 Loading library - sqlsut.dll (#L1)
17:12:45 Begin: SetupInitialize()
17:12:45 End: SetupInitialize()
17:12:45 Begin:  CheckFixedRequirements()
17:12:45 Platform ID: 0xf00000
17:12:45 Version: 5.0.2195
17:12:45 File Version - C:\WINNT\system32\shdocvw.dll: 6.0.2800.1658
17:12:45 End:  CheckFixedRequirements()
17:12:45 Processor Architecture: x86 (Pentium)
17:12:45 Service Pack:  1024
17:12:45 ComputerName: GARAJONAY14
17:12:45 User Name: Administrador
17:12:45 IsAllAccessAllowed returned: 1
17:12:45 OS Language: 0xc0a
17:12:45 Begin:  SetupInstall()
17:12:45 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
17:12:45 CommonFilesDir=C:\Archivos de programa\Archivos comunes
17:12:45 Windows Directory=C:\WINNT\
17:12:45 Program Files=C:\Archivos de programa\
17:12:45 TEMPDIR=C:\DOCUME~1\ADMINI~2.GAR\CONFIG~1\Temp\
17:12:45 End:  SetupInstall()
17:12:46 Begin:  ShowDialogs()
17:12:46 Initial Dialog Mask: 0x8300037, Disable Back=0x1
17:12:46 Begin Action ShowDialogsHlpr: 0x1
17:12:46 Begin Action:  DialogShowSdWelcome
17:12:47 End Action  DialogShowSdWelcome
17:12:47 Dialog 0x1 returned: 1
17:12:47 End Action ShowDialogsHlpr
17:12:47 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
17:12:47 Begin Action ShowDialogsHlpr: 0x2
17:12:47 Begin Action:  DialogShowSdMachineName
17:12:52 ShowDlgMachine returned: 1
17:12:52 Name = SQLCLUSTEREXP2, Type = 0x20000008
17:12:52 End Action  DialogShowSdMachineName
17:12:52 begin ShowDialogsUpdateMask
17:12:52 nFullMask = 0x8300037, nCurrent = 0x2, nDirection = 1
17:12:52 Updated Dialog Mask: 0xb73c037, Disable Back = 0x1
17:12:52 Dialog 0x2 returned: 1
17:12:52 End Action ShowDialogsHlpr
17:12:52 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
17:12:52 Begin Action ShowDialogsHlpr: 0x4
17:12:52 Begin Action:  DialogShowSdInstallMode
17:12:52 ShowDlgInstallMode returned: 1
17:12:52 InstallMode : 0x2
17:12:52 End Action  DialogShowSdInstallMode
17:12:52 begin ShowDialogsUpdateMask
17:12:52 nFullMask = 0xb73c037, nCurrent = 0x4, nDirection = 1
17:12:52 Updated Dialog Mask: 0xb034607, Disable Back = 0x1
17:12:52 Dialog 0x4 returned: 1
17:12:52 End Action ShowDialogsHlpr
17:12:52 ShowDialogsGetDialog returned: nCurrent=0x200,index=9
17:12:52 Begin Action ShowDialogsHlpr: 0x200
17:12:52 Begin Action:  DialogShowSdInstanceName
17:12:52 Begin Action: ShowDlgInstanceName
17:12:52 SKU is : Enterprise Edition
17:12:52 End Action: ShowDlgInstanceName
17:12:52 ShowDlgInstanceName returned : 0
17:12:52 InstanceName : BDEXP2
17:12:52 End Action  DialogShowSdInstanceName
17:12:52 begin ShowDialogsUpdateMask
17:12:52 nFullMask = 0xb034607, nCurrent = 0x200, nDirection = 0
17:12:52 Updated Dialog Mask: 0xb034603, Disable Back = 0x1
17:12:52 Dialog 0x200 returned: 0
17:12:52 End Action ShowDialogsHlpr
17:12:52 ShowDialogsGetDialog returned: nCurrent=0x400,index=10
17:12:52 Begin Action ShowDialogsHlpr: 0x400
17:12:52 Begin Action:  DialogShowSdMaintain
17:12:52 ShowDlgMaintainInstall returned : 1
17:12:52 Type : 0xc
17:12:52 CreateSetupTopology(GARAJONAY14), Handle : 0x19a5aa8, returned : 0
17:12:52 CreateSetupTopology returned : 0, Handle : 0x19a5aa8
17:12:52 Topology Type : 1, Return Value : 0
17:12:52 ST_GetPhysicalNode returned : 0, PNHandle : 0x19a4200
17:12:52 PN_EnumerateEx returned : 0
17:12:52 PN_GetSQLStates returned : 0, SqlStates : 0x88020020
17:12:52 PN_GetInstance for BDEXP2 [0x19a4200] returned : 0
17:12:52 SQLI_GetPackageId [0x19a5158] returned : 0, PackageId = 0x3
17:12:52 SQLI_GetVersion [0x19a5158] returned : 0, Version = 8.00.194
17:12:52 SQLI_GetSQLStates for BDEXP2 [0x19a5158] returned : 0, SQLStates:
0x420808
17:12:52 SQLI_GetInstallPath [0x19a5158] returned : 0, Path = C:\Archivos de
programa\Microsoft SQL Server\MSSQL$BDEXP2
17:12:52 SQLI_GetDataPath [0x19a5158] returned : 0, DataPath = T:\Archivos
de programa\Microsoft SQL Server\MSSQL$BDEXP2
17:12:52 SQLI_GetVersion [0x19a5158] returned : 0, Version = 8.00.194
17:12:52 SQLI_GetRegKeyRoot [0x19a5158] returned : 0, RegKeyRoot =
Software\Microsoft\Microsoft SQL Server\BDEXP2
17:12:52 SQLI_GetPackageName [0x19a5158] returned : 0, szPackage =
Enterprise Edition
17:12:52 SQLI_GetPackageId [0x19a5158] returned : 0, PackageId = 0x3
17:12:52 Previous Install Path:    C:\Archivos de programa\Microsoft SQL
Server\MSSQL$BDEXP2
17:12:52 Previous Install Data:    T:\Archivos de programa\Microsoft SQL
Server\MSSQL$BDEXP2
17:12:52 Previous Install Version: 8.00.194
17:12:52 ReleaseSetupTopology
17:12:52 End Action  DialogShowSdMaintain
17:12:52 begin ShowDialogsUpdateMask
17:12:52 nFullMask = 0xb034603, nCurrent = 0x400, nDirection = 1
17:12:52 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
17:12:52 Dialog 0x400 returned: 1
17:12:52 End Action ShowDialogsHlpr
17:12:52 ShowDialogsGetDialog returned: nCurrent=0x2000,index=13
17:12:52 Begin Action ShowDialogsHlpr: 0x2000
17:12:52 Begin Action:  DialogShowSdUpgrade
17:12:52 ShowDlgUpgrade returned : 1
17:12:52 Checking databases on instance 'BDEXP2'
17:12:52 Begin Action: Check for VS Node
17:12:52 Begin Action: Check for VS Node
17:12:52 Begin Action: Cluster Resources Offline
17:12:57 End Action: Cluster Resources Offline
17:12:57 Authenticate access
17:12:57 Begin SDPassword Dialog
17:12:59 End SDPassword Dialog
17:12:59 C:\DOCUME~1\ADMINI~2.GAR\CONFIG~1\Temp\SqlSetup\Bin\scm.exe  
-Silent 1 -Action 6 -Service MSSQL$BDEXP2  
17:12:59 Process Exit Code: (0)
17:12:59 C:\DOCUME~1\ADMINI~2.GAR\CONFIG~1\Temp\SqlSetup\Bin\scm.exe  
-Silent 1 -Action 1 -Service MSSQL$BDEXP2   -StartupOptions \-T4022
17:13:10 Process Exit Code: (0)
17:13:10 C:\SQL\SQL2KSP4\x86\BINN\osql.exe  -Slpc:SQLCLUSTEREXP2\BDEXP2 -n
-d master -Q "exit" -o "C:\DOCUME~1\ADMINI~2.GAR\CONFIG~1\Temp\sqlsp.out"  -E
17:13:10 Process Exit Code: (0)
17:13:10 Begin: CheckSAPassword
17:13:10 Begin: LogOnUsingBlankSA
17:13:10 C:\SQL\SQL2KSP4\x86\BINN\osql.exe  -Slpc:SQLCLUSTEREXP2\BDEXP2 -n
-d master -o "C:\DOCUME~1\ADMINI~2.GAR\CONFIG~1\Temp\sqlsp.out"
-Q"Exit(declare @ret int if (select count(*) from master..syslogins where
name='sa' AND ( (1 = pwd
17:13:11 Process Exit Code: (0)
17:13:11 End: LogOnUsingBlankSA
17:13:11 Begin: SdBlankPwd
17:13:11 End: SdBlankPwd
17:13:11 End: CheckSAPassword
17:13:11 Begin : SdErrorReportingDlg
17:13:12 End: SdErrorReportingDlg
17:13:12 Access authenticated
17:13:12 C:\SQL\SQL2KSP4\x86\BINN\osql.exe  -Slpc:SQLCLUSTEREXP2\BDEXP2 -n
-b -d master -o "C:\DOCUME~1\ADMINI~2.GAR\CONFIG~1\Temp\~sqldb0.txt" -i
"C:\DOCUME~1\ADMINI~2.GAR\CONFIG~1\Temp\SqlSetup\Bin\dbverify.sql" -E
17:13:14 Process Exit Code: (0)
17:13:14 C:\DOCUME~1\ADMINI~2.GAR\CONFIG~1\Temp\SqlSetup\Bin\scm.exe  
-Silent 1 -Action 6 -Service MSSQL$BDEXP2  
17:13:29 Process Exit Code: (0)
17:13:29 Setup Type: Custom (303)
17:13:29 Processing: SQLProg
17:13:29 Processing: SQLProg\SQLServr
17:13:29 Processing: SQLProg\UpgTools
17:13:29 Processing: SQLProg\ReplSupp
17:13:29 Processing: SQLProg\Install
17:13:29 Processing: SQLProg\System
17:13:29 Processing: SQLProg\SvrExt
17:13:29 Processing: SQLProg\Dat
17:13:29 Processing: SQLProg\DatSmpl
17:13:29 Processing: SQLProg\BaseSys
17:13:29 Processing: SQLProg\BaseBinn
17:13:29 Processing: SQLProg\MSSearch
17:13:29 Processing: SQLProg\BaseInst
17:13:29 Processing: SQLProg\UI
17:13:29 Processing: SQLProg\Symbols
17:13:29 Processing: SQLProg\Perfmon
17:13:29 Processing: SQLProg\Root
17:13:29 Processing: SQLProg\EXE
17:13:29 Processing: SQLProg\DLL
17:13:29 Processing: MgtTool
17:13:29 Processing: MgtTool\SEM
17:13:29 Processing: MgtTool\Profiler
17:13:29 Processing: MgtTool\Qryanlz
17:13:29 Processing: MgtTool\DTCCLi
17:13:29 Processing: MgtTool\Wzcnflct
17:13:29 Processing: MgtTool\UtilSys
17:13:29 Processing: MgtTool\UtilBinn
17:13:29 Processing: Connect
17:13:29 Processing: Connect\ConnSys
17:13:29 Processing: Books
17:13:29 Processing: Books\Bookso
17:13:29 Processing: DevTools
17:13:29 Processing: DevTools\Headers and Libraries
17:13:29 Processing: DevTools\MDAC SDKs
17:13:29 Processing: DevTools\VDI
17:13:29 Processing: DevTools\Dbg Int
17:13:29 Processing: Samples
17:13:29 Processing: Samples\ADO
17:13:29 Processing: Samples\DBLIB
17:13:29 Processing: Samples\Desktop
17:13:29 Processing: Samples\DTS
17:13:29 Processing: Samples\ESQLC
17:13:29 Processing: Samples\Misc
17:13:29 Processing: Samples\MSDTC
17:13:29 Processing: Samples\ODBC
17:13:29 Processing: Samples\ODS
17:13:29 Processing: Samples\OLEAut
17:13:29 Processing: Samples\Repl
17:13:29 Processing: Samples\SilverstoneDB
17:13:29 Processing: Samples\SQLDMO
17:13:29 Processing: Samples\SQLNS
17:13:29 Processing: Samples\Utils
17:13:29 Processing: Samples\XML
17:13:29 Processing: CoreRepl
17:13:29 Processing: CoreRepl\Res1033
17:13:29 Processing: CoreRepl\ResIntl
17:13:29 Processing: Core
17:13:29 Processing: Core\Res1033
17:13:29 Processing: Core\ResOther
17:13:29 Processing: Repostry
17:13:29 Processing: Repostry\RepstSys
17:13:29 Processing: Repostry\Res1033
17:13:29 Processing: Repostry\ResIntl
17:13:29 Processing: CoreMisc
17:13:29 Processing: CoreMisc\ActiveX
17:13:29 Processing: CoreMisc\Res1033
17:13:29 Processing: Monarch
17:13:29 Processing: Monarch\Monr1033
17:13:29 Processing: Monarch\MonrIntl
17:13:29 Processing: Jet
17:13:29 Processing: CoreInst
17:13:29 Processing: CoreCOM
17:13:29 Processing: CoreCOM\Res1033
17:13:29 Processing: CoreCOM\ResIntl
17:13:29 Processing: CoreTool
17:13:29 Processing: CoreTool\Res1033
17:13:29 Processing: CoreTool\ResOther
17:13:29 Processing: DBLibCli
17:13:29 Processing: SFExt
17:13:29 Processing: SFExt\ActiveX
17:13:29 Processing: SFExt\Res1033
17:13:29 Processing: SFExt\ResIntl
17:13:29 Processing: Trace
17:13:29 Processing: Trace\Res1033
17:13:29 Processing: Trace\ResOther
17:13:29 Processing: CnctBinn
17:13:29 Processing: MiscCore
17:13:29 Processing: MC
17:13:29 Processing: MC\MC1033
17:13:29 Processing: MC\MCIntl
17:13:29 Processing: MC\Help
17:13:29 Processing: UI
17:13:29 Processing: UI\UIHlp
17:13:29 Processing: UI\UI1033
17:13:29 Processing: UI\UIIntl
17:13:29 Processing: ClstSys
17:13:29 Processing: SQLMgr
17:13:29 Processing: SQLMgr\Res1033
17:13:29 Processing: SQLMgr\ResIntl
17:13:29 Processing: SvrTool
17:13:29 Processing: SvrTool\Res1033
17:13:29 Processing: SvrTool\ResIntl
17:13:29 Processing: DTSUI
17:13:29 Processing: DTSUI\Res1033
17:13:29 Processing: DTSUI\ResIntl
17:13:29 Processing: ClFTSys
17:13:29 Processing: ClFtdata
17:13:29 Processing: MSOlap
17:13:29 Processing: MSOlap\Res1033
17:13:29 Processing: MSOlap\ResIntl
17:13:29 Processing: ATL
17:13:29 Processing: ATL\winnt
17:13:29 Processing: ATL\win9x
17:13:29 Processing: MFC42U
17:13:29 Processing: VC
17:13:29 Processing: VB
17:13:29 Processing: OCX1
17:13:29 Processing: SQLAdHlp
17:13:29 Processing: SQLAdHlp\Res1033
17:13:29 Processing: SQLAdHlp\ResOther
17:13:30 Setup type: Custom
17:13:30 End Action DialogShowSdUpgrade
17:13:30 begin ShowDialogsUpdateMask
17:13:30 nFullMask = 0xb03e607, nCurrent = 0x2000, nDirection = 1
17:13:30 Updated Dialog Mask: 0xb03e003, Disable Back = 0x1
17:13:30 Dialog 0x2000 returned: 1
17:13:30 End Action ShowDialogsHlpr
17:13:30 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14
17:13:30 Begin Action ShowDialogsHlpr: 0x4000
17:13:30 Skipping DialogShowSdVirtualServer
17:13:30 begin ShowDialogsUpdateMask
17:13:30 nFullMask = 0xb03e003, nCurrent = 0x4000, nDirection = 1
17:13:30 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
17:13:30 Dialog 0x4000 returned: 1
17:13:30 End Action ShowDialogsHlpr
17:13:30 ShowDialogsGetDialog returned: nCurrent=0x8000,index=15
17:13:30 Begin Action ShowDialogsHlpr: 0x8000
17:13:30 Begin Action :  DialogShowSdDiskGroups
17:13:30 ShowDlgDiskGroups returned: 1
17:13:30 Disk Group = ClusterSQLBD2
17:13:30 End Action :  DialogShowSdDiskGroups
17:13:30 begin ShowDialogsUpdateMask
17:13:30 nFullMask = 0xb03e607, nCurrent = 0x8000, nDirection = 1
17:13:30 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
17:13:30 Dialog 0x8000 returned: 1
17:13:30 End Action ShowDialogsHlpr
17:13:30 ShowDialogsGetDialog returned: nCurrent=0x10000,index=16
17:13:30 Begin Action ShowDialogsHlpr: 0x10000
17:13:30 Begin Action:  DialogShowSdClusterDef
17:13:30 Before !!  The Prefowner list is : . g_szSpNeededNodelst is : .
g_nNumnodes :0 g_szOwners :, g_szDiskGroup ClusterSQLBD2
17:13:30 ShowDlgClusterDef returned: 1
17:13:30 PrefOwners = GARAJONAY14,GARAJONAY13, NumIp = 2
17:13:30 Begin Action : ValidateNodeActions
17:13:30 Begin Action : EnumerateInstancesForVirtualServer
17:13:30 End Action : EnumerateInstancesForVirtualServer
17:13:30 Begin Action : ValidateNodeActions
17:13:30 End Action : ValidateNodeActions
17:13:30 End Action : ValidateNodeActions
17:13:30 End Action  DialogShowSdClusterDef
17:13:30 begin ShowDialogsUpdateMask
17:13:30 nFullMask = 0xb03e607, nCurrent = 0x10000, nDirection = 1
17:13:30 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
17:13:30 Dialog 0x10000 returned: 1
17:13:30 End Action ShowDialogsHlpr
17:13:30 ShowDialogsGetDialog returned: nCurrent=0x20000,index=17
17:13:30 Begin Action ShowDialogsHlpr: 0x20000
17:13:30 Begin Action : Cluster Security - DlgAcct
17:13:38 ShowDlgAcct returned: 1
17:13:38 [DlgAccount]
17:13:38 Domain = GARAJONAY
17:13:38 DomainAcct = Administrador
17:13:38 Result = 1
17:13:38 End Action : Cluster Security - DlgAcct
17:13:38 begin ShowDialogsUpdateMask
17:13:38 nFullMask = 0xb03e607, nCurrent = 0x20000, nDirection = 1
17:13:38 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
17:13:38 Dialog 0x20000 returned: 1
17:13:38 End Action ShowDialogsHlpr
17:13:38 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
17:13:38 Begin Action ShowDialogsHlpr: 0x1000000
17:13:38 Begin Action:  DlgCollation
17:13:38 ShowDlgCollation returned: 1
17:13:38 collation_name = Modern_Spanish_CI_AS,locale_name =
Modern_Spanish,lcid = 0xc0a,SortId = 0,dwCompFlags = 0x30001
17:13:38 End Action DlgCollation
17:13:38 begin ShowDialogsUpdateMask
17:13:38 nFullMask = 0xb03e607, nCurrent = 0x1000000, nDirection = 1
17:13:38 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
17:13:38 Dialog 0x1000000 returned: 1
17:13:38 End Action ShowDialogsHlpr
17:13:38 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
17:13:38 Begin Action ShowDialogsHlpr: 0x2000000
17:13:38 Begin Action:  DlgNetwork
17:13:38 ShowDlgNetwork returned: 1
17:13:38 [DlgServerNetwork]
17:13:38 NetworkLibs = 255
17:13:38 TCPPort = 0
17:13:38 TCPPrxy = Default
17:13:38 NMPPipeName = \\.\pipe\MSSQL$BDEXP2\sql\query
17:13:38 Result = 1
17:13:38 End Action DlgNetwork
17:13:38 begin ShowDialogsUpdateMask
17:13:38 nFullMask = 0xb03e607, nCurrent = 0x2000000, nDirection = 1
17:13:38 Updated Dialog Mask: 0xb03e607, Disable Back = 0x1
17:13:38 Dialog 0x2000000 returned: 1
17:13:38 End Action ShowDialogsHlpr
17:13:38 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
17:13:38 Begin Action ShowDialogsHlpr: 0x8000000
17:13:38 Begin Action:  DialogShowSdStartCopy
17:13:38 End Action DialogShowSdStartCopy
17:13:38 begin ShowDialogsUpdateMask
17:13:38 nFullMask = 0xb03e607, nCurrent = 0x8000000, nDirection = 1
17:13:38 Updated Dialog Mask: 0x803e607, Disable Back = 0x1
17:13:38 Dialog 0x8000000 returned: 1
17:13:38 End Action ShowDialogsHlpr
17:13:38 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
17:13:38 End: ShowDialogs()
17:13:38 Initializing Event Log
17:13:38 Begin Action : LogEvent
17:13:38 End Action : LogEvent
17:13:38 Begin Action : ClusterSetupHelper
17:13:38 Begin Action : CreateClustISSFiles
17:13:38 End Action : CreateClustISSFiles
17:13:38 Begin Action : ClusterWriteRemIni
17:13:38 End Action : ClusterWriteRemIni
17:13:38 Begin Action : Run setup on cluster nodes
[args]
NumRemoteServers=2
Server.1=GARAJONAY14
Server.2=GARAJONAY13
[Server.1]
NumRemoteServices=1
1.app="\\GARAJONAY14\C$\SQL\SQL2KSP4\x86\setup\setupsql.exe"
1.server=GARAJONAY14
1.script=\\GARAJONAY14\admin$\GARAJONAY14_BDEXP2.iss
1.cmdlineformat=%s k=Nb k=Rm k=Cl -SMS -s -f
"\\GARAJONAY14\C$\SQL\SQL2KSP4\x86\setup\setup.ins" -f1 %s -f2
"\\GARAJONAY14\admin$\setup.log" -e "stpsilnt._ex" -b  -x
"C:\DOCUME~1\ADMINI~2.GAR\CONFIG~1\Temp\"
1.user=GARAJONAY\Administrador
1.name=SQLSetup1
1.sqlsetup=Y
1.copyexe=cnvsvc1.exe
[Server.2]
NumRemoteServices=1
1.app="\\GARAJONAY14\C$\SQL\SQL2KSP4\x86\setup\setupsql.exe"
1.server=GARAJONAY13
1.script=\\GARAJONAY14\admin$\GARAJONAY13_BDEXP2.iss
1.cmdlineformat=%s k=ClSec k=Rm k=Cl -SMS -s -f
"\\GARAJONAY14\C$\SQL\SQL2KSP4\x86\setup\setup.ins" -f1 %s -f2
"\\GARAJONAY13\admin$\setup.log" -e "stpsilnt._ex"  -x "C:\"
1.user=GARAJONAY\Administrador
1.name=SQLSetup2
1.sqlsetup=Y
1.copyexe=cnvsvc2.exe
17:13:38 El programa de instalación está realizando operaciones necesarias
en los nodos de clúster. Esta operación puede durar unos minutos...
17:13:38  "C:\DOCUME~1\ADMINI~2.GAR\CONFIG~1\Temp\SqlSetup\Bin\remsetup.exe"
C:\WINNT\remsetup.ini
17:19:13 Process Exit Code: (-12)
17:19:13 Begin Action : GetRemsetupRetCode
17:19:13 Installation return status on GARAJONAY14 : 0
17:19:13 Installation return status on GARAJONAY13 : -12
17:19:13 End Action : GetRemsetupRetCode
#### Instalación remota de SQL Server: hora de inicio  08/11/05 17:13:38 ####

CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x98] created for execution.
CThread::Process [0x98]
CThreadPool::RunUntilCompleteHlpr create thread, index=1
CThread::Run thread [0xa4] created for execution.
CThread::Process [0xa4]
CThreadPool::RunUntilCompleteHlpr start thread [0x98],index=0
CThreadPool::RunUntilCompleteHlpr start thread [0xa4],index=1
Archivo de comandos copiado en '\\GARAJONAY13\ADMIN$\GARAJONAY13_BDEXP2.iss'.

Instalando servicio remoto (GARAJONAY13)...

CProcess::RunUntilComplete [0x98] exit code: 0
El código de salida del proceso remoto fue '0' (GARAJONAY14).

CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x98]
Thread [0x98] exit code: [0x0]
CRemoteProcess::RunUntilComplete [0xa4] exit code: -12
El código de salida del proceso remoto fue '-12' (GARAJONAY13).

CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0xa4]
Thread [0xa4] exit code: [0xfffffff4]
CThreadPool::RunUntilComplete returned -12
CThreadPool::RunUntilComplete execution level=1, need execution: 0
Se han producido uno o más errores durante la ejecución de los programas de
instalación remotos o desatendidos.

Desconectando del equipo remoto (GARAJONAY14)...

El servicio se quitó correctamente.

No se pudo quitar los archivos remotos.

#### Instalación remota de SQL Server: hora de finalización 08/11/05
17:18:56 ####

Desconectando del equipo remoto (GARAJONAY13)...

El servicio se quitó correctamente.

Los archivos remotos se quitaron correctamente.

#### Instalación remota de SQL Server: hora de finalización 08/11/05
17:19:13 ####
17:19:13 End Action : Run setup on cluster nodes
17:19:13 Se han producido uno o más errores durante la ejecución del
programa de instalación remoto en los equipos agrupados en el clúster.
17:19:16 El programa de instalación no pudo realizar las operaciones
necesarias en los nodos del clúster.
17:19:16 End Action : ClusterSetupHelper
17:19:16 Begin Action : LogEvent
17:19:16 End Action : LogEvent
17:19:16 Begin Action : CloseEventLog
17:19:16 End Action : CloseEventLog
Reply to this Message
Geoff N. Hiten - 16 Aug 2005 14:53 GMT
Something is failing on the remote node.  Can you attach the log file from
that node?

Also, try logging in to the console of each node and settign the TEMP and
TMP folders to something that is not login specific.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

>I have 2 windows 2000 advanced server sp4
>
[quoted text clipped - 479 lines]
> 17:19:16 Begin Action : CloseEventLog
> 17:19:16 End Action : CloseEventLog
Reply to this Message
Admiral - 22 Sep 2005 22:47 GMT
If you have multiple Instances or Virtual Servers on the Clustered
environment, you will have to install SP4 on each instance or Virtual
Server.  I ran into this problem and this seemed to fix it.

Drake Teran

> Something is failing on the remote node.  Can you attach the log file from
> that node?
[quoted text clipped - 491 lines]
>> 17:19:16 Begin Action : CloseEventLog
>> 17:19:16 End Action : CloseEventLog
Reply to this Message
Nik Marshall-Blank - 02 Sep 2005 07:33 GMT
Please read my post  01/09/2005

The problem (I think) is that the backward compatibility warning dialog is
being displayed in a window station which cannot be responded to. I have got
around this by applying sp3 to the sp4 node first and then applying sp4
again.

Full history is in my post 01/09/2005

Signature

Nik Marshall-Blank MCSD/MCDBA

>I have a 2 node windows cluster, and few days ago 1 node died, after
>install
[quoted text clipped - 152 lines]
> on the 2 node all ok.
> Some one know how solution that. Thanks.
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.