Rebuilding the master database on a 2005 Cluster
in [Server Configuration]
|
Prev: SQL Server Agent WMI Event alert
Next: 701 errors (Insufficient system memory to run this query)
From: Loren Z on 5 Dec 2007 13:36 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?
From: John Bell on 6 Dec 2007 04:30 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? > > >
From: Loren Z on 6 Dec 2007 10:17 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::installAction 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::perform Source Line Number: 3667 "John Bell" <jbellnewsposts(a)hotmail.com> wrote in message news:79DFD7CE-1EDB-4512-8251-A3E236248063(a)microsoft.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? >> >> >>
From: Loren Z on 6 Dec 2007 11:05 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(a)discussions.microsoft.com> wrote in message news:OkyJ%23tBOIHA.5524(a)TK2MSFTNGP05.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::installAction > > 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::perform > Source Line Number: 3667 > > > > "John Bell" <jbellnewsposts(a)hotmail.com> wrote in message > news:79DFD7CE-1EDB-4512-8251-A3E236248063(a)microsoft.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? >>> >>> >>> > >
From: John Bell on 6 Dec 2007 11:39 Hi have you checked that the service account for the task schedule has the correct privileges such as "Act as part of the Operating System" local policy on both nodes? John "Loren Z" wrote: > 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
|
Next
|
Last
Pages: 1 2 Prev: SQL Server Agent WMI Event alert Next: 701 errors (Insufficient system memory to run this query) |