How To

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.