SQL Server Alias

By default, SQL Server Agent connects to Microsoft® SQL Server™ over named pipes using dynamic server names that require no additional client configuration.

You must only specify a server connection alias when:

• You are using a nondefault network transport to connect to a computer running SQL Server.
• You are connecting to a computer running SQL Server that listens on an alternate named pipe.

To set a SQL Server alias