Don't panic

 

Cry about...
SQL Server Troubleshooting


Merge Agent: Only members of the sysadmin or db_owner roles can perform this operation.


Symptom:

A merge agent has failed, the full error message text being:

Only members of the sysadmin or db_owner roles can perform this operation.

the last command may be recorded as:

{call sp_MSreplcheck_subscribe}

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: 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.