• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 526
  • Last Modified:

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.

1 Solution
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.
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now