Multiple Instances of SQL Server on a Failover Cluster (AlwaysON) RRS feed

  • Question

  • I have 3 node cluster (Always on) with the default instance on SQL server 2014 which are already configured and ready to use.

    I want to know if I can install the named instance together with the default instance on SQL server 2014.

    When I searched in internet  and found a TechNet article ,which says we can only run instance on sql server on each virtual server of a SQL server failover cluster. But the version which was mentioned  as SQL Server 2000.


    Can anyone provide more suggestions?

    -kccrga http://dbatrend.blogspot.com.au/

    Friday, April 15, 2016 6:52 AM


All replies

  • Hi,

      Yes, you can have named instances install along with the default instance. It will be using a different port and to connects to it, you will need to use the instance name.

    Hope this helps

    Friday, April 15, 2016 6:59 AM
  • Thanks Dennis!

    I hope we don't have to configure windows cluster and we can make use of existing windows cluster for the named instance too.

    Clarify my understanding.

    -kccrga http://dbatrend.blogspot.com.au/

    • Edited by kccrga Friday, April 15, 2016 7:09 AM
    Friday, April 15, 2016 7:09 AM
  • You can use the existing cluster, i assume you are only taking about alwayson for your DB, not actual SQL cluster right? as if you using SQL cluster, you will need additional cluster disks in your shared storage for the new named instance.
    Friday, April 15, 2016 7:13 AM
  • Yes, I am talking about Always on for our DB. I am not after SQL Cluster.

    -kccrga http://dbatrend.blogspot.com.au/

    • Edited by kccrga Sunday, April 17, 2016 12:36 AM
    Sunday, April 17, 2016 12:36 AM
  • Hi kccrga,

    It’s supported to install SQL Server 2014 named instance together with SQL server 2014 default instance in your scenario, and you are able to make use of existing windows cluster for the named instance.

    Moreover, it is also supported to configure additional AlwaysON group for newly installed named instances, about this design, please review the following similar theads.

    Multiple Instances and AlwaysOn Availability Groups
    SQL Server 2012 AlwaysON multiple instance multiple listeners

    Lydia Zhang

    Lydia Zhang
    TechNet Community Support

    Monday, April 18, 2016 7:18 AM