Licensing for SQL Server Failover Cluster with Availability Group

Md Moinul Islam 20 Reputation points
2023-04-28T16:52:04.7733333+00:00

We have a SQL server Standard configured as Failover Cluster with Always on High Availability Group. One server is Active and the other is Passive. Now, we have db1 which is replicated to Server2. What we want we want to add a db2 to Server2 and for db2 Server2 will be Active server and Server1 will be the passive server. What are the license requirements for this setup. If I buy another Standard License for Server2, will it be complaint? The SQL server licensing document doesn't answer my above scenario. Please advise.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,086 questions
0 comments No comments
{count} votes

Accepted answer
  1. Konstantinos Passadis 17,376 Reputation points MVP
    2023-04-28T16:53:56.9833333+00:00

    Hello @Md Moinul Islam !

    If you have a two-node cluster, each node in the cluster must be licensed with a SQL Server Standard Edition license. This means that you would need to purchase an additional SQL Server Standard Edition license for Server2 in order to use it as the active server for db2.

    However, there are some additional licensing considerations for Always On Availability Groups. Each database that is participating in an Availability Group must be licensed with a SQL Server Enterprise Edition license, regardless of the edition of SQL Server that is being used for the Failover Cluster Instance. This means that if you want to use db2 in an Availability Group, you would need to purchase a SQL Server Enterprise Edition license for at least one of the nodes in the cluster.

    If the Answer is helpful, please click "Accept Answer" and upvote it.

    Regards

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful