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 användare blev hjälpta av detta svar
Hjälpte svaret dig?

Related Articles

Install and configure DNS server in Windows Server 2003

Solution Install DNS 1. Open Windows Components Wizard. To do so, use the following...

Restore a database on SQL Server using .mdf, .ldf and .ndf files?

You need to attach the database rather than perform a restore. Using Enterprise Manager: Expand...

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...

Manage Query Cache

You can check whether the query cache is present in your MySQL server using the following...