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

When debugging stored procedures, the debug process fails if a SQL Server login user does not have Execute permission granted to the extended stored procedure sp_sdidebug in the master database.

To debug stored procedures, you need to have appropriate user permissions to execute the extended stored procedure sp_sdidebug. The default access is for system administrators only.

This error can also occur if the SQL Server database debugging software (both server-side and client-side) is not setup correctly.

To correct this error

1. Ask the database administrator for permissions to run the extended stored procedure sp_sdidebug.

See Also

Other Resources

How to: Enable SQL Server 2005 Debugging
How to: Set SQL Server Permissions for Debugging

Help and Information

Getting SQL Server 2008 Assistance