changing domain administrator password with sql

Adriaan2k

Hi,

i need to change the domain administrator password. We also use MSS SQL 2005 for our NAV database. Does anyone know if this action will cause problems ? We log into the sql database also with SQL Server Management Studio which uses the administrator windows login to connect.

garak

Do you need to change the Domain Admin PW in your SQL Manager wit SQL statements:?: Why this :?: The admin should change the password self (he should know where) :!:

Adriaan2k

garak wrote:

Do you need to change the Domain Admin PW in your SQL Manager wit SQL statements:?: Why this :?: The admin should change the password self (he should know where) :!:

Hello Garak, thanks for your quick reply. The domain admin pw needs to be changed out of security matters. However i don't know if there will be problems with our Nav sql database. I have no idea wether i have to change the admin pw in sql or not.

David_Singleton

Adriaan2k wrote:

Hi,

i need to change the domain administrator password. We also use MSS SQL 2005 for our NAV database. Does anyone know if this action will cause problems ? We log into the sql database also with SQL Server Management Studio which uses the administrator windows login to connect.

This really depends on how your system is set up. There will be a number of taks that require a userid and password, so if they are using the Admin password then you could have issues.

First things to check will be that he SQL server it self (totaly unrelated to SSMS) is using the admin password to start up. Also look for any NAS services.

best bet is to go to the SQL server, look at services and see what services use the administrator password.

But for sure try to resolve all this BEFORE changing the password.

Adriaan2k

thanks for you tip David. I'll check the services to see which use the admin account and password.