Cannot execute queries from Management Studio

• lev.gurevich

  Say Hey Kid

  Points: 683

  More actions

  February 16, 2011 at 9:08 am

  #233786

  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

• mazzz

  SSCertifiable

  Points: 6139

  More actions

  February 16, 2011 at 10:22 am

  #1287787

  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) [/url]

• lev.gurevich

  Say Hey Kid

  Points: 683

  More actions

  February 16, 2011 at 11:02 am

  #1287804

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

• Paul Beetge

  Old Hand

  Points: 397

  More actions

  September 20, 2011 at 7:08 am

  #1383827

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

  Solution please ?

• NJ-DBA

  SSChampion

  Points: 13834

  More actions

  September 20, 2011 at 9:51 am

  #1383944

  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/