Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SA password change

Posted on 2014-10-15
5
Medium Priority
?
55 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 1000 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 52

Accepted Solution

by:
Vitor Montalvão earned 1000 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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…
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…
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…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

972 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