Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

How to set a SQL Server alias (Enterprise Manager)

SQL Server 2000

How to set a SQL Server alias (Enterprise Manager)

To set a SQL Server alias

  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 in the Local host server list, click the alias to which SQL Server Agent should connect.

    Select an alias that refers to the local instance of Microsoft® SQL Server™ or SQL Server Agent will not work correctly.

© 2015 Microsoft