Prev: Metadata cleanup - Merge publication
Next: move backward in transaction log with usage of sp_repldone
From: Maer on 19 Aug 2009 09:40
We get an error when trying to subscribe saying that Management Studio
is unable to access replication components because replication is not
installed. However, replication is installed, and we did not have trouble
subscribing other machines. The additional information says:

The EXECUTE permission was denied on the object
'sp_MS_replication_installed', database 'mssqlsystemresource', schema 'sys'.
(Microsoft SQL Server, Error: 229)

We made sure that the user is a dbo on both the subscriber and publisher
and was also in the Publication Access List.

Is there anything else that I should be checking?

Thank you, Maer


 | 
Pages: 1
Prev: Metadata cleanup - Merge publication
Next: move backward in transaction log with usage of sp_repldone