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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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.

    https://technet.microsoft.com/en-us/library/aa174516(v=sql.80).aspx

    Can anyone provide more suggestions?

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

    Friday, April 15, 2016 6:52 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    Thanks,
    Lydia Zhang

    Lydia Zhang
    TechNet Community Support


    Monday, April 18, 2016 7:18 AM