Post reply

Startup Account and Connection Account

  • September 8, 2004 at 8:37 am

    #164915

    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

    #522158

    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.

  • September 9, 2004 at 6:35 am

    #522283

    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