February 14, 2006 at 9:53 pm
Problem Statement: I am trying to create a Merge Replication on One SQL Server and Pushing data through Push Subscription to another SQL Server.
Both SQL Servers are on Real Static IP. The Publication and Subscription are created successfully. But when the replication starts, Error is generated “Cannot propagate the snap shot to the subscriber”. On Viewing the error detail, it is revealed that the error is “Cannot Insert Null values in Column”
Operating Systems: Windows 2000 Server on Both Computers with SQL Server 2000 on both computers.
IP Configuration: One Servers on Real IP and not accessible through LAN. Another Server also on Real IP but can also be accessible through LAN.
SQL Server Configuration: Both Servers on Mixed Mode Authentication (Windows and SQL Server). Server 2 is marked enabled as subscriber in Server 1 (where Publication and Subscription is made). Server 1 is marked enabled as Publisher in Server 2. The database is marked allowed for publication.
The rest of the settings are over Default.
At the end the error as mentioned in problem statement is generated.
February 15, 2006 at 1:25 am
Hi,
Do you know at what point this error occurs?
Is it right at the beginning?
Graeme
February 15, 2006 at 2:59 am
Yes... initially the replication starts and I have also witnessed the status as ruuning some script files. But after running few script files, error is shown as mentioned in Problem Statement.
Thanks
February 16, 2006 at 3:05 pm
Make sure that the logon account for the SQLServerAgent on the Publisher has access to the subscriber database.
Mark
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply