About SQL Sever firewall configuration issues: Remote debugging requires DCOM (TCP port 135) and IPESC (UDP port 4500/500)

Beginners SQL SEVER 2008, the results of the first debugging this problem arises:

And then

Baidu a bit, the meaning of these three options:

1. Cancel remote debugging: Cancels the attempt to start debugging. Your computer's security settings remain the same.
2. Suppress restrictions on remote debugging from computers in the local network (subnet): Enables remote debugging of computers on the local subnet. This setting may expose a security vulnerability on your local subnet computer, but the firewall will continue to block information from outside the subnet.
3. Suppress restrictions on remote debugging from any computer (A): Enable remote debugging of computers anywhere on the network. This setting is the least secure.

In combination with the hint, there is no doubt that the Windows Firewall configuration has a problem, the port may be closed.

Solution:

• Add TCP port 135 to the Exceptions list.
• Add the program Sqlservr.exe to the Exceptions list. By default, Sqlservr.exe is installed in C:\Program Files\Microsoft SQL Server\mssql10. (*) Mssql\Binn, where, (*) for the default instance is MSSQLSERVER, The name of the corresponding instance for any specified instance.
• If the domain policy requires network communication over IPSEC, UDP port 4500 and UDP port 500 must also be added to the exception list.

Operation:

TCP Port 135:

UDP Port 4500,500:

Specify conditions: Allow connections, select the domain and private (not recommended for public selection) after selecting.

Finally add two rules, enable:

Note that there are no restriction rules to check: I do not have to check the drum for a half-day and do not know where the wrong--------------------------------!

Disable your restriction rule, or delete it.

Then add your program:

By default, Sqlservr.exe is installed in C:\Program Files\Microsoft SQL Server\mssql10. (*) Mssql\Binn, where, (*) for the default instance is MSSQLSERVER, The name of the corresponding instance for any specified instance.

Add just fine.

There are times when online answers can help you solve problems directly, but more often than not, he just gives you a suggestion. You need to combine your actual situation to find your own problem, after all, his computer is not your computer, the situation is not the same.

About SQL Sever firewall configuration issues: Remote debugging requires DCOM (TCP port 135) and IPESC (UDP port 4500/500)