Re: SQL Server and Agent Accounts

Hi Guys - Thank you so much for your help. Let me clarify my questions:

1) I log in to the server as a sysadmin. What I have observed is that
it is not enough to be logged in as a sysadmin when running the replication
wizard, SQLServer service must run under a windows account that is also
sysadmin on the server (and if you the service is running under Local
System, then NT Authority\System must be sysadmin).
I would like to confirm that this is indeed a prerequisite.

2) Here is a scenario that I tested: I created a Windows account called
"Domain\ReplAccount" that has access to the snapshot folder on the server.
Then I set the SQL Agent account to run under Domain\ReplAccount. I did not
create a login for Domain\ReplAccount on the publisher.
Then I logged in to the subscriber using an account (Domain\Maer) that
is in the PAL on the publisher and synchronized. Everything worked fine.

My confusion is that I thought that Domain\ReplAccount had to be in the
PAL. Apparently when SQL Agent logs in to the publisher it uses Domain\Maer.

Is this correct? Is this what impersonation means?

Thank you,
Maer






"Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx> wrote in message
news:u%23EvkVh1FHA.2540@xxxxxxxxxxxxxxxxxxxxxxx
> Maer,
> a lot of the replication procedures can only be run by sysadmin. Fo rthe
> second question, I'm not too sure what you mean. The account needs to have
> access to the snapshot share and after that if you're using impersonation
> it'll need to be in the PAL. If you're working on a schedule it'll use
> this account.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>


.

Relevant Pages

  • Re: Very Very Urgent, Please Help
    ... Try logging onto the server under the domain account that the SQL Agent ... >> system account which does not have access to the DTS packages. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: SA PW
    ... with an account that has sysadmin role on the server (as she said, ... Protection Program and to order your FREE Security Tool Kit, ...
    (microsoft.public.sqlserver.security)
  • Re: Replication Monitor disappears
    ... account and see if it shows up. ... Looking for a SQL Server replication book? ... When I was setting up replication I had SQL ... Finally I was able to start the SQL Agent service by ...
    (microsoft.public.sqlserver.replication)
  • RE: dts package error
    ... database on a different server with information on my SQL once a week. ... > under the context of the SQL Agent account. ... > account and try to manually kick off the package. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQLServerAgent will not start - "Event ID: 103" - URGENT HELP
    ... Check the start up account that you are using for SQL Agent. ... Make sure it has a SQL Server login and appropriate ... Windows login needs access to SQL Server. ...
    (microsoft.public.sqlserver.odbc)