Tuesday, March 10, 2015

SQL SERVER – Reset SA Password.

The SQL Server "sa" password is default system administrator login to access the database server.  To ensure that this password is secure and not used by unauthorized users.

Follow the below steps:
  1. Open the SQL Server management studio.
  2. Connect to SQL Server using windows authentication.
  3. Expand the server and choose security and expand logins.
  4. Right click on sa, from properties modify the password and confirm password

Impact of change 'sa' password:-
  1. If we are using sa login to run DTS packages, changing sa password will affect to run on the DTS package.
  2. All the DTS package that has used the sa and it's password.
  3. All applications that are using the sa login to perform the activities
  4. All scheduled jobs on Server that are used SA password for authentication on the Server.
  5. All SQL Server jobs which are owned by sa.
  6. All link servers that are used to sa login to connect to the server.

No comments: