Solved

SA password change

Posted on 2014-10-15
5
48 Views
Last Modified: 2015-03-02
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
Comment
Question by:IKtech
  • 2
  • 2
5 Comments
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 250 total points
ID: 40383117
usually anything on that same server wont be impacted, but if  there is another application that uses 'sa', it could be affected.
0
 
LVL 3

Author Comment

by:IKtech
ID: 40383159
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
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 40383173
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
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 40383787
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
 
LVL 3

Author Closing Comment

by:IKtech
ID: 40640629
Thanks!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql query 34 35
BULK LOGGED - log full 9 25
Network Switch Connections 8 52
Getting same value for every field in SQL 2 10
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now