SQL Server Troubleshooting
Merge Agent: Only members of the sysadmin or db_owner roles can perform
A merge agent has failed, the full error message text being:
Only members of the sysadmin or db_owner roles can perform
the last command may be recorded as:
Cause and Remedy:
This error is identical in cause and remedy to the same error produced
by the Distribution Agent: 'Only members
of the sysadmin or db_owner roles can perform this operation'. For the
cause and remedy please refer to the notes relating to that problem.
These notes are believed to be correct for SQL
Server 7 and may apply to other versions as well.
About the author: Brian Cryer
is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.