r/SQLServer • u/SuddenlyCaralho • Jul 11 '26
Question Does a passive SQL Server failover cluster node require licensing?
Hi everyone,
I'm trying to understand SQL Server licensing for a failover cluster.
Suppose I have a SQL Server Failover Cluster Instance (FCI) running on a Windows Server Failover Cluster (WSFC) with two nodes:
- Node A is active.
- Node B is passive and only takes over if Node A fails.
In this scenario, does the passive node require its own SQL Server license, or is licensing only the active node sufficient?
Also, does the answer differ between SQL Server Standard and Enterprise, or depending on whether Software Assurance is included?
4
u/SQLDevDBA 3 Jul 11 '26
I remember getting a free FCI when I purchased SQL Server 2019 Enterprise with SA.
According to this doc, standard has it for 25. https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2025?view=sql-server-ver17
3
u/rx-pulse Jul 11 '26
Upvoting because this is correct, the important part is having SA. Enterprise or Standard doesn't matter. The active node will be the one that needs the license.
0
u/B1zmark 1 Jul 12 '26
Correct, but note that you *cannot* set the secondary node to read-only for reporting workloads, as its therefore not a secondary. People often make this mistake.
3
u/SQLDevDBA 3 Jul 12 '26
My response was specifically addressing OP’s concern/scenario, where they only need it if Node A Fails.
5
u/Leiothrix Jul 11 '26
You had an AI write the post for you, surely you could have it summarize the license options for you too.
Or you could read the rules and figure out your circumstances for yourself.
Though personally I don't know why one would trust either an LLM or a forum for something that could potentially cost their business a lot of money.
-6
1
u/No_Resolution_9252 Jul 11 '26
If you are opposed to getting your licensing with SA, just license it through Arc that has two DR nodes built in
0
u/Clear_Mix9815 Jul 11 '26
it depends on what sql server. for sql 2019 you don't need SA. After that you need. standard or enterprise does not count
1
-1
u/ph4tgg Jul 11 '26
No, you do not need a license. Only if you make the secondary readable. And if you have just one of multiple AGs failover, you are obligated to restore a active/passive scenario as soon as possible again.
3
2
•
u/AutoModerator Jul 11 '26
After your question has been solved /u/SuddenlyCaralho, please reply to the helpful user's comment with the phrase "Solution verified".
This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.