SQL Server Performance Forum – Threads Archive

Merge Replication – Uninitialized Subscription

I have created a Merge Subscription between two databases. I have set the security setting in the UNC folder of the publisher to allow ‘Full Control’ for ‘Everyone’. I have done various searches, google, here, etc. But cant seem to find much information to help me out. When I create the subscription it says it was a success, but when I launch the replication monitor and click the publication it says its subscribers are uninitialized. Can anyone help?

does ur subscriber have all the schemas and data which you are trying to replicate. also, can u please paste the exact error —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

See this BOLhttp://msdn2.microsoft.com/en-us/library/ms143470.aspx link too. Ensure you have applied relevant privileges to replication agent and as referred by Dinesh it would be better if you come up with an error description. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Egg on my face!! Forgot I had Stopped the SQL Server Agent Service on the subscriber, very stupid. I appreciate the help guys [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]

LOL [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] in any case if you would have posted the error it will fetch better case. But on the other side if you have set the SQLAgent to start immediately in case it stopped, that will have saved the issue. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

]]>