June 1, 2005 at 11:31 pm
Hi,
I am not able to debug the stored procedure through query analyzer. My SQL Server as well as Agent is not running under system account. They are running under some user account & i connect to SQL Server through Query Analyzer with the same account & password.This account has got the Sys Admin permission & execute permission on the extended stored proc sp_sdidbug.
Even if i put the breakpoint it disappears & i cant get the debug cursor.
But procedure gets executed & i get the expected result set.
Please Help.
Thanks
June 2, 2005 at 2:07 am
I my setup my MSSQLSERVER and SQLSERVERAGENT account are running with a domain account with minimal permissions to the domain but in the Administrators group of the SQL Server.
Yes, I know that they shouldn't be in the administrators group but these are development machines and we do a lot that you don't do on a production server.
My understanding is that to get the debugger working you can't use a local account. Presumably because the debugger needs to pass information back and forth across the network.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply