Cannot execute queries from Management Studio

  • 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

  • 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]

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

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

    Solution please ?

  • 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/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply