• All Community
    • All Community
    • Forums
    • Ideas
    • Blogs
Advanced

Not what you are looking for? Ask the experts!

Kudos0

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?

Replies

Kudos0

Re: 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?

Kudos0

Re: SQL Server

Hi,

I used many Norton versions with SQL 2008 Exp., but never saw this error.

Can you please try what happens if you temporarly disable the firewall:

1. Disconnect from the internet

2. Right click on the Norton icon by the system clock

3. Disable Smart Firewall

4. Set time duration

5. Run the SQL script

Does it now runs OK?

Windows 10 Hungarian, Norton Internet Security v22.9.0.71
Kudos0

Re: SQL Server

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.

Kudos0

Re: SQL Server

Did you tried to add a firewall rule to open the ports you need for the debugging?

1. Open Norton 360.

2. Click on Settings.

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 settings15. Click OK / Apply and close Settings.

Let us know the results.
Windows 10 Hungarian, Norton Internet Security v22.9.0.71
Kudos0

Re: SQL Server

Thank you but do you have more specific instructions as it relates to the error message and SQL Server?

Kudos0

Re: SQL Server

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.

Windows 10 Hungarian, Norton Internet Security v22.9.0.71
Kudos0

Re: SQL Server

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.

Kudos0

Re: SQL Server


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.

Windows 10 Hungarian, Norton Internet Security v22.9.0.71
Kudos0

Re: SQL Server

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.

Kudos0

Re: SQL Server

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

This thread is closed from further comment. Please visit the forum to start a new thread.