SQL Server2012 Remote access settings (for 2008)

SQL2008 or SQL2012 An error that does not have a remote connection turned on. The following is a summary of the methods to open.

1. Open SQL server2012, log in with Windows identity

2. After logging in to the server, right-click Properties. On the left, select "Security" and select "SQL Server and Windows authentication mode" on the right to enable hybrid login mode

3. Select "Connect" on the left, tick "Allow remote connection to this server", then click "OK"

4. Expand "Security", "Login name"; " SA ", right-select" Properties "

5. On the left, select "General", select "SQL Server Authentication" on the right and set the password

6. Right-click the database Select "Facet"

7. Select "Server Configuration" in the Side drop-down box on the right, set the "Remoteaccessenabled" property to "True", and click "OK"

8. Now that SSMs is set up, exit first, and then log in with SA, success means that the SA account is enabled

9. Open SQL Server Configuration Manager

10. Start configuring SSCM below, check the SQL Server service on the left, and make sure that SQL Server on the right and SQL Server Browser are running. Note the SQL name that corresponds to your computer.

11. Ensure that the "TCP/IP" of the "client Protocol" is also "enabled"

12.SQLSEVER2012 protocol enables TCP/IP

13. Ensure that the TCP/IP of the client protocol in the SQL Native clients configuration is "enabled"

SQL Server2012 Remote access settings (for 2008)