February 16, 2011 at 9:08 am
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
February 16, 2011 at 10:22 am
February 16, 2011 at 11:02 am
Thank you very much! It works when I click the Execute or F5 butons but fails for Debug.
September 20, 2011 at 7:08 am
Then it's still not working correctly. It should be able to debug.
Solution please ?
September 20, 2011 at 9:51 am
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