sql standalone install on windows cluster is failing

Question

sql standalone install on windows cluster is failing

Heisenberg 266

hi folks, We have 2 node windows failover cluster with 2 node sql server failover cluster instance. We have added 2 more windows node to this WINDOWS cluster with the aim of adding these 2 nodes as a standalone sql instances and then configuring always on, on these 2 new nodes and then make all 4 sql instances part of always on group (2 old SQL FCIs and 2 new standalone). IS this possible? When i try to install standalone sql instance on node 3 and node 4 i get below error after rule check happens in the setup process and i can not proceed with the install.

Rule 'StandaloneInstall_HasClusteredOrPreparedInstanceCheck' detection result: HasFailedPreparedFeature = False, : HasClusteredFeature = True (12) 2023-04-05 17:03:49 Slp: Evaluating rule : StandaloneInstall_HasClusteredOrPreparedInstanceCheck (12) 2023-04-05 17:03:49 Slp: Rule running on machine: MAchine_01 (12) 2023-04-05 17:03:49 Slp: Rule evaluation done : Failed (12) 2023-04-05 17:03:49 Slp: Rule evaluation message: The instance selected for installation is already installed and clustered on computer MAchine_01. To continue, select a different instance to cluster. (12) 2023-04-05 17:03:49 Slp: Send result to channel : RulesEngineNotificationChannel

Seeya Xi-MSFT 16,676 Reputation points

2023-04-07T07:32:06.5733333+00:00

Hi @Heisenberg,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya
Seeya Xi-MSFT 16,676 Reputation points

2023-04-11T08:46:17.6866667+00:00

Hi @Heisenberg,

In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.

Best regards,

Seeya

1 answer

Your answer

Seeya Xi-MSFT 16,676 Reputation points

2023-04-07T07:32:06.5733333+00:00

Hi @Heisenberg,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya
Seeya Xi-MSFT 16,676 Reputation points

2023-04-11T08:46:17.6866667+00:00

Hi @Heisenberg,

In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.

Best regards,

Seeya

Answer 1

Hi @Heisenberg,

The instance selected for installation is already installed and clustered on computer MAchine_01. To continue, select a different instance to cluster.

It looks like this is not a newly installed instance for you. Do you have a cluster instance installed on node 3 and node 4? You can refer to my steps below when you install the new instance.

User's image

Of course, if there are no other instances on your node you can choose to install the default instance.

One more thing to note is that if your ultimate goal is to install a four-node cluster, you'd better configure a voting mechanism.

Please refer to this link: WSFC Quorum Modes and Voting Configuration (SQL Server)

Best regards,

Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Share via

sql standalone install on windows cluster is failing

1 answer

Your answer