November 16, 2009 at 8:11 pm
Hi everyone
I have created a basic snapshot publication, which pushes two tables.
I have the windows account created to run the Snapshot agent under.
I tested with that windows account as db_owner of the distribution database and also as member of sysadmin.
The server acts as its own distributor.
The replication folder is shared, with NTFS Full Control to the Windows account and Everyone Full Control on the share (for now anyhow)
When I run the wizard to create the publication, it creates successfully, even Starting the snapshot agent.
But when I run it again manually, I get this error:
Replication-Replication Snapshot Subsystem: agent SRVDEV1\SS2K8-test-Test Publication YB - take 8-8 failed. Executed as user: ultratcs\sqlss2k8replag. The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed.
Can't find anymore details...
The agent job owner is sa...
Googled it and have tried a lot of things...now seeking help!
THanks:crazy:
November 16, 2009 at 9:16 pm
The error message indicated a different user and you specify that the Job owner is sa..
Do you remember what is the Security Context you have provided while configuring replication.
Also check that the sa Login is enabled. It would most probably a windows error if the error was mentioning something like unable to open network location etc.... So that might not be the case..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 17, 2009 at 5:24 am
The security context is using the Windows account indicated in the error message.
sa account is enabled
November 17, 2009 at 7:45 am
I was able to make it work when setting the Snapshot Agent running under the SQL Server Agent account (right now, Local System).
We'll keep it like this for now, will try to resolve it using the windows account on another physical server later.
November 17, 2009 at 6:46 pm
Some more info...
Was able to replicate error on another server; Here is what I found out as permissions needed.
As indicated in BOL, the windows account used as the Snapshot Agent must have db_owner role both in Publisher db and distribution db.
If he is the job owner must have SQLServer Agent User Role in msdb.
Must be able to write to the snapshot folder.
Must be in the Publication Access List (PAL) if he is not sysadmin.
Anyhow, I believe the server we have the SQL instance installed is ready for decommissioning!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply