User has not permission to run “sp_enable_sql_debug” stored procedure in mssqlsystemresource database. If you are database admin then you need to give permission to the user performing the execution like below.
GRANT EXECUTE ON [dbo].[sp_enable_sql_debug] TO [UserYY]
Change [UserYY] with your user.
Check more instruction here.
You can also use other method by create a new database role
19 People are following this question.