0

I put a breakpoint somewhere in a stored procedure in SQL Server Management Studio and then press start debugger. I end up getting

Error 229 error (failed to start debugger)

It appears to be a problem with permission, and I tried to ask the DB admin to execute 

grant execute on sp_enable_sql_debug to my_login_name

command, but the syntax of the command is erroneous. Any ideas ?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Edgar Navasardyan
  • 4,261
  • 8
  • 58
  • 121
  • I read somewhere, the minimum security requirement for debugging is sysadmin (Windows Server Role, not db). Try that. – Deep Kalra Jan 13 '16 at 08:10

1 Answers1

3

Simple thing to over come this error. Go for sql server db and select security and click on login. In that u can see your login name . Right click on it and click properties . In the left screen u can see the role in that u want check public and sysadmin . Now restart your db and visual studio. Now it work fine and i have clearly explained

Aravindhan R
  • 270
  • 5
  • 26