SQL Server R2 Open Database remote connection

To test A. NET system today ~ because the configured database is SQL server~ I have to install SQL Server r2~ Now let's take a look at how SQL Server R2 opens remote connection port 1433. In fact, to open the SQL Server remote connection ~ mainly through the SQL Server Configuration Manager program settings can be, its Chinese name is SQL Server Configuration Manager.

Version: 2009.0100.4000.00

Step: 1, SQL Server Configuration Manager, configuration tools, Microsoft SQL Server R2

2. TCP/IP (double-click), protocol, SQLEXPRESS, SQL Server network configuration, SQL Server Configuration Manager (local)

3. TCP port 1433 on IP all---IP address

　　

4. SQL Server service->sql server restart.

5. Use the CMD Command window to test the port opening situation. You can use the Netstat, telnet command to test.

　　

Several issues to be aware of:

1. Multiple tutorials on the Web open several options ~ such as IP1, IP2 TCP port, enabled state, etc.

2, SQL Native Client 10.0 configuration->TCP/IP disabled also does not matter.

After I tested those that didn't work at all ~ Set IP all-TCP port 1433~ on the line ~ am I encountering a version problem?

SQL Server R2 Open Database remote connection