SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cannot execute queries from Management Studio


Cannot execute queries from Management Studio

Author
Message
lev.gurevich
lev.gurevich
SSC Journeyman
SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)

Group: General Forum Members
Points: 81 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
mazzz
mazzz
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1509 Visits: 2661
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)
lev.gurevich
lev.gurevich
SSC Journeyman
SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)SSC Journeyman (81 reputation)

Group: General Forum Members
Points: 81 Visits: 37
Thank you very much! It works when I click the Execute or F5 butons but fails for Debug.
Paul Beetge
Paul Beetge
SSC Journeyman
SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)SSC Journeyman (75 reputation)

Group: General Forum Members
Points: 75 Visits: 130
Then it's still not working correctly. It should be able to debug.

Solution please ?
NJ-DBA
NJ-DBA
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3270 Visits: 1556
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/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search