question

mt-8412 avatar image
0 Votes"
mt-8412 asked CarrinWu-MSFT commented

any effect of changing sa password

hi every one.I have to change the sa password In sql server. Does changing the password have an effect on sql server jobs or any other object on the server? Is the sql server version important for the effect of this change?

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @mt-8412, we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Not on jobs or any other internal process.
But by my experience several people uses "sa" for application logins, by fail.
And so I would say: Change it and see which app uses "sa", which shouldn't; that' a very high security issue if they do.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @mt-8412,

Welcome to Microsoft Q&A!

Does changing the password have an effect on sql server jobs or any other object on the server?

There should be no impact unless you use sa login for SQL server jobs or any other object. Before you change the password, please check that there have any jobs use the sa login or not. Please refer to this blog to get more information about change sa password.


Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.