• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • Last Modified:

Issue with changing SA password?

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
Kram80
Asked:
Kram80
2 Solutions
 
jcott28Commented:
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
 
viscogelCommented:
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 Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now