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.