We help IT Professionals succeed at work.

Sql Server 2008R2 with windows authentication

IKtech
IKtech asked
on
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!!!
Comment
Watch Question

AneeshDatabase Consultant
Top Expert 2009

Commented:
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 ) ..

Author

Commented:
i have a different windows domain account running the services....
HuaMin ChenProblem resolver

Commented:
If you can the password, other application using the relevant accounts, should be adjusted as well.
ashishsingh4uAssociate

Commented:
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.
IT Engineer
Distinguished Expert 2017
Commented:
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

Author

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!
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Yes. The jobs by default runs with the SQL Server Agent account unless you provide another user credential.

Author

Commented:
THanks!!