March 20, 2008 at 2:40 pm
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
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy