Configure the Windows R2 Firewall to allow remote access to SQL Server R2

1. Modify the port number of SQL Server 2008r2 first, 1433 often become the ports that others invade, in SQL Server Configuration Manager--"SQL Server network Configuration-" MSSQLSERVER protocol, put the TCP/IP-IP address Change the port number to 2433 and restart the SQL Server service (MSSQLSERVER)

2. Run firewall.cpl--Open Firewall--Advanced settings--inbound rules--New rule--Select program--Location C:\Program Files\Microsoft SQL Server\mssql.1\mssql\binn\ Sqlservr.exe (If you can't find the program path can be found in the service details), so you can

3. Connect to the database with IP, port number, such as 192.168.1.100,2433, note the port and IP is a comma.

Configure the Windows R2 Firewall to allow remote access to SQL Server R2