How to RUN QUERY IN SQL SERVER MANAGEMENT STUDIO

Question

0.00/5 (No votes)

See more:

, +

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 10:19am

udhave jajoo

Updated 28-Feb-11 12:49pm

Henry Minute

v2

Add a Solution

Comments

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

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 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.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

NDebata · Answer 1 · 2011-08-18T22:36:00

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[^]

Posted 18-Aug-11 22:36pm

NDebata

Updated 18-Aug-11 23:38pm

v2

AspDotNetDev · Answer 2 · 2011-02-28T12:52:00

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.

Posted 28-Feb-11 12:52pm

AspDotNetDev

Anupama Roy · Answer 3 · 2011-03-04T07:16:00

Solution 2

Please check if you have enough previleges to do that.Your database admin might have set some restrictions.

Posted 4-Mar-11 7:16am

Anupama Roy

SAISAGAR nalla · Answer 4 · 2011-08-18T22:16:00

Solution 3

THERE IS NO SOLUTION FOR THIS ONE

Posted 18-Aug-11 22:16pm

SAISAGAR nalla