How to change the Server Authentication Mode

Http://technet.microsoft.com/zh-cn/library/ms188670.aspx

 

 

SQL Server 2008 books online (May 2009) How to change the Server Authentication Mode

During installation, the SQL Server database engine is setWindows Authentication ModeOrSQL Server and Windows Authentication Mode. This topic describes how to change the security mode after installation.

If you select"Windows Authentication Mode"The sa Login Name is disabled. If you change the Authentication Mode"SQL Server and Windows Authentication Mode"The sa Login Name is still disabled. To enable the SA Logon account, use the alter login statement.

Security description:
The SA account is a well-known SQL Server account and is often targeted by malicious users. Do not enable the SA account unless your application needs to use it. It is important to use a strong password for the sa Login Name.

The sa Login name can only be connected to the server using SQL Server Authentication.

Change Security Authentication Mode

1. In the object Resource Manager of SQL Server Management studio, right-click the server and then click"Attribute".

2. In"Security"Page"Server Authentication"Next, select the new Server Authentication mode, and then click"OK".

3. In the SQL Server Management studio dialog box, click"OK"To confirm that you need to restart SQL Server.

Restart SQL Server from SQL Server Management Studio

1. In object Resource Manager, right-click your server and then click"Restart". If an SQL Server Agent is running, you must restart the agent.

Use Transact-SQL to enable the SA Logon account

1. Run the following statement to enable the SA password and assign a password.

   Copy code

   ALTER LOGIN sa ENABLE ;GOALTER LOGIN sa WITH PASSWORD = '<enterStrongPasswordHere>' ;GO

Use Management studio to enable SA Logon account

1. In the object Resource Manager, expand"Security", "Login Name", right-click"Sa"And then click"Attribute".

2. In"Regular"Page, you may need to create a password for the sa Login Name and confirm the password.

3. In"Status"Page"Login"Section, click"Enabled"And then click"OK".

Other versions of the following products are also available:

• {
  Track ('ctl00 _ ctl00 | ctl00_ctl02 ', this );
  } "Href =" http://technet.microsoft.com/zh-cn/library/ms188670 (SQL .90). aspx "> SQL Server 2005