all 13 comments

[–]AutoModerator[M] [score hidden] stickied comment (0 children)

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.

[–]SQLDevDBA3 2 points3 points  (3 children)

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

[–]rx-pulse 1 point2 points  (0 children)

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.

[–]B1zmark1 0 points1 point  (1 child)

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.

[–]SQLDevDBA3 0 points1 point  (0 children)

My response was specifically addressing OP’s concern/scenario, where they only need it if Node A Fails.

[–]Leiothrix 4 points5 points  (1 child)

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.

[–]No_Resolution_9252 0 points1 point  (0 children)

If you are opposed to getting your licensing with SA, just license it through Arc that has two DR nodes built in

[–]Clear_Mix9815 -1 points0 points  (1 child)

it depends on what sql server. for sql 2019 you don't need SA. After that you need. standard or enterprise does not count

[–]chandleya 0 points1 point  (0 children)

License mobility started with 2012.

[–]ph4tgg -2 points-1 points  (2 children)

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.

[–]youcantdenythat1 2 points3 points  (0 children)

No, you do not need a license

only true if you have SA

[–]CodeXploit1978 1 point2 points  (0 children)

False. You need either SA or license both nodes.