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.
https://connect.microsoft.com/SQLServer/feedback/details/351698/msit-mso-debugging-sql-query-fails-with-an-error-the-execute-permission-was-denied-on-the-object-sp-enable-sql-debug
https://msdn.microsoft.com/en-us/library/w1bhybwz(VS.80).aspx
http://www.sqlserver-dba.com/2012/09/sql-server-user-could-not-execute-stored-procedure-sp_enable_sql_debug.html
No comments:
Post a Comment