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?
Best Answer
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.