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