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!!!
LVL 3
IKtechAsked:
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.
Cheers
0
 
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 ) ..
0
 
IKtechAuthor Commented:
i have a different windows domain account running the services....
0
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.
0
 
ashishsingh4uAssociateCommented:
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.
0
 
IKtechAuthor Commented:
@Vitor

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

Thanks!
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes. The jobs by default runs with the SQL Server Agent account unless you provide another user credential.
0
 
IKtechAuthor Commented:
THanks!!
0
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.