In the SQL Server Agent Propertiesserver_name dialog box, under Select a page, select Connection, and In the Alias local host server box, type the alias of the server to which [!INCLUDE ssNoVersion] ...

We've got a DNS alias in our DNS server so that we can reference the SQL Server via a generic easy to remember name. It's used in our client app's ODBC connection. The thought process being, if we ...

Is it possible to have a SQL Server 2005/2008 instance respond under multiple "aliases" for the same server.<BR><BR>Eg. You've got SQL Server installed, and an ...