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?
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?
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!
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.
Hi @mt-8412,
Welcome to Microsoft Q&A!
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.Does changing the password have an effect on sql server jobs or any other object on the server?
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.
15 people are following this question.