Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cannot execute queries from Management Studio Expand / Collapse
Author
Message
Posted Wednesday, February 16, 2011 9:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, February 16, 2011 10:22 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-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
Posted Wednesday, February 16, 2011 11:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, September 20, 2011 7:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, September 20, 2011 9:51 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 6:32 AM
Points: 883, Visits: 1,410
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 »

Add to briefcase

Permissions Expand / Collapse