Question, can SQL Server 2000 SP3 (not SP3A) be applied
to a windows 2003 cluster? I tried this recently (two
times) and received "the required operations did not
complete". However, the sqlsp logs state that the
installation was successful. Will soon be migrating some
databases over from an environment with SP3 which is why
we chose this service pack level. Was intallation

I'd try to reinstall the sp in debug mode using the below command. This
should tell you exactly where the command is failing or what pending
operations have not succeeded.

c:\x86\setup\Setupsql.exe k=dbg where x86 is the directory you have your sp
in.


--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

You cannot run the setup in debug mode for SQL failover clustering. Debug mode works great for standalone instances.

To answer you qs "

Question, can SQL Server 2000 SP3 (not SP3A) be applied to a windows 2003 cluster? I tried this recently (two times) and received "the required operations did not
complete". However, the sqlsp logs state that the installation was successful. Will soon be migrating some
databases over from an environment with SP3 which is why we chose this service pack level. Was intallation successful or not?

Answer. Yes, you can install SQL Server 2000 SP3 on Windows 2003 Cluster.

Which setup gave the message "the required operations did not complete". I am assuming the SP3 setup as you are referring to the sqlsp.log. Am I correct? If yes, then review the sqlsp.log and see what failed. If you
cannot find anything, cut and paste sqlsp.log.

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx