Could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’

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.

Advertisements

2 Responses to “Could not execute stored procedure ‘master.dbo.sp_enable_sql_debug’”

  1. Visual Studio | No source code available for the current location « Clive Ciappara | Windows | iPhone | .Net Says:

    […] First you have to make sure that the current user is part of the ‘sysadmin’ Server role (click here for how to). […]

  2. Visual Studio | No source code available for the current location | Clive Ciappara - Developer for Apps & Websites Says:

    […] First you have to make sure that the current user is part of the ‘sysadmin’ Server role (click here for how to). […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: