0

I have come across one client who has setup like this where dba has installed sql server 2014 instance with enterprise edition setup on node1 and on node2 he has added mssqlserver 2014 in failover cluster with setup of standard edition .

They have never tested the failover before last night they did the patching on passive node and tried to failover active node( node1 enterprise) to passive( node2 standard) but it got failed and services doesn't come up on both the nodes. In the last they had to remove the node2 from cluster and end up repairing sql services on node1.

May i know the cause of it? can it be due to edition mismatch

setup detail abcdxyz sql instance (enterprise) running on node1 added the node to failover cluster on noode2 with standard setup .

asked May 20, 2021 at 9:20
1
  • 1
    Does this answer your question? Commented May 20, 2021 at 10:17

1 Answer 1

0

to solve the issue do an edition upgrade of sql server on the node 2.

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-2017

It should not even require the service to be stopped. At the end you have to restart the node 2

answered May 20, 2021 at 13:55

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.