Post reply

Can't create initial snapshot (Detect nonlogged agent shutdown)

  • March 20, 2008 at 2:40 pm

    #183526

    I have researched this error and came across this forum with someone with the EXACT same problem:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=279120&SiteID=1

    I tried everything they suggested and I did everything he did to get his working but it still doesn't work for me. I don't know why.

    All his error messages are exactly the same except for one small detail I noticed:

    Message : Executed as user: NT AUTHORITY\SYSTEM. Replication-Replication Snapshot Subsystem: agent TOSHIBA\SQLSERVER2005-TestMobile-TestMobile-4 failed. Executed as user: toshiba\snapshot_agent. The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed. [SQLSTATE 42000] (Error 14151). The step failed.

    Mine is: (I'm including {} wherever I leave out information that I want to leave out)

    Message: Executed as user: {Agent account}. Agent shutdown. For more information, see the SQL Server Agent job history for job '{...blah....}'. [SQLSTATE 01000] (Message 20557) Replication-Replication Snapshot Subsystem: agent {...blah...} failed. Executed as user: {snapshot account}. The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed. [SQLSTATE 42000] (Error 14151). The step failed.

    Notice the Agent shutdown and Message 20557 part. I wonder what this means.

    Anyway, I created my snapshot user with sysadmin rights and gave him full permissions on snapshot folder and it doesn't work, so I can't think of why the permissions on that would be the reason for failure. Does anyone have any ideas?

  • March 20, 2008 at 3:07 pm

    #792264

    Ok, I figured out what was wrong.

    When I created the login in sql server for the snapshot agent to login with I didn't give that login any additional permission besides public. I didn't know I need extra permissions in the database, I thought it was just the account needed to have appropriate permissions in Windows.

    Does anyone know what the least privilege is that I can give to the snapshot login in sql server and still have it work? thanks.

Viewing 2 posts - 1 through 1 (of 1 total)

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