i am using SQL Express 2008 and the Management Studio. When I try to do a query or anything really I get an error message:
The Windows Firewall on this machine is currently blocking remote debugging. Remote debugging requires that the debugger be allowed to receive information from the network. Remote debugging also requires DCOM (TCP Port 135) and IPSEC (UDP 4500/ UDP 500).
One of the options is to Unlock remote debugging but when I select it can't proceed and displays another error message telling me that it cannot configure the Windows Firewall. The Windows Firewall is turned off since Norton is working it its place. I tried working in SQL Server with Norton turned completely off, yet I get the same result. Yet I know that it can't be the Windows Firewall.
Does anyone here have experience with using SQL Server and getting it to work with Norton? What should I do make it work?
I can run the query (red exclamation point) but I cannot debug it (looks like a green play icon). When I try to debug, I get the Configure Firewall message specified in the first post. I can only back out of this error message by selecting "Disable Remote Debugging". Disabling the firewall, as specified in the previous, does not prevent this from occuring.
Did you tried to add a firewall rule to open the ports you need for the debugging?
3. Go to Firewall Settings.
4. Go to Traffic rules tab
5. Click on the Add button.
6. In the Add Rule wizard, select Allow, click Next.
7. Select the type of connection that the rule should monitor, and then click Next.
8. Select the computers that the rule should monitor, and then click Next.
9. Select the protocols that the rule should monitor.
10. Select the ports that the rule should monitor, and then click Next.
11. If you want the logs for this rule to be saved, check Create an event log entry, and then click Next.
12. In the "What do you want to call this rule?" box, type a name for the rule, and then click Next.
13. Review the new rule settings, and if they are correct, click Finish.
14. Click Move Up to move the rule to top, and make it a higher priority than default settings
15. Click OK / Apply and close Settings.
Let us know the results.
Thank you but do you have more specific instructions as it relates to the error message and SQL Server?
i am using SQL Express 2008 and the Management Studio. When I try to do a query or anything really I get an error message:
The Windows Firewall on this machine is currently blocking remote debugging. Remote debugging requires that the debugger be allowed to receive information from the network. Remote debugging also requires DCOM (TCP Port 135) and IPSEC (UDP 4500/ UDP 500).
One of the options is to Unlock remote debugging but when I select it can't proceed and displays another error message telling me that it cannot configure the Windows Firewall. The Windows Firewall is turned off since Norton is working it its place. I tried working in SQL Server with Norton turned completely off, yet I get the same result. Yet I know that it can't be the Windows Firewall.
Does anyone here have experience with using SQL Server and getting it to work with Norton? What should I do make it work?
By step 10 you should add manually these ports: Remote debugging also requires DCOM (TCP Port 135) and IPSEC (UDP 4500/ UDP 500). All 3 of them.
I am having the same problem.
As per this link:
http://msdn.microsoft.com/en-us/library/ee126350.aspx
I have manually added ports 135 and the two UDP ones.
Symantec seems to indicate that it is controlling exceptions rather than the firewall itself, so I added devenv.exe to Centralized Exceptions in Symantec Endpoint Protection, but I still have original problem.
I have Windows 7 Ultimate 64bit, Symantec Enpoint Protection, and am trying to run a SQL Server 2008 R2 query for the first time.
jayfis wrote:
I am having the same problem.
As per this link:
http://msdn.microsoft.com/en-us/library/ee126350.aspx
I have manually added ports 135 and the two UDP ones.
Symantec seems to indicate that it is controlling exceptions rather than the firewall itself, so I added devenv.exe to Centralized Exceptions in Symantec Endpoint Protection, but I still have original problem.
I have Windows 7 Ultimate 64bit, Symantec Enpoint Protection, and am trying to run a SQL Server 2008 R2 query for the first time.
Try to add the sql server execautable as well: sqlsrvr.exe (or what is it called :P). It's located in program files\sql server\MSSQL$instance_name\Binn.
I added the Sql Server executable, and also ssms.exe for the sql server management system. But same problem.
"The Windows Firewall on this machine is currently blocking remote debugging. Remote debugging requires that the debugger be allowed to receive information from the network. Remote debugging also requires DCOM (TCP Port 135) and IPSEC (UDP 4500 / UDP 500) be unblocked. What would you like to do? 1) Cancel remote debugging 2) Unblock remote debugging from computers on the local network (subnet) 3) Unblock remote debugging from any computer"
Please advise. Thanks.
Aaronicus,
Which operating system you use?
Did you check the information provided in the following link?
http://support.microsoft.com/kb/833977
Jayfis,
This forum is for consumer products. Since you are you using Symantec Endpoint Protection, if you can post the same in the forum for Symantec Business Products, you may get more feedback.
Yogesh