Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET SQL-Server C#4.0 , +
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 Minute223.9K
v2
Comments
Henry Minute at 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 at 1-Mar-11 13:20pm
   
well here I am again writing the whole error message which I am getting while clicking run the query
 

CONFIGURE FIREWALL FOR REMOTE DEBUGGING
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 at 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
good
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
http://msdn.microsoft.com/en-us/library/cc646024.aspx[^]
  Permalink  
v2
Rate this: bad
good
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.
  Permalink  
Rate this: bad
good
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.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

THERE IS NO SOLUTION FOR THIS ONE
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 19 Aug 2011
Copyright © CodeProject, 1999-2014
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