Solved

SA password change

Posted on 2014-10-15
5
52 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 51

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

630 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