Export (0) Print
Expand All

Specifying a SQL Server Alias

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).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft