Post reply

snapshot agent is not running

  • May 19, 2013 at 11:41 am

    #394802

    Hi,

    Friends I am working on sql server 2008 r2 and I want to replicate data by using snapshot replication, when i create subscription and publication after being successful, my data didnot distributed to the table. when i check for problem, i found that my snapshot agent is not running on the subscription side, what should i do?

  • May 20, 2013 at 8:27 am

    #1616636

    check the agent log and replication monitor will help

  • May 20, 2013 at 8:46 am

    #1616651

    Do the agent which is configured to run snapshot agent have access (read/write permission)to snapshot folder?

  • May 20, 2013 at 8:51 am

    #1616653

    The Windows account under which the agent runs is used when it makes connections to the Distributor. This account must:

    At minimum, be a member of the db_owner fixed database role in the distribution database.

    Have read, write, and modify permissions on the snapshot share.

    The account that is used to connect to the Publisher must at minimum be a member of the db_owner fixed database role in the publication database.

  • May 23, 2013 at 12:56 am

    #1617707

    dear can you tell me please how to do this? i mean how to make the windows account be the member of db_owner?

  • May 23, 2013 at 1:02 am

    #1617711

    Select your Publication Right Click Go to Publication Properties -> Agent Security you will the find the user credential to be used for SnapShot Agent and Log Agent

  • May 23, 2013 at 1:51 am

    #1617725

    windows account which i used to login to machine??? but its not working in sql server snapshop agent and in its properties. Error is "The process account specified is not valid account."

  • May 23, 2013 at 1:55 am

    #1617728

    Try connecting Snapshot agent using Sql Server User Credential.

  • May 23, 2013 at 10:56 am

    #1617942

    now windows accoount has been accepted. but again one problem when i check the view snapshot agent sataus by right clicking on publication again i see an error here is that

    "Unable to start execution of step 2 (reason: Error authenticating proxy SAIMMALIK-PC\BILAL AHMAD, system error: Logon failure: unknown user name or bad password.). The step failed."

    but account which i give in the subscription>properties> agent security is been accepted but even then this is the error???????

    I dont know why????

  • May 25, 2013 at 9:00 pm

    #1618559

    Thanks Brother it works well 🙂

    But now i got another problem. I have made 4 instances on sql server 2008 r2 and i want to connect them remotely means want to made linked server. When i connect first two server and run the query it gave me the error "the windows firewall on this machine is currently blocking remote debugging.Remote debugging requires that the debugging be allowed to receive information from the network.Remote debugging also requires DCOM (TCP port 135) and IPSEC (UDP 4500/UDP500) be unblocked ", then i configured the windows firewall and added inbound and outbound rules and confiuger the network configuration of the instances. Connection becomes successful. but when i want to connect two other servers it gives the same error and not resolving why?????????? Means windows firewall is already configured that's why first two servers are linked and connection test is successful??????? then why later two are not configuring????????????/

    Please give me the suggestion?????

    Thanks alot

  • May 25, 2013 at 11:23 pm

    #1618564

    Thanks brother its been solved:-)

Viewing 11 posts - 1 through 10 (of 10 total)

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