This morning I found this error when trying to debug a stored procedure from Visual Studio 2005:
User ‘dbo’ could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’
After googling a bit, I found that to solve this problem, the user accessing the DB must be part of the sysadmin server roles. To add a user to this role: (click more for the steps)
- Right Click On user under Security in the database
- Select Properties
- Select Server Roles
- Check the sysadmin role
This must be done from the Main security tab (Server Security), not from the Security tab under a particular database.