February 28, 2002 at 2:00 pm
Please help!!
Created a store proc. When tried to debugg It came back with and error message stating:
Server: Msg 514, Level 16, State 1, Procedure sp_sdidebug, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to communicate with debugger on DATA1 (Error = 0x80070005). Debugging disabled for connection 65.
It looks like is a permission issue, but I am using sa in a test environment and shouold have full permissions. Any suggestions?
Please help!!
February 28, 2002 at 2:12 pm
Do you get this message when in query analyzer and the stored proc window?
February 28, 2002 at 2:24 pm
Yes. That is where we are at when we got the error message. I did check the SQL Server Service account to check if the problem was permission at the Server level and not SQL Server. Gave the service account administrator rights the account did not have before. We tried to debug and got the same error. Thanks
February 28, 2002 at 3:21 pm
Have you rebooted and restarted? I thought this was the service account not having permissions.
Steve Jones
February 28, 2002 at 3:40 pm
Thanks Steve. I haven't have the chance to reboot that machine due to traffic. But I will do it in the morning to see if that solves the problem.
Thanks A LOT!!!!
A comment!!
This site has been my tutor, mentor, spin doctor, etc. Just to mention a couple and Ihave been a member for a few days now. I am very please, not really please amaze is the right word, with all the help received.
February 28, 2002 at 5:04 pm
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply