Make named instance behave like default instance
Posted on 2007-10-05
We have a couple of default instances of SQL Server running on their own machines. We would like to consolidate these instances into a two-node cluster where one instance can run on each node, or where both instances can run on the same node in the event of a failure.
We know we have to switch to named instances to accomplish this because of the single default instance rule, but we do not want to have to recode all of our applications to use server\instance names. Creating server aliases on all of our clients is also not an option. Is there any other way to make a named instance act like a default instance?