H-SC
asked on
You do not have permission to run 'SP_TRACE_GENERATEEVENT'.
Hello,
I have set up sql replication on sql 2012 and when I run synchronization, I get the following message:
You do not have permission to run 'SP_TRACE_GENERATEEVENT'.
I am running the replication under user repl_merge as Microsoft recommends and have given alter_trace permissions to the user but I am still getting this message.
What other users do I need to grant alter_trace to for replication to work.
Also, I am aware this error is a known issue from Microsoft, but I need a work around.
I have set up sql replication on sql 2012 and when I run synchronization, I get the following message:
You do not have permission to run 'SP_TRACE_GENERATEEVENT'.
I am running the replication under user repl_merge as Microsoft recommends and have given alter_trace permissions to the user but I am still getting this message.
What other users do I need to grant alter_trace to for replication to work.
Also, I am aware this error is a known issue from Microsoft, but I need a work around.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All,
Many thanks for the input. I am aware that this is an open issue with Microsoft and hopefully it will get resolved. I tried granting sysadmin to repl_merge user and even all of the users associated with the repl process. I looked at the repl_user that is associated with the jobs that run and that user has alter_trace. The only way I am able to work around this issue is to remove any article that has the needed alter_trace delete event and re add it when I make changes to the articles themselves, which is not much, just on occasion.
Many thanks for the input. I am aware that this is an open issue with Microsoft and hopefully it will get resolved. I tried granting sysadmin to repl_merge user and even all of the users associated with the repl process. I looked at the repl_user that is associated with the jobs that run and that user has alter_trace. The only way I am able to work around this issue is to remove any article that has the needed alter_trace delete event and re add it when I make changes to the articles themselves, which is not much, just on occasion.
Looks like you'll need to give ALTER TRACE permission to the user.