How to set a SQL Server alias (Enterprise Manager)

How to Install SQL Server 2000

How To

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.