Make named instance behave like default instance

Posted on 2007-10-05
Last Modified: 2008-01-09
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?
Question by:Zavatar
    1 Comment
    LVL 142

    Accepted Solution

    sorry, but no, that is not possible.
    you should have coded your application(s) to have the connection string in a config file, saving your from this hassles...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now