Specifying a SQL Server Alias

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

You must specify a server connection alias only when:

• You are using a nondefault 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.

To set a SQL Server alias