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 2000 Forums  Import/Export (DTS) and Replication (2000)  help with merge pull subscription

Author  Topic  jake99 Starting Member 4 Posts Posted - 2004-10-18 : 19:21:35 Hello, I am trying to setup merge replication with a pull subscription. I have the merge replication running fine. When trying to setup pull subscription I cannot see the publicated db in the EM GUI. This is over a non-trusted domain and have followed the instructions on http://support.microsoft.com/default.aspx?kbid=321822. If I change the publisher to allow anonymous access the database shows up in the GUI. The publisher is setup to use sql authentication with the user "replicationserver" (This is on PAL also). replicationserver can gain access via EM and QA on the subscriber side. Any help would be appreciated. 1. In SQL Enterprise Manager from the Publisher, on the Tools menu, point to Replication, and then click Configure Publishing, Subscribers, and Distribution. Note Because the Subscriber is not configured for the distributor, the Configure Publishing, Subscribers, and Distribution options are not available for the Subscriber. 2. Click the Publishers tab. 3. Click the Publisher, and then click the Properties (...) button. 4. Click the General tab, click Using SQL server authentication of this account to specify that the replication agents use SQL Server Authentication, and then specify an account that has sufficient permissions in the publishing database.