Post reply

tables not replicating & snapshot agent error

  • June 9, 2006 at 1:13 pm

    #172898

    have two tables that are not replicating (updating).  No one seems to know when this may have started.

    Lost replication when a disk was removed (mystery) & MSDB database became corrupted.  Also removed a publication that was no longer needed.  When I restored the MSDB database the publication appeared to have come back, when I tried remove it again it says it's not there and the subscription never cleanup up from the distributor.  Also notice that the snapshot agent is not working now.

    snapshot agent error:  SQL Server Enterprise manager could not start the snapshot agent.  Error 2203.......access denied

    Help

    Thanks

     

  • June 9, 2006 at 1:49 pm

    #642907

    are you using a domain account?

  • June 9, 2006 at 1:59 pm

    #642909

    Yes it is using a Domain account.....I was able to log on as sqlservice

    Thanks

  • June 21, 2006 at 10:16 am

    #645076

    Hi Wanda:

    Did you get your problem sorted, Wanda? I am having the same problem - just one table is not replicating in a merge replication scenario, and I would be grateful for any help

    Thanks

    Miles

  • June 22, 2006 at 3:24 am

    #645209

    Hi Miles,

    I am replicating in a transactional replication scenario.  I recreated the publication and removed it again which cleared things up.  As for the tables not replicating I'm not convinced that was not a user issue.  I did change the time on my queue reader from ever 1 hour to 5, then 15 minutes.  Everyone seems to be happy so far.

    A lot of this has been a learning process for me, this is something that was set up by someone else and passed on to me.

    Good Luck!

     

     

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply