Enable SQL Server 2008 remote connections under Windows server2008 R2

First of all, this article is transferred from the Internet.

TMD spent two days, finally found how to open this remote connection ..... Niang, exhausted, write down, hope to help our fellow citizens ...

With the WIN server R2 and SQL Server 2008 platform, SQL 2008 cannot connect remotely, the solution is as follows:

1. Enable TCPIP for SQL 2008 server. Open the Server Configuration Tool SSCM, click the protocol under SQL Server network configuration, where the instance name of the server is listed, and on the right double-click TCPIP, enabling the option to select Yes.

2. In "IP Address", select the following "Ipall" To configure the TCP port to 1433, or it can be a different port.

3. Open SSMs, right-click on the instance name of the database server, select Facet, and in the Facet drop-down list, select surface area configurator to set remotedacenabled to true.

4. Open the System firewall, click Advanced Settings, select Inbound Rules, click New rule on the right, select program, Next, select C:\Program Files\Microsoft SQL Server\mssql10_50.sql8\ Mssql\binn\sqlservr.exe, Next, select "Allow connection" and complete after the next step.

5. Repeat the fourth step, this time select the program file "C:\Program Files\Microsoft SQL Server\90\shared\sqlbrowser.exe".

Complete. You can connect to the server remotely.

6. Remember that the Server service is opening the SQL service and SQLBrowser services.