Sql Server 2008R2 with windows authentication

I have sql server 2008r2 running with windows authentication.  The domain admin password needs changed and I am wondering if there is any additional steps to ensure jobs, maintenance plans , etc will still work correctly after changing the domain admin password in active directory...

I am thinking that once I change the password there should be no additional setup on the server but perhaps any other apps or pc\servers connected may need a password updated.

Any thoughts?  Thanks experts!!!
Who is Participating?
Vitor MontalvãoMSSQL Senior EngineerCommented:
The domain admin password needs changed
i have a different windows domain account running the services..

Then you don't need to worry. Everything will be just fine.
Aneesh RetnakaranDatabase AdministratorCommented:
You need to make sure that the SQL service account is not the Domain Admin account, also any services related to SQL Server (Ager, VSS, etc ) ..
IKtechAuthor Commented:
i have a different windows domain account running the services....
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

HuaMin ChenProblem resolverCommented:
If you can the password, other application using the relevant accounts, should be adjusted as well.
If you're changing machine password you will have to refresh all the opened connection. So in other words Client Application restart is also needed.
IKtechAuthor Commented:

Even if the maintenance plans with there schedules have been created by logging into management studio using the domain admin account login?  

Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes. The jobs by default runs with the SQL Server Agent account unless you provide another user credential.
IKtechAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.