How to install SQL Server to turn on SA user login

Home Install SQL Server How to turn on SA user logon:
(Remember to follow the Web site operation, the final must be in the "Administrative Tools" in the "service" in the "SQL Server (MSSQL server)" to deactivate once before starting, or still cannot use SA login)

In the new SQL installation, the following error occurred when logging into the database with the SA User:

Before loaded SQL7.0, SQL2000, SQL2005 version of, 2008 version of the, as if there is no such a complex Ah, Baidu has found a solution, summed up: This error is generally caused by three reasons, login method set error, SA set error and IP mode is open, The following three questions are resolved in turn.

Solution:

First, login mode settings
1. Log in as "Windows Authentication", go to the server, right-click, select Properties:

2. In the dialog box that appears, set the server authentication method in security to SQL Server and Windows authentication mode:

Second, SA settings
1. Go to "security", "Login name", "sa", and right-click on "sa" to select Properties.

2. In the popup dialog box, enable "sign in"

Third, turn on IP
1. Open SQL Server Configuration Manager, expand SQL Server Network configuration, and turn on TCP/IP in the MSSQLSERVER protocol:

2. Configure IP properties, enter the TCP/IP properties, enable the required address

3. Restart the SQL Server service:

You can log in to the database with SA below

http://blog.csdn.net/waterxcfg304/article/details/40617475

How to install SQL Server to turn on SA user login