Thursday, April 6, 2017

The EXECUTE permission was denied on the object 'sp_enable_sql_debug', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 300)

SQL Server 2008 R2/2012/2014/2016

Today a developer contacted me to get this error fixed. He was trying to debug the query from SSMS. When I tried to do that as a SYSADMIN I got the following error

To continue debugging, the firewall needs to be configured. 
Configuring the firewall requires elevated privileges.

To resolve the second error I had to login to the server and not try this remotely. But the first error still persisted for the a non privileged user.

Even after granting EXECUTE on that SP, the user was still complaining on that error. After some investigation I came to know that this is by design and only SYSADMINs can run the queries in debugging mode. This doesn't make sense to me but I guess I have no option. I am going to try this from Visual Studio and see if I can debug.

Following are some of the references for this info.

No comments:

Post a Comment