Re: Changing SQL Service account passowrd on a cluster configurati

Linchi,
Here's what worked for me. Quite similar to the steps you have outlined:

1. Changed SQL Service account password in AD. Waited for about half an hour
so that password change gets replicated to all the domain controllers.
2. Updated the password on the active node of the SQL Cluster using SQL
Configuration manager for all the services.
3. Restarted the services using SCM. Everything looked fine till now.
4. On the passive node, using Services MMC, manually updated password for
the SQL services.
5. Fail over the cluster from node 1 to node 2, everything worked fine with
no errors.

I will be blogging these steps, but hope that other people who are in the
same situation will find this discussion useful.

Thanks Geoff and Linchi for your quick responses.


"Linchi Shea" wrote:

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

  • Re: Active Directory Migration of a two node cluster
    ... When I created Cluster Service & SQL Server Service account in New Domain, ... I added those to "Domain Admins" global group and grant additional local ...
    (microsoft.public.windows.server.clustering)
  • Re: Microsoft SQL Virtual server fails after moving the cluster to Active Dir
    ... How to Manually Re-Create the Cluster Service Account ... > SQL SQL server and Clusters services. ... > virtual SQL server name to see what would happen, ...
    (microsoft.public.win2000.advanced_server)
  • 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 ... locate all the SQL Server related services that use ... the SQL service account password from time to time. ... Similarly Cluster service is ...
    (microsoft.public.sqlserver.clustering)
  • Re: SPN creation
    ... will i need to create an spn for the live sql server service account in order ... front end website to get Kerb delegation to the backend if your AD is 2003 ... form port-specific SPNs for HTTP, ...
    (microsoft.public.windows.server.active_directory)
  • Re: SPN for SSL over common name
    ... you can't register those SPNs under the SQL Server's ... service account is the MSSQL SPN. ... That SPN should be registered under ... Lastly, since the SQL Server is not being used for delegation anywhere, ...
    (microsoft.public.inetserver.iis.security)