Re: SQL Server service account password change

First, change the password of the SQL service account using the Domain Users
and Computers tool. Wait for the Active Directory information to propagate
to all domain controllers (typically 15 minutes).

Connect to your SQL Virtual Server using Enterprise Manager. Connect using
the "sa" account or using a windows account with SQL administrator
membership. All cluster host nodes must be up and running. Right-click the
server name and select Properties. Choose the Security tab and enter the
new password. Click OK. This should update the service account stored
password on all cluster nodes.

You will need to stop and restart the SQL Service at some point or it will
not be able to properly use the sevice account credentials to access network
resources. Do this change during a maintenance window if at all possible.

If this procedure fails, you can use the Services applet under control panel
to set the password on each node. Do not change the startup type to
anything other than MANUAL for a clustered SQL installation.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"AaronS" <gcsdba1@xxxxxxxxx> wrote in message
news:1143490318.616723.64140@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
OK. I've read all kinds of stuff on the internet about changing the SQL
Server Service and SQL Server Agent Service account passwords. They all
say "use Enterprise Manager" because it performs additional tasks that
you would otherwise have to perform manually. I can dig that.

My problem is that I can't figure out *how* to change the password(s)
using EM. I have no problem seeing how to switch to a completely
different account: just type in the account and password and stop and
restart the service. But how do I change *just the password* in EM?
Maybe I'm confused. Does EM actually change the service account's
password in the domain, or do I need to do that elsewhere before I
change the password in EM?

On top of this, I'm doing this in a clustered environment, and I'm
pretty new to SQL Server clustering. Can someone please set me
straight?

Thanks,
Aaron



.

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: Error 42d during Fail Over SQL 2000 Enterprise in a Server 2003 Ent. Cluster
    ... a valid login that you add back the service account that operates the ... Cluster service. ... Microsoft SQL Server MVP ... Administrator account, have re-entered the username and password 3+ ...
    (microsoft.public.sqlserver.clustering)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)