How To
How to set the SQL Server connection (Enterprise Manager)
To set the SQL Server connection
- Expand a server group, and then expand a server.
- Expand Management, right-click SQL Server Agent, and then click Properties.
- 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.
- Click Use Windows Authentication if you are running SQL Server Agent on a Microsoft® Windows NT® 4.0 or Windows 2000 server.