Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance?
Scenario is I have SQL 2008 R2 installed as a named instance MACHINENAME\SQL2008R2 and i have some scripts which i cannot update that are trying to connect to a Default instance of sql (either via Data Source=. or Data Source=MACHINENAME) and i would like them to run against the named instance instead of having to install a new Default instance. Is it possible?
What are the advanatages/disadvantages of using custom hostnames vs. just using servernames for hosting services in IIS?
ie. With a Windows Server called 'SRV123' should we be hosting services under http://services/ServiceName instead of http://SRV123/ServiceName?
For example to get started:
Advantage: http://services is 'nicer' url than http://SRV123
Disadvantage: Creating a hostname has a bit of overhead in terms of creating the DNS entries (which in some work environments is not as easy as others).
NB: I am specifically asking in terms of Services that will only be used internally (thus url is not & never will be public).