Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance?

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?


You can use the SNAC on the client side to set up an Alias for that instance of SQL Server. This link, http://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/, will describe how to set up the alias which can redirect your connection to where ever you set your alias to point to.