Specifying a SQL Server Alias

  • Article

By default, the SQL Server Agent service connects to an instance of SQL Server over named pipes by using dynamic server names that require no additional client configuration.

You must specify a server connection alias only under the following conditions:

  • You are not using the default network transport to connect to an instance of SQL Server.
  • You are connecting to an instance of SQL Server that listens on an alternate named pipe.

For more information about how to specify a SQL Server alias, see How to: Set a SQL Server Alias (SQL Server Management Studio).