Trying to setup a Merge publication between two database Need Help!
HI I am trying to setup a Merge publication between two database and I am having troubles. I have to server one is HKDD01 and LDDD01 and the HKDD01 is set as the distribution and the LDDD01 is set as the subscriptions. I am trying to create a Merge publication with pull subscription and I am getting a error "The schema script '' could not be propagated to the subscriber." not sure what I am doing wrong. If anyone knows how to setup a Merge publication please give me some hit or point me to a website with step by step guide that would be the best thanks.
Software/Hardware used:
Windows 2003 & SQL Server 2005 w/SP2
Software/Hardware used:
Windows 2003 & SQL Server 2005 w/SP2
ASKED:
October 12, 2009 9:39 AM
UPDATED:
October 13, 2009 1:51 AM
RELATED QUESTIONS
Answer Wiki:
All you should need to do is run though the wizards to get everything setup. Are they the same version of SQL Server?
Try running the merge agent from a command line on the subscriber and see what the specific error is. To do this edit the SQL Agent Job on the subscriber which is the merge agent. Copy the text from step two. Open a command window and navigate to the folder with the merge.exe in it. It should be c:program filesMicrosoft SQL Server90com by default. Type in merge.exe a space and then paste in the text that you copied from the agent. Press enter and see what comes up.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
