Cry
about...
SQL Server Troubleshooting
Merge Agent: The Subscription to
publication 'XXXX' is invalid
Symptom:
A merge agent has failed. The last
action is:
The subscription to publication
'XXXX' is invalid.
where XXXX is the name of the
publication that is (or should be) participating in merge
replication. The full error message is:
The remote server is not
defined as a subscription server.
This has the error number 14010
associated with it.
Possible Cause and Remedy:
This error has been observed when the
remote server had been renamed after the original
installation of SQL Server, and where the SQL Server
configuration function @@SERVERNAME
still returned the original name of the server. If this
is the case then follow the notes in the link SQLServer Enterprise Manager could
not configure 'server' as the Distributor for 'server'.
|