The Execute permission was denied on the object sp_enable_sql_debug

I got the error like this...

Solution:

1. Select Server role : Public,Server Admin,Sys Admin

Now try to debug it will be work.

Result: