Open SQL Server 2008 1433 port in Windows server

The Microsofit SQL Server2008 R2 was deployed on the Windows Server2008 server, and for the remote machine to be accessible, the 1433 port was opened with the following settings:

1. Open "Local Security Policy", set the IP Security policy, add the Allow TCP-1433 policy

2. Added inbound rules in "Windows Firewall with Advanced Security" tcp-mssql-1433-in

Then, enter the IP and 1433 port scans in the http://tool.chinaz.com/port/, and the display port is off.

Finally, a solution was found on the Web:

3. Change the TCP port in Ipall of the TCP/IP protocol of the corresponding DB instance of SQL Server Configuration Manager to 1433.

Problem solving:

1, 1433 port can be scanned;

2. The remote machine can access the database on the server.

Thanks.end.

Open SQL Server 2008 1433 port in Windows server