SQL Server R2 open allow remote connections

Method/Step

2. 1

   Log in to SQL Server (Windows authentication), right-click after login, and select "Properties".

4. 2

   Select Security on the left, and select SQL Server and Windows authentication mode on the right to enable hybrid login mode.

6. 3

   Select "Connect", check "Allow remote connection to this server", we recommend "Maximum concurrent connections" as the actual situation, and then click "OK".

8. 4

   Expand Security, login name, SA, and right-select properties.

10. 5

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

12. Select "Status", select "Enable" and click "OK".

14. Right-click the database and select facets.

16. In the "Facets" list box, select "Server Configuration," "Remoteaccessenabled" and "remotodacenabled" set to "True" and click "OK". Now that SSMs is set up, exit and log in with SA, success means that the SA account is enabled.

18. Start by configuring SQL Server Configuration Manager (SSCM), check the SQL Server service on the left, and make sure that SQL Server on the right and SQL Server browser are running.

20. Open the left SQL Server network configuration, open the protocol for your own DB instance name, and view the TCP/IP default on the right is disabled and modify it to Enabled.

22. Double-click to open TCP/IP to view the "all Listen" and "enabled" items in the Protocol tab under TCP/IP properties are set to Yes.

24. Select the IP addersses tab, IP1, IP2, Ipall set the TCP port to "1433", the TCP dynamic port is a null value, and is enabled as "Yes".

26. Also modify TCP/IP of the client protocol to Enabled.

28. Double-click to open TCP/IP on the right, open TCP/IP properties, set the default port to "1433", and enable "yes". When the configuration is complete, restart SQL Server 2008.

30. In the final step, you will need to map the SQL Server 1433 TCP port and the 1434 UDP port on the firewall.

    END

Precautions

• After SQL Server Express installation, remote connections are disabled by default. If remote access is required, manual configuration is required. Open the firewall settings. The SQLServr.exe (C:\Program Files\Microsoft SQL Server\mssql10. Sqlexpress\mssql\binn\sqlservr.exe) is added to the Allowed list. The article is based on the actual situation I used to conduct continuous testing and on-line search for relevant information to rectify. Because I use the CiscoASA5510 firewall, so in the configuration of the firewall once thought as long as 1433 of the TCP port mapping is possible, but the trial is unsuccessful. Finally, the data of the SQL Server network port is searched, and the UDP port of 1434 is mapped out, so it can be successfully connected in the Internet with SSMs.

SQL Server R2 open allow remote connections