November 8, 2008 at 4:03 am
Hi
Merge Replication. while running push subscription the follwing error is display and automatically merge agent was down, so how to resolve this issues, please can anyone help me.
The schema script '\\WJMN0130136\C$\Program Files\Microsoft SQL Server\MSSQL$REPLICAT\ReplData\unc\WJMN0130136$REPLICAT_HRMS_HRMS\20081108160439\CTC_Details_1.sch' could not be propagated to the subscriber.
Thanks
November 8, 2008 at 10:40 am
Hi Ananda,
That's a generic error message and quite impossible to tell what is going on. Can you
- provide the exact steps you are taking to apply the snapshot
- turn on Verbose logging for the Merge Agent
- tell us where the agent is running (Pull or Push subsription)
- the security settings for the agent (which account is used)
If all fails; you can always choose to apply the snapshot via backup instead.
HTH!
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 9, 2008 at 9:54 pm
Hi Elisabeth,
Thanks for reply me.
- provide the exact steps you are taking to apply the snapshot
Snapshot agent 420 article was generated, it was working successfully.
- turn on Verbose logging for the Merge Agent
This merge agent is running on system default profile. i think system default profile we can not modify, so please tell me how to turn on verbose logging?
- tell us where the agent is running (Pull or Push subsription)
this we can configured Push subscription in publisher.
- the security settings for the agent (which account is used)
Sql server service and agents are running same account name with password
Thanks
ananda
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply