Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Merge Replication

Author  Topic 

GlobalArchitect
Starting Member

1 Post

Posted - 2010-09-06 : 19:36:04
I think I might have a security issue in setting up my Merge Replication but it is not working and I was hoping to get some clarification. I set up a Publication and then went to the Subscriber and set up a Pull Subscription using a local Windows account with the correct access level. For connecting to the Publisher, I used a Windows account local to that server with the same security level.

However, I am now getting the following error:

The schema script 'Table1.sch' could not be propogated to the subscriber.

Do I need to drop the tables from the subscriber that I am using as articles in the Publication? I thought that would not matter but it is clearly causing issues.

I had setup a prior Transactional Replication using the same articles but I deleted that Publication and Subscription in favor of a Merge Replication. Now that replication is not working.

Any ideas?

Thanks
   

- Advertisement -