SQL Server Connection Method

Two Microsoft® SQL Server™ connection methods define how the SQLServerAgent service connects to the local SQL Server. Regardless of the method you select, the account must have system administrator permissions within SQL Server.

• Use Windows NT Authentication

  This method forces the SQL Server Agent service to connect to SQL Server using the Microsoft Windows NT® domain account you defined as the service startup account.

• Use SQL Server Authentication

  This method forces the SQL Server Agent service to connect to SQL Server using a SQL Server authenticated login. Only logins that are members of the sysadmin role are available.

  Select Use SQL Server Authentication if you are running SQLServerAgent on a server not running Windows NT.

Both options allow you to set a time limit for logins. If the SQLServerAgent service requires more time to connect to the local SQL Server than the duration you have specified, the login session will time out. You can specify a value from 5 through 45 seconds for the login time-out.

To set the SQL Server connection