Solved

SA password change

Posted on 2014-10-15
5
50 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 49

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

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

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

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.
This is the first one of a series of articles I’ll be writing to address technical issues that are always referred to as network problems. The network boundaries have changed, therefore having an understanding of how each piece in the network  puzzl…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

679 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