SQL server2012 Remote access settings

transferred from: http://blog.csdn.net/xiadingling/article/details/8215282Steps

2. Open SQL server2012, log on with Windows identity

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

6. Select "Connect", check "Allow remote connection to this server", then click "OK"

8. Expand Security, login name; SA ", right-select" Properties "

10. On the left, select General, select SQL Server authentication on the right, and set the password

12. Right-click on the database Select "Facet"

14. Select Server configuration in the Aspect drop-down box on the right, set the Remoteaccessenabled property to True, and click OK

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

18. Open SQL Server Configuration Manager

20. Start by configuring SSCM, check the SQL Server service on the left, and make sure that SQL Server on the right and SQL Server Browser are running

22. "TCP/IP" of the client protocol is also modified to "Enabled"

    Select the IP Address tab, set the port for TCP to "6233"------Set the default port based on advance booking

26. MSSQLSERVER protocol enables TCP/IP

    The firewall configuration is not in detail, as is the case with other SQL Server database configurations.

    When the configuration is complete, restart SQL Server 2012. You should be able to use it at this time, but still have to confirm the firewall. Open the firewall settings. The SQLServr.exe (C:\Program Files\Microsoft SQL Server\mssql11. Mssqlserver\mssql\binn) is added to the Allowed list.

    C:\Program Files (x86) \microsoft SQL Server\90\shared\sqlbrower.exe is added to the firewall exception, and there are ports.

SQL server2012 remote access settings (RPM)