September 8, 2004 at 8:37 am
What is the difference between the SQL Agent Startup account (Agent...Properties...General tab) and the SQL Server Connection account (Agent...properties...Connection tab)
I have always assumed that the Agent Startup Account is used when running scheduled DTS packages, replication etc. but don't know what the connection account is used for.
Can anyone provide me with 2 scenarios one that would use the startup account and one that would use the connection account.
Thanks
September 8, 2004 at 10:27 am
SQLAgent needs to connect to SQL Server. It can use it's startup account (and windows auth) or it can use a SQL Server account (SQL auth) you specify.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
September 9, 2004 at 6:35 am
Startup is used when starting SQL Agent. SQL Agent connects to SQL Server, at various times like updating system tables, running CmdExec jobs etc. where it uses the connection account. If you set it as Windows Authentication for connection account, as Steve pointed out, it will use the Startup account.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply