SQL Server Agent Properties (Connection Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

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.

See Also

How to set a SQL Server alias (Enterprise Manager)

How to set the SQL Server connection (Enterprise Manager)