MS SQL Server - Error during initialization of replication publisher !

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Error during initialization of replication publisher !

Tim Greenwood

2006-12-12, 7:12 pm

I have a server I've set up a push subscription on. It successfully
created the publisher end but when I add a subscriber it gets this error:

Cannot find the user 'DataDeveloperAccess
', because it does not exist or you
do not have permission.

DataDeveloperAccess is a Database role I've created in each of our
databases. It definitely exists on the publication server which seems to be
the one complaining. It doesn't exist on the subscriber yet as it hasn't
completed the initialization process and loaded the initial snapshot before
getting this error.

Any ideas on what could cause this? I'm like really stuck here. I have NOT
been having a good experience with replication so far.

Thanks!

Sponsored Links