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