• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 56
  • Last Modified:

SA password change

I want to change the SA password on our sql server and I want to attempt this password change with out interrupting jobs and other items that may break as a result of the password change...

Any advice or areas to check before making the change?  Thanks experts!!!
0
IKtech
Asked:
IKtech
  • 2
  • 2
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
usually anything on that same server wont be impacted, but if  there is another application that uses 'sa', it could be affected.
0
 
IKtechAuthor Commented:
I was worried about maintenance plans and jobs.  If I open the Job properties I see in bottom right corner I see an area labeled connection.  It reads sa under the connection however, if I click the "view connection properties" I cannot change it to another user.

will the password get updated for these jobs or is there a place where I need to change the connection properties?

I can upload a screen shot if this is confusing...  thanks!!
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
If they are running under 'sa' you need to change the password there too.  If you are planning to update them, try running them under the Windows Authentication.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you are talking about SQL Agent jobs then you don't need to worry about them. They will continue working perfectly since they will run under the new credentials.
The only problem is if you have an external application that uses 'sa' login to perform tasks. If so, you need to update the configuration of that application with the new password.
0
 
IKtechAuthor Commented:
Thanks!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now