Changing the sql server service and agent windows account password
Home > IT Answers > SQL Server > Changing the sql server service and agent win...
Rob3
5 pts.
0
Q:
Changing the sql server service and agent windows account password
SQL Server Services, SQL Server Agent, SQL Server security, SQL Server authentication
Hello, we are considering changing the sql server service and agent's password. What all should be considered prior to doing this? This will include doing this on 2000, 2005, and on clusters.

Thanks!
ASKED: Aug 5 2009  4:09 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
It's actually a very easy change to make. It will require that you restart the SQL Services on all your services though.

Use the Services Admin Tool (or control panel applet on Windows 2000) to change the password for the actual services on all the servers. Do NOT restart the services yet.

Once all the passwords have been reconfigured, reset the password on the domain. If you are in a multi-site environment have the domain admin force replication.

Restart all the SQL Servers.
Last Answered: Aug 5 2009  7:33 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0