SQL Server and Agent Accounts
- From: "Maer" <maer@xxxxxxxxxxxxxxxxx>
- Date: Thu, 20 Oct 2005 22:25:35 -0400
Hi guys - I have two questions about accounts that sql server services
run under:
1) When I try to install the publisher, it fails to create the
distribution database because it says that login failed for NT
Authority\System (the SQL Server service was running as Local System). When
I added NT Authority\System (as sysadmin), everything worked fine. Then I
removed it and assigned a windows account to SQLServer service that was a
sysadmin, and it also worked fine. So my question is, why does SQLServer
service need to be running under an account that is a sysadmin?
2) I have create a merge replication with pull subscriptions. I noticed
that the SQL Agent can run under an account that is not in the publisher. So
when I synchronize does it use the account that is currently logged in?
Thank you for your help,
Maer
.
- Follow-Ups:
- Re: SQL Server and Agent Accounts
- From: Paul Ibison
- Re: SQL Server and Agent Accounts
- Prev by Date: Re: The process could not deliver update(s) at the 'Subscriber'
- Next by Date: Re: Dynamic and Join Filters with Multipple clauses
- Previous by thread: Re: The process could not deliver update(s) at the 'Subscriber'
- Next by thread: Re: SQL Server and Agent Accounts
- Index(es):
Relevant Pages
|
Loading
