Home / server / Questions / 368872
In Process
mundeep
Asked: 2012-03-13 08:38:18 +0800 CST

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

  • 772

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?

sql-server sql-server-2008-r2

1 Answers

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

    • 4