Recently Rebuilt SQL2K Cluster

I have recently had to rebuild my SQL Server 2000 sp3a 2 node active/passive
cluster running on Windows 2000 AS SP4. We ran into issues about two weeks
ago after a SAN migration (I'll spare all the gory details). When my
previous cluster died, I used one of the nodes as a stand alone instance of
SQL Server (to run our production database). On the other former node, I
removed the OS clustering software and had to manually remove SQL Server. I
eventually (with the assistance of Donna L. at MS) was able to get a single
node cluster of SQL2K running on physical server PRODSQL01 (the virtual
server name is PRODSQLCL01). While the cluster was running as a single node
cluster, I applied sp3a and the 818 hotfix. I then migrated the data from
the stand alone instance to PRODSQLCL01 and started to use it for production.
I turned my attention to the other box and removed and reinstalled the
Windows 2000 cluster software. This box is now called PRODSQL02. I was able
to add PRODSQL02 to the windows cluster, and the successfully added it via
SQL Server setup to the virtual server. My issue now is that PRODSQL02 has
the RTM versions of the binaries. I am not sure if I have a setup issue or I
misunderstand point 3.10 of the sp3a readme. Currently the virtual server is
running on PRODSQL01. If I attempt follow the steps under "If you need to
rebuild a node in the failover cluster..." from PRODSQL02 I am only able to
select the Virtual Server, and if I continue setup I get this error "all
cluster disks available to this virtual server are owned by other node(s)"
and then "Setup was unable to verify the state of the server for an upgrade.
Verify the server is able to start and that you provided a valid sa password
and restart setup". I understand that the virtual resources are only
available on the currently active node, but the way I read the instructions I
should be able to run the service pack installation on the inactive node. Do
I need to rerun the SP (and hotfix) setup on SQL01 (since the virtual server
is running there)? Do I need to move the resources to SQL02 and run the SP
setup there? I just need clarification of where to run the SP setup since I
just added SQL02 to this cluster.
You should be able to run setup on the non-host node and it will upgrade the
local binaries. Try rebooting the newly added RTM node and see if it helps.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Justin Hoffmann" <Justin Hoffmann@.discussions.microsoft.com> wrote in
message news:A214ED19-F6CD-4D25-90CE-0A1D456750BD@.microsoft.com...
>I have recently had to rebuild my SQL Server 2000 sp3a 2 node
>active/passive
> cluster running on Windows 2000 AS SP4. We ran into issues about two
> weeks
> ago after a SAN migration (I'll spare all the gory details). When my
> previous cluster died, I used one of the nodes as a stand alone instance
> of
> SQL Server (to run our production database). On the other former node, I
> removed the OS clustering software and had to manually remove SQL Server.
> I
> eventually (with the assistance of Donna L. at MS) was able to get a
> single
> node cluster of SQL2K running on physical server PRODSQL01 (the virtual
> server name is PRODSQLCL01). While the cluster was running as a single
> node
> cluster, I applied sp3a and the 818 hotfix. I then migrated the data from
> the stand alone instance to PRODSQLCL01 and started to use it for
> production.
> I turned my attention to the other box and removed and reinstalled the
> Windows 2000 cluster software. This box is now called PRODSQL02. I was
> able
> to add PRODSQL02 to the windows cluster, and the successfully added it via
> SQL Server setup to the virtual server. My issue now is that PRODSQL02
> has
> the RTM versions of the binaries. I am not sure if I have a setup issue
> or I
> misunderstand point 3.10 of the sp3a readme. Currently the virtual server
> is
> running on PRODSQL01. If I attempt follow the steps under "If you need to
> rebuild a node in the failover cluster..." from PRODSQL02 I am only able
> to
> select the Virtual Server, and if I continue setup I get this error "all
> cluster disks available to this virtual server are owned by other node(s)"
> and then "Setup was unable to verify the state of the server for an
> upgrade.
> Verify the server is able to start and that you provided a valid sa
> password
> and restart setup". I understand that the virtual resources are only
> available on the currently active node, but the way I read the
> instructions I
> should be able to run the service pack installation on the inactive node.
> Do
> I need to rerun the SP (and hotfix) setup on SQL01 (since the virtual
> server
> is running there)? Do I need to move the resources to SQL02 and run the
> SP
> setup there? I just need clarification of where to run the SP setup since
> I
> just added SQL02 to this cluster.
>
|||Geoff:
I've rebooted the newly added RTM node several times and it doesn't seem to
help. When I launch SP3 setup (via setup.bat in the local sql2ksp3
directory) on the newly added RTM node I get to the screen that says Computer
Name. Local Computer is grayed out, there is a box for the existing Virtual
Server name. When I type the virtual server name in the box and press next,
I get the error messages I mentioned in my original post. Is there anything
else you can recommend?
Thanks,
Justin
"Geoff N. Hiten" wrote:

> You should be able to run setup on the non-host node and it will upgrade the
> local binaries. Try rebooting the newly added RTM node and see if it helps.
>
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
>
|||This is how I wound up fixing this:
I ran sp3a setup from PRODSQL01, which was the machine in control of the SQL
Virtual server at the time. It updated the binaries on PRODSQL02, but in
order to do so, the SQL Server service was stopped. Once sp3a setup
completed, I had to reboot PRODSQL02. When it was back up, I verified the
version of the sqlservr.exe file, and it was 8.00.760 (right click,
properties, version). Once I established that sp3a took on the newly added
node, I started the setup for the 8.00.818 security hotfix. SQL Server went
down briefly again, and then the binaries on the newly added box were
updated. I then installed MDAC 2.8 on this node and rebooted. Once
PRODSQL02 was running again I tested moving the cluster resources from 01 to
02. It succeeded. While SQL was running on 02 I ran throught setting up
Imceda SQL Lite Speed (again, it was on 01 but not 02). Once that completed,
I was able to verify that my normally scheduled transaction log backups
completed successfully. Both machines run SQL Server and perform the
backups correctly. I am not sure about the root cause of the issue I
encountered with not being able to run the sp and hotfix on the newly added
node when it wasn't running the Virtual SQL Server (the sp3a readme seems to
indicate that you can), but I finally have a 2 node active passive cluster
running again.
|||Just to clarify, it is active passive, so only one node runs the Virtual SQL
Server at any time. I was trying to say that each node is able to run SQL
Server, and each node is able to run the SQL Lite Speed backups. I had been
concerned that somehow I would get PRODSQL02 all patched but then failing
over would not work correctly. Everything is working OK.
"Justin Hoffmann" wrote:

> This is how I wound up fixing this:
> I ran sp3a setup from PRODSQL01, which was the machine in control of the SQL
> Virtual server at the time. It updated the binaries on PRODSQL02, but in
> order to do so, the SQL Server service was stopped. Once sp3a setup
> completed, I had to reboot PRODSQL02. When it was back up, I verified the
> version of the sqlservr.exe file, and it was 8.00.760 (right click,
> properties, version). Once I established that sp3a took on the newly added
> node, I started the setup for the 8.00.818 security hotfix. SQL Server went
> down briefly again, and then the binaries on the newly added box were
> updated. I then installed MDAC 2.8 on this node and rebooted. Once
> PRODSQL02 was running again I tested moving the cluster resources from 01 to
> 02. It succeeded. While SQL was running on 02 I ran throught setting up
> Imceda SQL Lite Speed (again, it was on 01 but not 02). Once that completed,
> I was able to verify that my normally scheduled transaction log backups
> completed successfully. Both machines run SQL Server and perform the
> backups correctly. I am not sure about the root cause of the issue I
> encountered with not being able to run the sp and hotfix on the newly added
> node when it wasn't running the Virtual SQL Server (the sp3a readme seems to
> indicate that you can), but I finally have a 2 node active passive cluster
> running again.
|||The current correct term is "Single-Instance". "Active-Active" and its
cousins all refer to technology used specifically in SQL server 7.0 only.
Sometimes the binary only upgrade doesn't work right. Your solution is the
fallback solution but it does have the obvious downside of taking the SQL
server offline for a short time during the upgrade.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Adminstrator
"Justin Hoffmann" <JustinHoffmann@.discussions.microsoft.com> wrote in
message news:DA3E156A-EAFD-45D9-B72E-AB4A657D53A0@.microsoft.com...[vbcol=seagreen]
> Just to clarify, it is active passive, so only one node runs the Virtual
> SQL
> Server at any time. I was trying to say that each node is able to run SQL
> Server, and each node is able to run the SQL Lite Speed backups. I had
> been
> concerned that somehow I would get PRODSQL02 all patched but then failing
> over would not work correctly. Everything is working OK.
> "Justin Hoffmann" wrote:

Rebuilding the master database on a 2005 Cluster

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?
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?
>
>
|||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...[vbcol=seagreen]
> 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:
|||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...
>
|||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
|||Rebuilding the master database on a 2005 Cluster

Rebuilding the master database on a 2005 Cluster

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?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 set
up
> terminates.
> I added "SKUUPGRADE=1" in that the version is SP2 but with or without it t
he
> 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?
>
>|||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 Ser
ver
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 Ser
ver
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::in
stallAction
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...[vbcol=seagreen]
> 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:
>|||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::in
stallAction
> 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...
>|||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 polic
y
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 S
erver
> 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 Acces
s
> is denied.
> It will probably be easier to reinstall in that I am in the beginning stag
es
> of setting up the server. However, we have had to change collation setting
s
> 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 tru
e
> 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 fals
e.
> 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|||This problem has been solved.
Under ADMINPASSWORD I was entering the SA password for SQL Server. An
adminstrator password on the server is what is required. Once I used the
latter, I was able to rebuild the system databases.
"Loren Z" <anonymous@.discussions.microsoft.com> wrote in message
news:%23nZ5%23ICOIHA.4740@.TK2MSFTNGP02.phx.gbl...
> 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...
>sql