Using an alias for SQL server seems to be a pretty common thing, however all we did was set the alias in DNS and then start referencing it via ODBC. There is no reverse lookup for the alias.