[sims] Will I break SIMS if I change the SA Password?

[BatchFile]

I'd like to change the SA password on our SIMS server. They guy that set it up has left, without leaving a record of what it was. It looks as if I can do it by going into SQL Management Studio using Windows Authentication - but I'm a bit worried as I'm not sure of the consequences!

 

Is there any reason why I shouldn't do it by expanding Security > Logins, then right clicking on sa, selecting properties and entering a new password?

 

Anything to watch out for?

 

 

Then I can get on with scripting a DbAttach backup that can run without stopping the server:confused2:

[Norphy]

If I were you, I would create a new user with the required permissions and use that for your backup. On our SIMS servers at least, there is at least one service (SOLUS) that uses the SA password and I have no doubt that there are more.

[Hardeep_Sco]

Hey mate,

 

Have you tried to use the ChSaPwd.exe in the Binn folder which is located in the SIMS SQL installation?

 

Thanks

[BatchFile]

I can answer this one for myself now

I had Capita on Remote as I was having problems applying a patch - and it needed to be applied as SA. They reset the password for me (after an email of authority from SMT), by running a query and we've had no ill effects.

 

So in my case at least, the answer is no, it won't break SIMS, if it's done like that

Edited March 6, 2020 by BatchFile