Q:
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:
Oct 12 2009 9:39 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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 files\Microsoft SQL Server\90\com\ 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.
