Click here to Skip to main content
11,935,053 members (54,209 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL-Server , +
I want to know that how can we run or debug the query in SQL SERVER management studio. Well I can execute the query but when I click on the run button the error which is displayed is regarding the connectivity and firewall issue.

It shows that unable to run T SQL debug. Cannot connect to the computer local.

Could anybody please help me out in resolving this problem.
Posted 28-Feb-11 11:19am
Edited 28-Feb-11 13:49pm
Henry Minute224.8K
Henry Minute 28-Feb-11 18:50pm
If you copy the text of the error and paste it into your favourite search engine, you are more likely to find a solution than you are from the information you have provided here.
udhave jajoo 1-Mar-11 13:20pm
well here I am again writing the whole error message which I am getting while clicking run the query

The Windows Firewall on this machine is currently 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
Gives me three options
o Cancel remote debugging
o Unblock remote debugging from computers on the local network (subnet)
o Unblock remote debugging from any computer

When I select any one option it shows me another error
Could not configure the WINDOWS FIREWALL .Cannot add a port to the Windows Firewall exception list. Use the control panel to manually configure the Windows Firewall.

Please provide me the required guidelines
jbraanen 24-Mar-11 6:29am
I get the same messagebox. It happens if I click "Execute", and there is something wrong with the query. I have the database on the same machine I am developing on.
Rate this: bad
Please Sign up or sign in to vote.

Solution 4

You must configure Windows Firewall exceptions to enable Transact-SQL debugging when connected to an instance of the Database Engine that is running on a different computer than the Database Engine Query Editor.
Source MSDN[^]
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

My guess is that you are connecting to a remote server and that Management Studio is unable to debug on anything but a local database. Try debugging against a local database instead.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Please check if you have enough previleges to do that.Your database admin might have set some restrictions.
Rate this: bad
Please Sign up or sign in to vote.

Solution 3


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web04 | 2.8.151126.1 | Last Updated 19 Aug 2011
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100