Rebuilding the master database on a 2005 Cluster

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@.discussions.microsoft.com> wrote in message
news:OkyJ%23tBOIHA.5524@.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::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::perform
> Source Line Number: 3667
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:79DFD7CE-1EDB-4512-8251-A3E236248063@.microsoft.com...
>
Rebuilding the master database on a 2005 Cluster

Rebuilding master

Hi,
Where do i find rebuildm.exe utility and how do I build master using this utility? Is it something like builmaster utility in Sybase??
Thanks in Advance
Jaideepthe file should be in the SQL install CD
-Vallabhai

Originally posted by jaideep
Hi,
Where do i find rebuildm.exe utility and how do I build master using this utility? Is it something like builmaster utility in Sybase??

Thanks in Advance

Jaideep|||Look under program files for MicrosoftSQLServer

You should have 80\Tools\Binn

Or do a Finf in Explorere...

Then go buy ADMIN 911 for SQL Server 2000 by Brian Knight

didn't I post this already?

It's like deja vu all over again...

Rebuilding master

Hi,
Where do i find rebuildm.exe utility and how do I build master using this utility? Is it something like builmaster utility in Sybase??
Thanks in Advance
JaideepOriginally posted by jaideep
Hi,
Where do i find rebuildm.exe utility and how do I build master using this utility? Is it something like builmaster utility in Sybase??

Thanks in Advance

Jaideep

Look in ..\Program files\MicrosoftSQL Server\80\Tools\Binn

Or do a find in explorer

And buy ADMIN 911 for SQL Server 2000 by Brian Knight..

Rebuilding Full Text Catalog

Hi,
I have created a db install app that will install all datatables,
build full-text catalogs and add job scheduler to populate the
catalogs several times a day.
However, I would also like my catalogs to be rebuilt every midnight
and repopulated again. I know of Rebuild method and Start method but
how do I schedule it so it is rebuilt every midnight?
Thank you,
_dino_
Why do you want to do a rebuild? A full population should suffice.
To schedule a rebuild you would schedule sp_fulltext_catalog
'catalogname','rebuild'
Have this job run in the database you are full-text indexing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
news:929nf11uhqac6ajetilqje30crccvjqast@.4ax.com...
> Hi,
> I have created a db install app that will install all datatables,
> build full-text catalogs and add job scheduler to populate the
> catalogs several times a day.
> However, I would also like my catalogs to be rebuilt every midnight
> and repopulated again. I know of Rebuild method and Start method but
> how do I schedule it so it is rebuilt every midnight?
> Thank you,
> _dino_

Real-time data minig

We have completed the implementation of data mining algorithms.Now we have to build an API for real time data mining.Is that possible in SQL Server?

Please explani what you mean by "real-time" data mining.

Also, by completing implementation of algorithms, do you mean you have completed implementation of algorithms that integrate into Analysis Services?

|||Closeing this thread due to no response

Real time "live" data on a windows application .NET 2.0

I want to build a windows application in Visual Studio 2005 that grabs some data from a SQL DB and displays it in a gridview. That is easy and I already have it done, but I also want to know how to show this data in real-time. For example: right now we have a application that pulls some login information for all the users and displays their phone extension, their name, and their status. They can change their status by clicking on some radios below the datagrid and on change it updates the data and then posts back. However, I dont know how the guy who did it made it so that these local changes are automatically shown on everyone elses computers around the office. In other words, they are shown the live data as it changes, without having to refresh it or anything. How would I go about doing this or does anyone have any places/resources that could help me accomplish this task. Thanks.

Oh and the guy who wrote this is no longer working here and he deleted the source code so i cant look at it.

Here's the answer I got from one of our Dev:

there are two methods, a push method or a pull method: you could use something like NotificationServices (I haven't used this. There's some data on it athttp://msdn2.microsoft.com/en-us/library/ms170722(en-US,SQL.90).aspx) to tell you that the data has changed, or you could poll at intervals (or during lulls in processing time) for changes in data.

Either way you go, you're going to face problems of collisions if the users can change the same data. What would you do if you're in the middle of editing a row, and another user deletes it, and you poll for data?

Hope that helps,

Lan

|||

thanks for the reply. the application is designed to only allow the user to change their own data, therefore there will be no way that any user can be changing the same data. I will take a look at that article.