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 brukere syntes dette svaret var til hjelp
Var dette svaret til hjelp?

Related Articles

Manage Database Roles

Solution Database roles are conceptually completely separate from operating system users....

Install and configure DNS server in Windows Server 2003

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

Fix Lame Nameserver Error

A lame server, is one that is specifed at the registrar to be authoritative for a domain, but...

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