Solved

Issue with changing SA password?

Posted on 2011-03-24
2
436 Views
Last Modified: 2012-05-11
When running an MBSA scan an issue was indicated with the SA account.  The password for this account is either weak or blank.  What implications are there by changing this password to a stronger password?  This server runs a database for our anti-virus.  It is a SQL 2000 server.
0
Comment
Question by:Kram80
2 Comments
 
LVL 5

Accepted Solution

by:
jcott28 earned 63 total points
ID: 35209713
Depends on your setup.  Do other apps actually access the database using the sa accont?  Is the sa account even used?  The sa account is just a user account, so changing the password only affects people or applications which use it.  If nothing uses it, it's best to have a solid password.
0
 
LVL 2

Assisted Solution

by:viscogel
viscogel earned 62 total points
ID: 35209728
You need to check if the SA user is not assign to any application, like the anti-virus.
Normaly the aplicattions use the windows authentication to access the database.

So, i think there are no implications changing the SA password.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Virtual SQL Server 2014 Standard 35 85
SQL DATEADD 10 69
Parse this column 6 21
Getting invalid Syntax SQL. 3 14
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

791 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