Re: Rebuilding the master database on a 2005 Cluster

#1

We are currently at build 3042. I will install build 3050 and the 3175 and
then try rebuilding the master database again. Perhaps it will work with a
later build.

"Loren Z" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi John,

Below is the results from the core log. The most signifcant part is here:

Error: 0x80070050 TaskScheduler::NewWorkItem for SQL Server Remote Setup
Error: 0x80070005 TaskSchedulerWorkItem failed to save the task [SQL
Server Remote Setup ]
Complete: RunRemoteSetupAction at: 2007/11/5 16:7:25, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error
information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Creating new workitem.
Deleting existing work item and trying again...
Starting remote setup on:EITDB06B
Error: 80070005 Access is denied.

It is trying to set up a task scheduler new work item but is getting
Access is denied.

It will probably be easier to reinstall in that I am in the beginning
stages of setting up the server. However, we have had to change collation
settings in the past and I am curious what the resolution would be. The
rest of the log is below:

Microsoft SQL Server 2005 Setup beginning at Wed Dec 05 16:06:50 2007
Process ID : 7884
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe
Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/11/5 16:6:50
Complete: LoadResourcesAction at: 2007/11/5 16:6:50, returned true
Running: ParseBootstrapOptionsAction at: 2007/11/5 16:6:50
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/11/5 16:6:50, returned true
Running: ValidateWinNTAction at: 2007/11/5 16:6:50
Complete: ValidateWinNTAction at: 2007/11/5 16:6:50, returned true
Running: ValidateMinOSAction at: 2007/11/5 16:6:50
Complete: ValidateMinOSAction at: 2007/11/5 16:6:50, returned true
Running: PerformSCCAction at: 2007/11/5 16:6:50
Complete: PerformSCCAction at: 2007/11/5 16:6:50, returned true
Running: ActivateLoggingAction at: 2007/11/5 16:6:50
Complete: ActivateLoggingAction at: 2007/11/5 16:6:50, returned true
Running: DetectPatchedBootstrapAction at: 2007/11/5 16:6:50
Complete: DetectPatchedBootstrapAction at: 2007/11/5 16:6:50, returned
true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following
restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__7884" returned
false.
Running: PerformSCCAction2 at: 2007/11/5 16:6:50
Complete: PerformSCCAction2 at: 2007/11/5 16:6:50, returned true
Running: PerformDotNetCheck at: 2007/11/5 16:6:50
Complete: PerformDotNetCheck at: 2007/11/5 16:6:50, returned true
Running: ComponentUpdateAction at: 2007/11/5 16:6:50
Complete: ComponentUpdateAction at: 2007/11/5 16:6:51, returned true
Running: DetectLocalBootstrapAction at: 2007/11/5 16:6:51
Complete: DetectLocalBootstrapAction at: 2007/11/5 16:6:51, returned true
Action "LaunchLocalBootstrapAction" will be skipped due to the following
restrictions:
Condition "EventCondition: __STP_LaunchLocalBootstrap__7884" returned
false.
Running: PerformDotNetCheck2 at: 2007/11/5 16:6:51
Complete: PerformDotNetCheck2 at: 2007/11/5 16:6:51, returned true
Running: InvokeSqlSetupDllAction at: 2007/11/5 16:6:51
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlspars.dll Version:2005.90.3042.0
Func Name='DwLaunchMsiExec'
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [SERVER_A]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
Instance Name = MSSQLSERVER
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Machine = SERVER_A, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = WMIServiceWin32CompSystemWorking, Result = 0
(0x0)
Machine = SERVER_A, Article = WMIServiceWin32ProcessorWorking, Result = 0
(0x0)
Machine = SERVER_A, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = WMIServiceWin32DirectoryWorking, Result = 0
(0x0)
Machine = SERVER_A, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = XMLDomDocument, Result = 0 (0x0)
Machine = SERVER_A, Article = Processor, Result = 0 (0x0)
Machine = SERVER_A, Article = PhysicalMemory, Result = 0 (0x0)
Machine = SERVER_A, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = SERVER_A, Article = OSVersion, Result = 0 (0x0)
Machine = SERVER_A, Article = OSServicePack, Result = 0 (0x0)
Machine = SERVER_A, Article = OSType, Result = 0 (0x0)
Machine = SERVER_A, Article = iisDep, Result = 0 (0x0)
Machine = SERVER_A, Article = AdminShare, Result = 0 (0x0)
Machine = SERVER_A, Article = PendingReboot, Result = 0 (0x0)
Machine = SERVER_A, Article = PerfMon, Result = 0 (0x0)
Machine = SERVER_A, Article = IEVersion, Result = 0 (0x0)
Machine = SERVER_A, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = SERVER_A, Article = COMPlus, Result = 0 (0x0)
Machine = SERVER_A, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = SERVER_A, Article = MDAC25Version, Result = 0 (0x0)
Machine = SERVER_A, Article = SKUUpgrade, Result = 70391 (0x112f7)
*******************************************
Setup Consistency Check Report for Machine: SERVER_A
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result:
CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result:
CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: Warning
Description: There can be a product on higher SP level. Action: If you are
attempting to upgrade an existing instance of Microsoft SQL Server to
another Edition by installing the RTM version of the new Edition, you need
to pass "SKUUPGRADE=1" to setup.exe on the command line.
Func Name='PerformDetections'
0
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlsval.dll Version:2005.90.3042.0
EndFunc Name='PerformDetections' Return='0' GetLastError='997'
Machine = SERVER_A, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = WMIServiceWin32CompSystemWorking, Result = 0
(0x0)
Machine = SERVER_A, Article = WMIServiceWin32ProcessorWorking, Result = 0
(0x0)
Machine = SERVER_A, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = WMIServiceWin32DirectoryWorking, Result = 0
(0x0)
Machine = SERVER_A, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = XMLDomDocument, Result = 0 (0x0)
Machine = SERVER_B, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = SERVER_B, Article = WMIServiceWin32CompSystemWorking, Result = 0
(0x0)
Machine = SERVER_B, Article = WMIServiceWin32ProcessorWorking, Result = 0
(0x0)
Machine = SERVER_B, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = SERVER_B, Article = WMIServiceWin32DirectoryWorking, Result = 0
(0x0)
Machine = SERVER_B, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = SERVER_B, Article = XMLDomDocument, Result = 0 (0x0)
Machine = SERVER_A, Article = Processor, Result = 0 (0x0)
Machine = SERVER_A, Article = PhysicalMemory, Result = 0 (0x0)
Machine = SERVER_A, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = SERVER_B, Article = Processor, Result = 0 (0x0)
Machine = SERVER_B, Article = PhysicalMemory, Result = 0 (0x0)
Machine = SERVER_B, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = SERVER_A, Article = OSVersion, Result = 0 (0x0)
Machine = SERVER_A, Article = OSServicePack, Result = 0 (0x0)
Machine = SERVER_A, Article = OSType, Result = 0 (0x0)
Machine = SERVER_A, Article = iisDep, Result = 0 (0x0)
Machine = SERVER_A, Article = AdminShare, Result = 0 (0x0)
Machine = SERVER_A, Article = PendingReboot, Result = 0 (0x0)
Machine = SERVER_A, Article = PerfMon, Result = 0 (0x0)
Machine = SERVER_A, Article = IEVersion, Result = 0 (0x0)
Machine = SERVER_A, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = SERVER_A, Article = COMPlus, Result = 0 (0x0)
Machine = SERVER_A, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = SERVER_A, Article = MDAC25Version, Result = 0 (0x0)
Machine = SERVER_A, Article = SKUUpgrade, Result = 70391 (0x112f7)
Machine = SERVER_B, Article = OSVersion, Result = 0 (0x0)
Machine = SERVER_B, Article = OSServicePack, Result = 0 (0x0)
Machine = SERVER_B, Article = OSType, Result = 0 (0x0)
Machine = SERVER_B, Article = iisDep, Result = 0 (0x0)
Machine = SERVER_B, Article = AdminShare, Result = 0 (0x0)
Machine = SERVER_B, Article = PendingReboot, Result = 0 (0x0)
Machine = SERVER_B, Article = PerfMon, Result = 0 (0x0)
Machine = SERVER_B, Article = IEVersion, Result = 0 (0x0)
Machine = SERVER_B, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = SERVER_B, Article = COMPlus, Result = 0 (0x0)
Machine = SERVER_B, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = SERVER_B, Article = MDAC25Version, Result = 0 (0x0)
Machine = SERVER_B, Article = SKUUpgrade, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: SERVER_A
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result:
CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result:
CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: Warning
Description: There can be a product on higher SP level. Action: If you are
attempting to upgrade an existing instance of Microsoft SQL Server to
another Edition by installing the RTM version of the new Edition, you need
to pass "SKUUPGRADE=1" to setup.exe on the command line.
*******************************************
Setup Consistency Check Report for Machine: SERVER_B
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result:
CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Administrative Shares Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result:
CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: CheckPassed
The CheckSCCResult returned for cluster install is 0
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlsval.dll Version:2005.90.3042.0
EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'
Complete: InvokeSqlSetupDllAction at: 2007/11/5 16:7:23, returned true
Running: SetPackageInstallStateAction at: 2007/11/5 16:7:23
1: SQL_Engine = 3
1: SQL_Data_Files = 3
1: SQL_Replication = 2
1: SQL_FullText = 3
1: SQL_SharedTools = 3
1: SQL_BC_DEP = 3
2: Analysis_Server = 2
2: AnalysisDataFiles = 2
2: AnalysisSharedTools = 2
3: RS_Server = 2
3: RS_Web_Interface = 2
3: RS_SharedTools = 2
4: Notification_Services = 2
4: NS_Engine = 2
4: NS_Client = 2
5: SQL_DTS = 2
6: Client_Components = 2
6: TOOLS_BC_DEP = 2
6: Connectivity = 2
6: Tools_Legacy = 2
6: SQL_Tools90 = 2
6: SQL_WarehouseDevWorkbench = 2
6: SDK = 2
6: SQLXML = 2
6: SQL_BooksOnline = 2
6: SQL_Documentation = 2
6: SQL_Samples = 2
6: SQL_DatabaseSamples = 2
6: SQL_AdventureWorksSamples = 2
6: SQL_AdventureWorksDWSamples = 2
6: SQL_AdventureWorksASSamples = 2
6: SQL_SSMSEE = 2
1: SQL_Replication = 2
2: Analysis_Server = 2
2: AnalysisDataFiles = 2
2: AnalysisSharedTools = 2
3: RS_Server = 2
3: RS_Web_Interface = 2
3: RS_SharedTools = 2
4: Notification_Services = 2
4: NS_Engine = 2
4: NS_Client = 2
5: SQL_DTS = 3
6: Client_Components = 2
6: TOOLS_BC_DEP = 2
6: Connectivity = 2
6: Tools_Legacy = 2
6: SQL_Tools90 = 2
6: SQL_WarehouseDevWorkbench = 2
6: SDK = 2
6: SQLXML = 2
6: SQL_BooksOnline = 2
6: SQL_Documentation = 2
6: SQL_Samples = 2
6: SQL_DatabaseSamples = 2
6: SQL_AdventureWorksSamples = 2
6: SQL_AdventureWorksDWSamples = 2
6: SQL_AdventureWorksASSamples = 2
6: SQL_SSMSEE = 2
1: SQL_Replication = 2
2: Analysis_Server = 2
2: AnalysisDataFiles = 2
2: AnalysisSharedTools = 2
3: RS_Server = 2
3: RS_Web_Interface = 2
3: RS_SharedTools = 2
4: Notification_Services = 3
4: NS_Engine = 3
4: NS_Client = 3
6: Client_Components = 2
6: TOOLS_BC_DEP = 2
6: Connectivity = 2
6: Tools_Legacy = 2
6: SQL_Tools90 = 2
6: SQL_WarehouseDevWorkbench = 2
6: SDK = 2
6: SQLXML = 2
6: SQL_BooksOnline = 2
6: SQL_Documentation = 2
6: SQL_Samples = 2
6: SQL_DatabaseSamples = 2
6: SQL_AdventureWorksSamples = 2
6: SQL_AdventureWorksDWSamples = 2
6: SQL_AdventureWorksASSamples = 2
6: SQL_SSMSEE = 2
1: SQL_Replication = 2
2: Analysis_Server = 2
2: AnalysisDataFiles = 2
2: AnalysisSharedTools = 2
3: RS_Server = 2
3: RS_Web_Interface = 2
3: RS_SharedTools = 2
6: Client_Components = 3
6: TOOLS_BC_DEP = 3
6: Connectivity = 3
6: Tools_Legacy = 2
6: SQL_Tools90 = 3
6: SQL_WarehouseDevWorkbench = 3
6: SDK = 3
6: SQLXML = 3
6: SQL_BooksOnline = 2
6: SQL_Documentation = 3
6: SQL_Samples = 2
6: SQL_DatabaseSamples = 2
6: SQL_AdventureWorksSamples = 2
6: SQL_AdventureWorksDWSamples = 2
6: SQL_AdventureWorksASSamples = 2
6: SQL_SSMSEE = 2
Complete: SetPackageInstallStateAction at: 2007/11/5 16:7:24, returned
true
Running: DeterminePackageTransformsAction at: 2007/11/5 16:7:24
Complete: DeterminePackageTransformsAction at: 2007/11/5 16:7:25, returned
true
Running: ValidateSetupPropertiesAction at: 2007/11/5 16:7:25
Complete: ValidateSetupPropertiesAction at: 2007/11/5 16:7:25, returned
true
Running: OpenPipeAction at: 2007/11/5 16:7:25
Complete: OpenPipeAction at: 2007/11/5 16:7:25, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2007/11/5 16:7:25
Complete: CreatePipeAction at: 2007/11/5 16:7:25, returned true
Running: RunRemoteSetupAction at: 2007/11/5 16:7:25
Func Name='CProcessCtrl::GetInstallPath'
EndFunc Name='CProcessCtrl::GetInstallPath' Return='0'
GetLastError='997'
Error: 0x80070050 TaskScheduler::NewWorkItem for SQL Server Remote Setup
Error: 0x80070005 TaskSchedulerWorkItem failed to save the task [SQL
Server Remote Setup ]
Complete: RunRemoteSetupAction at: 2007/11/5 16:7:25, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error
information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Creating new workitem.
Deleting existing work item and trying again...
Starting remote setup on:SERVER_B
Error: 80070005 Access is denied.
Running: PopulateMutatorDbAction at: 2007/11/5 16:7:25
Complete: PopulateMutatorDbAction at: 2007/11/5 16:7:25, returned true
Running: GenerateRequestsAction at: 2007/11/5 16:7:25
SQL_Engine = 3
SQL_Data_Files = -1
SQL_Replication = -1
SQL_FullText = -1
SQL_SharedTools = -1
SQL_BC_DEP = -1
Analysis_Server = -1
AnalysisDataFiles = -1
AnalysisSharedTools = -1
RS_Server = -1
RS_Web_Interface = -1
RS_SharedTools = -1
Notification_Services = -1
NS_Engine = -1
NS_Client = -1
SQL_DTS = -1
Client_Components = -1
Connectivity = -1
SQL_Tools90 = -1
SQL_WarehouseDevWorkbench = -1
SDK = -1
SQLXML = -1
Tools_Legacy = -1
TOOLS_BC_DEP = -1
SQL_SSMSEE = -1
SQL_Documentation = -1
SQL_BooksOnline = -1
SQL_DatabaseSamples = -1
SQL_AdventureWorksSamples = -1
SQL_AdventureWorksDWSamples = -1
SQL_AdventureWorksASSamples = -1
SQL_Samples = -1
Complete: GenerateRequestsAction at: 2007/11/5 16:7:27, returned true
Running: CreateProgressWindowAction at: 2007/11/5 16:7:27
Complete: CreateProgressWindowAction at: 2007/11/5 16:7:27, returned false
Error: Action "CreateProgressWindowAction" failed during execution.
Running: ScheduleActionAction at: 2007/11/5 16:7:27
Complete: ScheduleActionAction at: 2007/11/5 16:7:27, returned true
Skipped: InstallASAction.11
Waiting for actions from remote setup(s)
Breaking wait state and aborting package due to cancel code received: 1602
Remote setup(s) are ready
Notify package action is determined: 1602
Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe. Source
File Name: remotemessagelib\overlappedpipelistener.cpp
Compiler Timestamp: Sat Oct 7 09:43:54 2006
Function Name: sqls::OverlappedPipeListener::writePipe
Source Line Number: 294

Notification failed to send.
---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::installActio n

Removing machine from list of targets to sync.
Skipped: Action "InstallASAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "as", will not be installed.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "as", will not be installed.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "as", will not be installed.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "msxml6", referred by
package: "as", will not be installed.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "dts", will not be
installed.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "dts", will not be installed.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlncli", referred by
package: "dts", will not be installed.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "dts", will not be installed.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "dts", will not be installed.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "msxml6", referred by
package: "dts", will not be installed.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "ns", will not be installed.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "ns", will not be installed.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlncli", referred by
package: "ns", will not be installed.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "ns", will not be installed.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "ns", will not be installed.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "msxml6", referred by
package: "ns", will not be installed.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "rs", will not be installed.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "rs", will not be installed.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "rs", will not be installed.
Skipped: InstallSqlAction
Clustered feature detected: SQL_Engine
Clustered feature detected: SQL_FullText
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlsval.dll Version:2005.90.3042.0
Skipped: Action "InstallSqlAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sql", will not be
installed.
Skipped: InstallSqlAction.11
Skipped: Action "InstallSqlAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "sql", will not be installed.
Skipped: InstallSqlAction.12
Skipped: Action "InstallSqlAction.12" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlncli", referred by
package: "sql", will not be installed.
Skipped: InstallSqlAction.18
Skipped: Action "InstallSqlAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "sql", will not be installed.
Skipped: InstallSqlAction.21
Skipped: Action "InstallSqlAction.21" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlwriter", referred by
package: "sql", will not be installed.
Skipped: InstallSqlAction.22
Skipped: Action "InstallSqlAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "sql", will not be installed.
Skipped: InstallSqlAction.9
Skipped: Action "InstallSqlAction.9" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "msxml6", referred by
package: "sql", will not be installed.
Skipped: InstallToolsAction.11
Skipped: Action "InstallToolsAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.12
Skipped: Action "InstallToolsAction.12" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlncli", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "PPESku", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.18
Skipped: Action "InstallToolsAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.20
Skipped: Action "InstallToolsAction.20" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "BOL", referred by package:
"tools", will not be installed.
Skipped: InstallToolsAction.22
Skipped: Action "InstallToolsAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.23
Skipped: Action "InstallToolsAction.23" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "ssmsee", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.9
Skipped: Action "InstallToolsAction.9" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "msxml6", referred by
package: "tools", will not be installed.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "as", will not be installed.
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlxml4", referred by
package: "ns", will not be installed.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "rs", will not be installed.
Skipped: InstallToolsAction
Skipped: Action "InstallToolsAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "tools", will not be
installed.
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlxml4", referred by
package: "tools", will not be installed.
Error: Action "RepairForBackwardsCompatRedistAction" failed during
execution. Error information reported during run:
Action: "RepairForBackwardsCompatRedistAction" will be marked as failed
due to the following condition:
Condition "Package "22" either passed when it was last installed, or it
has not been executed yet" returned false. Condition context:
Prereq package will be failed due to the previous installation attempt
returning: 1602
Installation of package: "bcRedist" failed due to a precondition.
Skipped: UninstallForMSDE2000Action
Skipped: Action "UninstallForMSDE2000Action" was not run. Information
reported during analysis:
Action: "UninstallForMSDE2000Action" will be skipped due to the following
condition:
Condition "Action: InstallSqlAction was skipped." returned true.
Skipped: UninstallForSQLAction
Skipped: Action "UninstallForSQLAction" was not run. Information reported
during analysis:
Action: "UninstallForSQLAction" will be skipped due to the following
condition:
Condition "Action: InstallSqlAction was skipped." returned true.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information
reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following
condition:
Condition "Action: InstallRSAction was skipped." returned true.
Error: Action "ExposeVistaClusteredResources" failed during execution.
Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to
the following condition:
Condition "The Clustered SQL Server instance that hosts is installed."
returned false. Condition context:
Action will be skipped due to sql failing to install.
Running: ReportChainingResults at: 2007/11/5 16:7:30
Error: Action "ReportChainingResults" threw an exception during execution.
Setting exit code to ERROR_INSTALL_USEREXIT, : 1602
Error Code: 0x80070642 (1602)
Windows Error Text: User cancelled installation. Source File Name:
sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:32:00 2006
Function Name: sqls::ReportChainingResults:

erform
Source Line Number: 3667

"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote in message
news:79DFD7CE-1EDB-4512-8251-A3E236248063 (AT) microsoft (DOT) com...
Hi

What does it say in the log files? See
http://msdn2.microsoft.com/en-us/library/ms143702.aspx

You may want to use /qn instead of /qb to suppress the dialogs.

Quite often it is quicker and more reliable to reinstall!

John

"Loren Z" wrote:

I am trying to rebuild the master database of a SQL Server 2005 bit
clustered install. This is primarily to change the collation settings. I
have been running the command:

start /wait <CD or DVD Drive>\setup.exe /qb VS=<VSName
INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1
ADMINPASSWORD=<StrongPassword> SAPWD=<NewStrongPassword
SQLCOLLATION=<NewSystemCollation> SQLACCOUNT=<domain\user
SQLPASSWORD=<DomainUserPassword> AGTACCOUNT=<domain\user
AGTPASSWORD=<DomainUserPassword> SKUUPGRADE=1

In the setup progress window and under "SQL Server Database Services"
the
status changes to "The installation was cancelled by the user" and the
setup
terminates.

I added "SKUUPGRADE=1" in that the version is SP2 but with or without it
the
results are the same.

What is wrong with what I am doing and what is the proper method of
rebuilding the master database to change collation settings under a
clustered install of SQL Server 2005 64-bit?

Do I have to uninstall and then reinstall?

#2

This problem has been solved.

Under ADMINPASSWORD I was entering the SA password for SQL Server. An
adminstrator password on the server is what is required. Once I used the
latter, I was able to rebuild the system databases.

"Loren Z" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

We are currently at build 3042. I will install build 3050 and the 3175 and
then try rebuilding the master database again. Perhaps it will work with a
later build.

"Loren Z" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message
news:OkyJ%23tBOIHA.5524 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
Hi John,

Below is the results from the core log. The most signifcant part is here:

Error: 0x80070050 TaskScheduler::NewWorkItem for SQL Server Remote Setup
Error: 0x80070005 TaskSchedulerWorkItem failed to save the task [SQL
Server Remote Setup ]
Complete: RunRemoteSetupAction at: 2007/11/5 16:7:25, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error
information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Creating new workitem.
Deleting existing work item and trying again...
Starting remote setup on:EITDB06B
Error: 80070005 Access is denied.

It is trying to set up a task scheduler new work item but is getting
Access is denied.

It will probably be easier to reinstall in that I am in the beginning
stages of setting up the server. However, we have had to change collation
settings in the past and I am curious what the resolution would be. The
rest of the log is below:

Microsoft SQL Server 2005 Setup beginning at Wed Dec 05 16:06:50 2007
Process ID : 7884
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe
Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/11/5 16:6:50
Complete: LoadResourcesAction at: 2007/11/5 16:6:50, returned true
Running: ParseBootstrapOptionsAction at: 2007/11/5 16:6:50
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/11/5 16:6:50, returned
true
Running: ValidateWinNTAction at: 2007/11/5 16:6:50
Complete: ValidateWinNTAction at: 2007/11/5 16:6:50, returned true
Running: ValidateMinOSAction at: 2007/11/5 16:6:50
Complete: ValidateMinOSAction at: 2007/11/5 16:6:50, returned true
Running: PerformSCCAction at: 2007/11/5 16:6:50
Complete: PerformSCCAction at: 2007/11/5 16:6:50, returned true
Running: ActivateLoggingAction at: 2007/11/5 16:6:50
Complete: ActivateLoggingAction at: 2007/11/5 16:6:50, returned true
Running: DetectPatchedBootstrapAction at: 2007/11/5 16:6:50
Complete: DetectPatchedBootstrapAction at: 2007/11/5 16:6:50, returned
true
Action "LaunchPatchedBootstrapAction" will be skipped due to the
following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__7884" returned
false.
Running: PerformSCCAction2 at: 2007/11/5 16:6:50
Complete: PerformSCCAction2 at: 2007/11/5 16:6:50, returned true
Running: PerformDotNetCheck at: 2007/11/5 16:6:50
Complete: PerformDotNetCheck at: 2007/11/5 16:6:50, returned true
Running: ComponentUpdateAction at: 2007/11/5 16:6:50
Complete: ComponentUpdateAction at: 2007/11/5 16:6:51, returned true
Running: DetectLocalBootstrapAction at: 2007/11/5 16:6:51
Complete: DetectLocalBootstrapAction at: 2007/11/5 16:6:51, returned true
Action "LaunchLocalBootstrapAction" will be skipped due to the following
restrictions:
Condition "EventCondition: __STP_LaunchLocalBootstrap__7884" returned
false.
Running: PerformDotNetCheck2 at: 2007/11/5 16:6:51
Complete: PerformDotNetCheck2 at: 2007/11/5 16:6:51, returned true
Running: InvokeSqlSetupDllAction at: 2007/11/5 16:6:51
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlspars.dll Version:2005.90.3042.0
Func Name='DwLaunchMsiExec'
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [SERVER_A]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
Instance Name = MSSQLSERVER
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Machine = SERVER_A, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = WMIServiceWin32CompSystemWorking, Result =
0 (0x0)
Machine = SERVER_A, Article = WMIServiceWin32ProcessorWorking, Result = 0
(0x0)
Machine = SERVER_A, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = WMIServiceWin32DirectoryWorking, Result = 0
(0x0)
Machine = SERVER_A, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = XMLDomDocument, Result = 0 (0x0)
Machine = SERVER_A, Article = Processor, Result = 0 (0x0)
Machine = SERVER_A, Article = PhysicalMemory, Result = 0 (0x0)
Machine = SERVER_A, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = SERVER_A, Article = OSVersion, Result = 0 (0x0)
Machine = SERVER_A, Article = OSServicePack, Result = 0 (0x0)
Machine = SERVER_A, Article = OSType, Result = 0 (0x0)
Machine = SERVER_A, Article = iisDep, Result = 0 (0x0)
Machine = SERVER_A, Article = AdminShare, Result = 0 (0x0)
Machine = SERVER_A, Article = PendingReboot, Result = 0 (0x0)
Machine = SERVER_A, Article = PerfMon, Result = 0 (0x0)
Machine = SERVER_A, Article = IEVersion, Result = 0 (0x0)
Machine = SERVER_A, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = SERVER_A, Article = COMPlus, Result = 0 (0x0)
Machine = SERVER_A, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = SERVER_A, Article = MDAC25Version, Result = 0 (0x0)
Machine = SERVER_A, Article = SKUUpgrade, Result = 70391 (0x112f7)
*******************************************
Setup Consistency Check Report for Machine: SERVER_A
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result:
CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result:
CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: Warning
Description: There can be a product on higher SP level. Action: If you
are attempting to upgrade an existing instance of Microsoft SQL Server to
another Edition by installing the RTM version of the new Edition, you
need to pass "SKUUPGRADE=1" to setup.exe on the command line.
Func Name='PerformDetections'
0
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlsval.dll Version:2005.90.3042.0
EndFunc Name='PerformDetections' Return='0' GetLastError='997'
Machine = SERVER_A, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = WMIServiceWin32CompSystemWorking, Result =
0 (0x0)
Machine = SERVER_A, Article = WMIServiceWin32ProcessorWorking, Result = 0
(0x0)
Machine = SERVER_A, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = WMIServiceWin32DirectoryWorking, Result = 0
(0x0)
Machine = SERVER_A, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = SERVER_A, Article = XMLDomDocument, Result = 0 (0x0)
Machine = SERVER_B, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = SERVER_B, Article = WMIServiceWin32CompSystemWorking, Result =
0 (0x0)
Machine = SERVER_B, Article = WMIServiceWin32ProcessorWorking, Result = 0
(0x0)
Machine = SERVER_B, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = SERVER_B, Article = WMIServiceWin32DirectoryWorking, Result = 0
(0x0)
Machine = SERVER_B, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = SERVER_B, Article = XMLDomDocument, Result = 0 (0x0)
Machine = SERVER_A, Article = Processor, Result = 0 (0x0)
Machine = SERVER_A, Article = PhysicalMemory, Result = 0 (0x0)
Machine = SERVER_A, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = SERVER_B, Article = Processor, Result = 0 (0x0)
Machine = SERVER_B, Article = PhysicalMemory, Result = 0 (0x0)
Machine = SERVER_B, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = SERVER_A, Article = OSVersion, Result = 0 (0x0)
Machine = SERVER_A, Article = OSServicePack, Result = 0 (0x0)
Machine = SERVER_A, Article = OSType, Result = 0 (0x0)
Machine = SERVER_A, Article = iisDep, Result = 0 (0x0)
Machine = SERVER_A, Article = AdminShare, Result = 0 (0x0)
Machine = SERVER_A, Article = PendingReboot, Result = 0 (0x0)
Machine = SERVER_A, Article = PerfMon, Result = 0 (0x0)
Machine = SERVER_A, Article = IEVersion, Result = 0 (0x0)
Machine = SERVER_A, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = SERVER_A, Article = COMPlus, Result = 0 (0x0)
Machine = SERVER_A, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = SERVER_A, Article = MDAC25Version, Result = 0 (0x0)
Machine = SERVER_A, Article = SKUUpgrade, Result = 70391 (0x112f7)
Machine = SERVER_B, Article = OSVersion, Result = 0 (0x0)
Machine = SERVER_B, Article = OSServicePack, Result = 0 (0x0)
Machine = SERVER_B, Article = OSType, Result = 0 (0x0)
Machine = SERVER_B, Article = iisDep, Result = 0 (0x0)
Machine = SERVER_B, Article = AdminShare, Result = 0 (0x0)
Machine = SERVER_B, Article = PendingReboot, Result = 0 (0x0)
Machine = SERVER_B, Article = PerfMon, Result = 0 (0x0)
Machine = SERVER_B, Article = IEVersion, Result = 0 (0x0)
Machine = SERVER_B, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = SERVER_B, Article = COMPlus, Result = 0 (0x0)
Machine = SERVER_B, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = SERVER_B, Article = MDAC25Version, Result = 0 (0x0)
Machine = SERVER_B, Article = SKUUpgrade, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: SERVER_A
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result:
CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result:
CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: Warning
Description: There can be a product on higher SP level. Action: If you
are attempting to upgrade an existing instance of Microsoft SQL Server to
another Edition by installing the RTM version of the new Edition, you
need to pass "SKUUPGRADE=1" to setup.exe on the command line.
*******************************************
Setup Consistency Check Report for Machine: SERVER_B
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result:
CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: CheckPassed
Article: Administrative Shares Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result:
CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
Article: Edition Upgrade Check, Result: CheckPassed
The CheckSCCResult returned for cluster install is 0
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlsval.dll Version:2005.90.3042.0
EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'
Complete: InvokeSqlSetupDllAction at: 2007/11/5 16:7:23, returned true
Running: SetPackageInstallStateAction at: 2007/11/5 16:7:23
1: SQL_Engine = 3
1: SQL_Data_Files = 3
1: SQL_Replication = 2
1: SQL_FullText = 3
1: SQL_SharedTools = 3
1: SQL_BC_DEP = 3
2: Analysis_Server = 2
2: AnalysisDataFiles = 2
2: AnalysisSharedTools = 2
3: RS_Server = 2
3: RS_Web_Interface = 2
3: RS_SharedTools = 2
4: Notification_Services = 2
4: NS_Engine = 2
4: NS_Client = 2
5: SQL_DTS = 2
6: Client_Components = 2
6: TOOLS_BC_DEP = 2
6: Connectivity = 2
6: Tools_Legacy = 2
6: SQL_Tools90 = 2
6: SQL_WarehouseDevWorkbench = 2
6: SDK = 2
6: SQLXML = 2
6: SQL_BooksOnline = 2
6: SQL_Documentation = 2
6: SQL_Samples = 2
6: SQL_DatabaseSamples = 2
6: SQL_AdventureWorksSamples = 2
6: SQL_AdventureWorksDWSamples = 2
6: SQL_AdventureWorksASSamples = 2
6: SQL_SSMSEE = 2
1: SQL_Replication = 2
2: Analysis_Server = 2
2: AnalysisDataFiles = 2
2: AnalysisSharedTools = 2
3: RS_Server = 2
3: RS_Web_Interface = 2
3: RS_SharedTools = 2
4: Notification_Services = 2
4: NS_Engine = 2
4: NS_Client = 2
5: SQL_DTS = 3
6: Client_Components = 2
6: TOOLS_BC_DEP = 2
6: Connectivity = 2
6: Tools_Legacy = 2
6: SQL_Tools90 = 2
6: SQL_WarehouseDevWorkbench = 2
6: SDK = 2
6: SQLXML = 2
6: SQL_BooksOnline = 2
6: SQL_Documentation = 2
6: SQL_Samples = 2
6: SQL_DatabaseSamples = 2
6: SQL_AdventureWorksSamples = 2
6: SQL_AdventureWorksDWSamples = 2
6: SQL_AdventureWorksASSamples = 2
6: SQL_SSMSEE = 2
1: SQL_Replication = 2
2: Analysis_Server = 2
2: AnalysisDataFiles = 2
2: AnalysisSharedTools = 2
3: RS_Server = 2
3: RS_Web_Interface = 2
3: RS_SharedTools = 2
4: Notification_Services = 3
4: NS_Engine = 3
4: NS_Client = 3
6: Client_Components = 2
6: TOOLS_BC_DEP = 2
6: Connectivity = 2
6: Tools_Legacy = 2
6: SQL_Tools90 = 2
6: SQL_WarehouseDevWorkbench = 2
6: SDK = 2
6: SQLXML = 2
6: SQL_BooksOnline = 2
6: SQL_Documentation = 2
6: SQL_Samples = 2
6: SQL_DatabaseSamples = 2
6: SQL_AdventureWorksSamples = 2
6: SQL_AdventureWorksDWSamples = 2
6: SQL_AdventureWorksASSamples = 2
6: SQL_SSMSEE = 2
1: SQL_Replication = 2
2: Analysis_Server = 2
2: AnalysisDataFiles = 2
2: AnalysisSharedTools = 2
3: RS_Server = 2
3: RS_Web_Interface = 2
3: RS_SharedTools = 2
6: Client_Components = 3
6: TOOLS_BC_DEP = 3
6: Connectivity = 3
6: Tools_Legacy = 2
6: SQL_Tools90 = 3
6: SQL_WarehouseDevWorkbench = 3
6: SDK = 3
6: SQLXML = 3
6: SQL_BooksOnline = 2
6: SQL_Documentation = 3
6: SQL_Samples = 2
6: SQL_DatabaseSamples = 2
6: SQL_AdventureWorksSamples = 2
6: SQL_AdventureWorksDWSamples = 2
6: SQL_AdventureWorksASSamples = 2
6: SQL_SSMSEE = 2
Complete: SetPackageInstallStateAction at: 2007/11/5 16:7:24, returned
true
Running: DeterminePackageTransformsAction at: 2007/11/5 16:7:24
Complete: DeterminePackageTransformsAction at: 2007/11/5 16:7:25,
returned true
Running: ValidateSetupPropertiesAction at: 2007/11/5 16:7:25
Complete: ValidateSetupPropertiesAction at: 2007/11/5 16:7:25, returned
true
Running: OpenPipeAction at: 2007/11/5 16:7:25
Complete: OpenPipeAction at: 2007/11/5 16:7:25, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2007/11/5 16:7:25
Complete: CreatePipeAction at: 2007/11/5 16:7:25, returned true
Running: RunRemoteSetupAction at: 2007/11/5 16:7:25
Func Name='CProcessCtrl::GetInstallPath'
EndFunc Name='CProcessCtrl::GetInstallPath' Return='0'
GetLastError='997'
Error: 0x80070050 TaskScheduler::NewWorkItem for SQL Server Remote Setup
Error: 0x80070005 TaskSchedulerWorkItem failed to save the task [SQL
Server Remote Setup ]
Complete: RunRemoteSetupAction at: 2007/11/5 16:7:25, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error
information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Creating new workitem.
Deleting existing work item and trying again...
Starting remote setup on:SERVER_B
Error: 80070005 Access is denied.
Running: PopulateMutatorDbAction at: 2007/11/5 16:7:25
Complete: PopulateMutatorDbAction at: 2007/11/5 16:7:25, returned true
Running: GenerateRequestsAction at: 2007/11/5 16:7:25
SQL_Engine = 3
SQL_Data_Files = -1
SQL_Replication = -1
SQL_FullText = -1
SQL_SharedTools = -1
SQL_BC_DEP = -1
Analysis_Server = -1
AnalysisDataFiles = -1
AnalysisSharedTools = -1
RS_Server = -1
RS_Web_Interface = -1
RS_SharedTools = -1
Notification_Services = -1
NS_Engine = -1
NS_Client = -1
SQL_DTS = -1
Client_Components = -1
Connectivity = -1
SQL_Tools90 = -1
SQL_WarehouseDevWorkbench = -1
SDK = -1
SQLXML = -1
Tools_Legacy = -1
TOOLS_BC_DEP = -1
SQL_SSMSEE = -1
SQL_Documentation = -1
SQL_BooksOnline = -1
SQL_DatabaseSamples = -1
SQL_AdventureWorksSamples = -1
SQL_AdventureWorksDWSamples = -1
SQL_AdventureWorksASSamples = -1
SQL_Samples = -1
Complete: GenerateRequestsAction at: 2007/11/5 16:7:27, returned true
Running: CreateProgressWindowAction at: 2007/11/5 16:7:27
Complete: CreateProgressWindowAction at: 2007/11/5 16:7:27, returned
false
Error: Action "CreateProgressWindowAction" failed during execution.
Running: ScheduleActionAction at: 2007/11/5 16:7:27
Complete: ScheduleActionAction at: 2007/11/5 16:7:27, returned true
Skipped: InstallASAction.11
Waiting for actions from remote setup(s)
Breaking wait state and aborting package due to cancel code received:
1602
Remote setup(s) are ready
Notify package action is determined: 1602
Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe. Source
File Name: remotemessagelib\overlappedpipelistener.cpp
Compiler Timestamp: Sat Oct 7 09:43:54 2006
Function Name: sqls::OverlappedPipeListener::writePipe
Source Line Number: 294

Notification failed to send.
---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::installActio n

Removing machine from list of targets to sync.
Skipped: Action "InstallASAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "as", will not be installed.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "as", will not be installed.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "as", will not be installed.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "msxml6", referred by
package: "as", will not be installed.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "dts", will not be
installed.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "dts", will not be installed.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlncli", referred by
package: "dts", will not be installed.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "dts", will not be installed.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "dts", will not be installed.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "msxml6", referred by
package: "dts", will not be installed.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "ns", will not be
installed.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "ns", will not be installed.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlncli", referred by
package: "ns", will not be installed.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "ns", will not be installed.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "ns", will not be installed.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "msxml6", referred by
package: "ns", will not be installed.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "rs", will not be installed.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "rs", will not be installed.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "rs", will not be installed.
Skipped: InstallSqlAction
Clustered feature detected: SQL_Engine
Clustered feature detected: SQL_FullText
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\sqlsval.dll Version:2005.90.3042.0
Skipped: Action "InstallSqlAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sql", will not be
installed.
Skipped: InstallSqlAction.11
Skipped: Action "InstallSqlAction.11" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "sql", will not be installed.
Skipped: InstallSqlAction.12
Skipped: Action "InstallSqlAction.12" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlncli", referred by
package: "sql", will not be installed.
Skipped: InstallSqlAction.18
Skipped: Action "InstallSqlAction.18" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "sql", will not be installed.
Skipped: InstallSqlAction.21
Skipped: Action "InstallSqlAction.21" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlwriter", referred by
package: "sql", will not be installed.
Skipped: InstallSqlAction.22
Skipped: Action "InstallSqlAction.22" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "sql", will not be installed.
Skipped: InstallSqlAction.9
Skipped: Action "InstallSqlAction.9" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "msxml6", referred by
package: "sql", will not be installed.
Skipped: InstallToolsAction.11
Skipped: Action "InstallToolsAction.11" was not run. Information
reported during analysis:
All installs have been cancelled, so package: "sqlsupport", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.12
Skipped: Action "InstallToolsAction.12" was not run. Information
reported during analysis:
All installs have been cancelled, so package: "sqlncli", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run. Information
reported during analysis:
All installs have been cancelled, so package: "PPESku", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.18
Skipped: Action "InstallToolsAction.18" was not run. Information
reported during analysis:
All installs have been cancelled, so package: "owc11", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.20
Skipped: Action "InstallToolsAction.20" was not run. Information
reported during analysis:
All installs have been cancelled, so package: "BOL", referred by package:
"tools", will not be installed.
Skipped: InstallToolsAction.22
Skipped: Action "InstallToolsAction.22" was not run. Information
reported during analysis:
All installs have been cancelled, so package: "bcRedist", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.23
Skipped: Action "InstallToolsAction.23" was not run. Information
reported during analysis:
All installs have been cancelled, so package: "ssmsee", referred by
package: "tools", will not be installed.
Skipped: InstallToolsAction.9
Skipped: Action "InstallToolsAction.9" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "msxml6", referred by
package: "tools", will not be installed.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "as", will not be
installed.
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "sqlxml4", referred by
package: "ns", will not be installed.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "rs", will not be
installed.
Skipped: InstallToolsAction
Skipped: Action "InstallToolsAction" was not run. Information reported
during analysis:
All installs have been cancelled, so package: "tools", will not be
installed.
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run. Information
reported during analysis:
All installs have been cancelled, so package: "sqlxml4", referred by
package: "tools", will not be installed.
Error: Action "RepairForBackwardsCompatRedistAction" failed during
execution. Error information reported during run:
Action: "RepairForBackwardsCompatRedistAction" will be marked as failed
due to the following condition:
Condition "Package "22" either passed when it was last installed, or it
has not been executed yet" returned false. Condition context:
Prereq package will be failed due to the previous installation attempt
returning: 1602
Installation of package: "bcRedist" failed due to a precondition.
Skipped: UninstallForMSDE2000Action
Skipped: Action "UninstallForMSDE2000Action" was not run. Information
reported during analysis:
Action: "UninstallForMSDE2000Action" will be skipped due to the following
condition:
Condition "Action: InstallSqlAction was skipped." returned true.
Skipped: UninstallForSQLAction
Skipped: Action "UninstallForSQLAction" was not run. Information
reported during analysis:
Action: "UninstallForSQLAction" will be skipped due to the following
condition:
Condition "Action: InstallSqlAction was skipped." returned true.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run. Information
reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following
condition:
Condition "Action: InstallRSAction was skipped." returned true.
Error: Action "ExposeVistaClusteredResources" failed during execution.
Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to
the following condition:
Condition "The Clustered SQL Server instance that hosts is installed."
returned false. Condition context:
Action will be skipped due to sql failing to install.
Running: ReportChainingResults at: 2007/11/5 16:7:30
Error: Action "ReportChainingResults" threw an exception during
execution.
Setting exit code to ERROR_INSTALL_USEREXIT, : 1602
Error Code: 0x80070642 (1602)
Windows Error Text: User cancelled installation. Source File Name:
sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:32:00 2006
Function Name: sqls::ReportChainingResults:

erform
Source Line Number: 3667

"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote in message
news:79DFD7CE-1EDB-4512-8251-A3E236248063 (AT) microsoft (DOT) com...
Hi

What does it say in the log files? See
http://msdn2.microsoft.com/en-us/library/ms143702.aspx

You may want to use /qn instead of /qb to suppress the dialogs.

Quite often it is quicker and more reliable to reinstall!

John

"Loren Z" wrote:

I am trying to rebuild the master database of a SQL Server 2005 bit
clustered install. This is primarily to change the collation settings.
I
have been running the command:

start /wait <CD or DVD Drive>\setup.exe /qb VS=<VSName
INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1
ADMINPASSWORD=<StrongPassword> SAPWD=<NewStrongPassword
SQLCOLLATION=<NewSystemCollation> SQLACCOUNT=<domain\user
SQLPASSWORD=<DomainUserPassword> AGTACCOUNT=<domain\user
AGTPASSWORD=<DomainUserPassword> SKUUPGRADE=1

In the setup progress window and under "SQL Server Database Services"
the
status changes to "The installation was cancelled by the user" and the
setup
terminates.

I added "SKUUPGRADE=1" in that the version is SP2 but with or without
it the
results are the same.

What is wrong with what I am doing and what is the proper method of
rebuilding the master database to change collation settings under a
clustered install of SQL Server 2005 64-bit?

Do I have to uninstall and then reinstall?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Rebuilding the master database on a 2005 Cluster

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

Re: Rebuilding the master database on a 2005 Cluster - 12-06-2007 , 10:05 AM

Re: Rebuilding the master database on a 2005 Cluster - 12-12-2007 , 11:57 AM