Export (0) Print
Expand All
Expand Minimize

How to set the SQL Server connection (Enterprise Manager)

SQL Server 2000

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.

Show:
© 2014 Microsoft