SQL Server Performance

Merge Replication - Uninitialized Subscription

Discussion in 'SQL Server 2005 Replication' started by terbs, May 7, 2007.

  1. terbs New Member

    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?
  2. dineshasanka Moderator

    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/
  3. satya Moderator

    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.
  4. terbs New Member

    Egg on my face!!<br /><br />Forgot I had Stopped the SQL Server Agent Service on the subscriber, very stupid.<br /><br />I appreciate the help guys [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
  5. satya Moderator

    LOL [<img src='/community/emoticons/emotion-2.gif' alt=':D' />] in any case if you would have posted the error it will fetch better case.<br /><br />But on the other side if you have set the SQLAgent to start immediately in case it stopped, that will have saved the issue.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>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.</i></font id="size1"></font id="teal"></center>

Share This Page