SQL Server SP4 on a cluster environment

Hi Folks,

I am trying to install SP4 from SP3 on a SQL Server 2000. It is failing at authentication.
I tried both sa and domain account which runs the SQL Services.
I followed microsoft guidelines but still failing.

I am trying to make the 2 nodes online and then patching on the virtual name so it patches both nodes.

Please help.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

qadsamAuthor Commented:
Ok this is from the sqlsp.log

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.

Please help.

Firstly, is this an active/passive cluster? If yes, you will be able to see the services running on only active node.

Coming to the installation of SP4, it is pretty straight forward. However, here are some steps which needs to be followed:

1. Make sure that you reboot both the nodes of the cluster one after the other before SP4 installation.
2. Once the reboot is done for both the nodes, make sure that the cluster service is up and running fine
3. Check for any errors in event viewer after the reboot of the nodes.
4. Login to the virtual server by using the virtual sql server name and start the installation of SP4
5. In the installation page, provide the virtual sql server name under the server name and use sa (I believe you must have verified connecting to SQL Server using sa earlier)
After which, you should be able to proceed further without any issues.

Please check and revert if you are still having any issues with the installation.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

qadsamAuthor Commented:
Thanks so much for your feedback.

When i tried before i also tried with sa and it was giving me the same error.

BUt i will try your step of rebooting before the install.
qadsamAuthor Commented:
ALso i tried by keeping both the nodes up, the active and passive.

This was according to the microsoft patch readme.
Jim P.Commented:
With SQL Server 2005, you have to have all the active instances running on one node to create a new instance or patch.

A new instance would have to be done from the active node. Any SQL patches have to be initiated from the inactive node.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.