Reset the SQL Server ‘sa’ user password?

Open Enterprise Manager and expand the registered SQL server.

Expand Security.

Click on Logins.

Right-click the user “sa” and select Properties.

Type the new password in the Password field.

Click OK, and you will be prompted to re-type the password.

  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Change the DNS servers for the network interfaces on Windows server

In Network Connections, right-click the local area connection, and then click Properties. In...

Export the data from different tables in our shared SQL environment?

Using Enterprise Manager Expand SQL Server group Expand the server name Expand Databases...

Change the root password for a *nix server

In order to change the root password login to the server as root and type the following, then...

Execute a SQL script (.sql file) on MsSql Server database

To execute a .sql file, you need to open the “Query Analyzer” Start -> Programs ->...

After restoring a SQL Server database, it show a status of “Loading”

Getting the database out of LOADING state When restoring multiple backups, each backup needs...