How to set the SQL Server connection (Enterprise Manager)

How to set the SQL Server connection (Enterprise Manager)

To set the SQL Server connection

1. Expand a server group, and then expand a server.
   
   
2. Expand Management, right-click SQL Server Agent, and then click Properties.
   
   
3. Click the Connection tab, and under SQL Server connection, do of the following:
   • Click Use Windows Authentication if you are running SQL Server Agent on a Microsoft® Windows NT® 4.0 or Windows 2000 server.
     
     
   • Use SQL Server Authentication if you are running SQL Server Agent on Windows 98.

     If you clicked Use SQL Server Authentication, in the SysAdmin login ID box, enter a login ID of a Microsoft SQL Server™ login who is a member of the sysadmin role. In the Password box, enter the password for the SQL Server login.