Home All Groups Group Topic Archive Search About

Re: Remote SP debugging from VS 2003: error

Author
18 Jan 2006 4:45 AM
test
I 'm still getting the error:

"Cannot debug stored procedures because the SQL Server database is not setup
correctly or user does not have permission to execute master.sp_sdidebug."

I have configured DCOM on the remote sql server according tothe MSDN
article.
I have added SQLDebugger account  to default permissions in dcom.

I have also given full access to Master DB for the user
SQLDebugger and all stored procedures full access.

Does anybody have any idea why is it still giving the above error.

TIA
TS

AddThis Social Bookmark Button