Home > IT Answers > SQL Server > Changing the sql server service and agent windows account password
Rob3
5 pts.
 Changing the sql server service and agent windows account password
SQL Server Agent, SQL Server authentication, SQL Server security, SQL Server Services
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!

Software/Hardware used:
ASKED: August 5, 2009  4:09 PM
UPDATED: August 5, 2009  7:33 PM
RELATED QUESTIONS
Answer Wiki:
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 Wiki Answer Submitted:  August 5, 2009  7:33 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _