Re: Changing SQL Service account passowrd on a cluster configurati

Here are the steps I went through recently to update the password for the SQL
service account (the previous password expired. It shouldn't be set to
expire, but that's a different story):

1. Remote desktop to each node
2. Start -> Run, type services.msc
3. In the service list, locate all the SQL Server related services that use
the password.
4. Double click on each such service
5. Click on the "Log On' tab.
6. Type in the new password in the Password and Confirm Password textboxes.
7. Click on Apply and OK.

Linchi

"Mehul" wrote:

Linchi, Thanks for your feedback.

So what steps do you follow to update password for all these services using
services.msc ?

"Linchi Shea" wrote:

It could be just me, but I had problem using Configuration Manager to change
the SQL service account password from time to time. I don't remember the
exact error message now, but I remember not having success in getting the
change replicated among the nodes.

I've had more success with just using the services.msc mgmt console to
change the SQL service account password on each node. This is just a hassle
since on each node there are a few services to change. I know Configuration
Manager is not cluster aware, but had hoped that at least any change made
through it to the SQL registry entries would be automatically replicated by
the cluster service.

Linchi

"Geoff N. Hiten" wrote:

For the cluster service account password:
http://support.microsoft.com/kb/305813/en-us

For the SQL 2005 Instance, use the SQL Configuration Manager to change the
password. It handles the "cluster magic".

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Mehul" <Mehul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C4EE5D43-00E3-4322-92C2-538B8CDEC12D@xxxxxxxxxxxxxxxx
Hi,
I have SQL 2005 server (with Named Instance) running on a two node Cluster
Configuration (Active/Passive).

SQL Instance, SQL Server Agent, SQL Server Browser services are running
under a service account (domain account). Similarly Cluster service is
also
running under a cluster service account (domain account).

I am looking for accurate steps to update password of SQL Service account
and Cluster service account that will cause minimum disruption of these
services. If there’s a link to documentation on how to update password,
that
will be most useful.



.

Relevant Pages
Loading