Adding new subscription to SQL Server 2005s Local Subscriptions fails...

Hi everyone,

I am trying to add a new subscription to the local subscriptions of a SQL Server 2005. As soon as I click on SERVER_NAME -> Replication -> Local Replications -> New Subscription, I get the following error message:

TITLE: New Subscription Wizard
Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=ReplicationNotInstalled&LinkId=20476
ADDITIONAL INFORMATION:

Die EXECUTE-Berechtigung wurde für das 'sp_MS_replication_installed'-Objekt, 'mssqlsystemresource'-Datenbank, 'sys'-Schema verweigert. (Microsoft SQL Server, Error: 229)
Translated from German to english:
EXECUTE-Permission for the 'sp_MS_replication_installed'-Object, 'mssqlsystemresource'-Database, 'sys'-Schema denied. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
BUTTONS:

OK

Btw, I am using the SQL Server Management Studio.
Thanks,
Olcay

From the error message, it appears that the replication components are not installed on the machine. Can you install the components and try again?|||

Hi Mahesh,

they are installed. Could this be a rights related issue?

Thanks,
Olcay

|||

Yes, it is then a permissions related issue.

What user is trying to create the subscription? This user should be the dbo of the subscrber database and atleast PAL (publication access list) user on the publication and publisher database.