SQL Server Agent Properties (Connection Tab)
Use this tab to view or specify the following options.
Options
Use Windows Authentication
Connect SQL Server Agent to an instance of Microsoft® SQL Server™ using Windows Authentication. If this option is selected, then the Microsoft Windows NT® 4.0 and Microsoft Windows 2000® user account specified as the SQL Server Agent service startup account must be a member of the sysadmin role in SQL Server.
Use SQL Server Authentication
Connect SQL Server Agent to an instance of SQL Server using SQL Server Authentication.
SysAdmin login ID
Specify the login ID for the system administrator.
Password
Specify the password for the system administrator.
Login time-out
Specify the maximum time, in seconds, that SQL Server Agent waits for a connection to an instance of SQL Server to be established.
Local host server
Specify the alias of the instance of SQL Server that is the local server to accommodate custom connection needs. Use the Client Network Utility to modify the available choices.