[sims] SIMS changing Admin password.

[nicholab]

I am looking to change the Admin password I have looked in SQL management studio and I see that Windows Authentication is used to logon on. I take it I also need to change the account that SQL server runs under to Local system or another account? It would then just be scheduled task that need looking into.

[Banjo]

Do you mean the SA password for SQL? I've always used the SA password in Studio to logon rather the Windows Auth. From memory when you install SQL (instance) you have the option to put your own SA password in.

 

/SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /SECURITYMODE="SQL" /SAPWD="PASSWORD-HERE" /ADDCURRENTUSERASSQLADMIN=True /TCPENABLED=1 /NPENABLED=1 /IACCEPTSQLSERVERLICENSETERM

[howartp]

I'm guessing he wants to change the current SA password on an existing instance?

[nicholab]

I looking to change all passwords starting with the administrator I have the SA password.

[howartp]

Ah, sorry.

 

It's a while since I did that exercise - in fact I think I did it as part of new install so I never had to actually change the existing server.