Cannot execute queries from Management Studio

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Cannot execute queries from Management Studio...

Cannot execute queries from Management Studio

Rate Topic

Display Mode

Topic Options

Author

Message

lev.gurevich

Posted Wednesday, February 16, 2011 9:08 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 8:59 AM
Points: 13, Visits: 37

Hi,

I've installed SQL Server Management Studio 2008 on my Windows XP PC.

After I connected a SQL Server on a remote machine and tried to execute ANY query from the Query window, it failed with the message:

"Unable to start T-SQL Debugging. Could not attach to SQL Server process 'on <my SQL Server'. The RPC server is unavailable".

As per the article "Configuring the Transact-SQL Debugger" http://msdn.microsoft.com/en-us/library/cc646024.aspx I checked
the firewall on my PC. It was disabled. But the error still occured.

My co-worker managed to execute queries from Management Studio 2008 installed on his PC by connecting the same server that I did.

How can I fix the problem? I did not want to debug queries, just to execute them.

Thanks, Lev

Post #1065074

mazzz

Posted Wednesday, February 16, 2011 10:22 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 15, 2012 4:11 AM
Points: 408, Visits: 2,661

Were you clicking on the green "play" button? That will try to start debugging. Instead use the Execute button with the red exclamation point, or hit F5 on your keyboard

------------------------------------------------------------------------
Bite-sized fiction (with added teeth)

Post #1065124

lev.gurevich

Posted Wednesday, February 16, 2011 11:02 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 8:59 AM
Points: 13, Visits: 37

Thank you very much! It works when I click the Execute or F5 butons but fails for Debug.

Post #1065145

Paul Beetge

Posted Tuesday, September 20, 2011 7:08 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 18, 2012 8:03 AM
Points: 9, Visits: 130

Then it's still not working correctly. It should be able to debug.

Solution please ?

Post #1177877

NJ-DBA

Posted Tuesday, September 20, 2011 9:51 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 12:36 PM
Points: 858, Visits: 1,332

Paul Beetge (9/20/2011)

Then it's still not working correctly. It should be able to debug.

Solution please ?

His question was answered- he said he "did not want to debug, just execute...

that said, could be a few different reasons for the error debugging, the most likely cause is the lack of necessary permissions Connecting with system administrator to SQL Server is not sufficient; the Windows login of the Visual Studio user must also be a member of the system administrator role in SQL Server.

If you are having a problem debugging, I'd have a look here: http://social.msdn.microsoft.com/forums/en-US/vsdebug/thread/7937b123-5ffd-48f6-a1de-03e613466a2b/

Post #1178010

« Prev Topic | Next Topic »

Permissions