Windows 10: Windows Failover Clustering - SQL Server - Latency on Connection

Hello,We've just set up a two-node Windows Failover cluster WFSC on Windows Server 2019 across AWS regions Oregon and Ohio using Sios DataKeeper to replicate the files. We installed two SQL 2017 instances on the cluster. We adjusted the heartbeat settings to be more forgiving of a multi-subnet config with 2 seconds instead of 1 on the cross-subnet settings. We run 4 other clusters across AWS Availability Zones AZ with no problems, this is our first cross-region cluster.There were no issues during setup. The two roles can easily move between the two hosts with no hesitation or error

:)

 

Issues with report server setup during Install of MBAM using a SQL failover cluster

I'm trying to setup MBAM 2.5SP1 on Server 2016 using a SQL 2016 on a Failover Cluster (but not using AO).

The initial database configuration went smooth, but setting up the next step (Reports) is causing an issue because it cannot find the instance of the report server.

"Unable to find an instance of the Reporting Services.

That said, I realize that the report server is not supported with the failover cluster, but is there a way to point the Report feature to another SQL server or a server that has the reporting services (ie: one of the Failover cluster nodes) instead of auto-detecting
the SQL failover cluster name/IP?

I'm trying to avoid having a SQL server just for MBAM if I can avoid it (for cost and manageability reasons).

 

Implementation of SQL cluster setup in windows server 2016

Hi

Please guide me Implementation of SQL cluster setup in windows server 2016 in Virtual environment.

1. Node A & B VM created in same configuration

2. Failover clustering installed in both servers VM

I'm getting error in the time of validation (Storage & network)

Thanks & Regards

Kirubhakaran S

 

windows server 2016 essentials - Failover clustering not detecting

Hi Friends,

I want to make a 2 node cluster, i have already installed failover clustering feature on both the nodes through server manager.

But when i try to create a cluster, it gives me an error : " the server "node01" does not have failover feature installed. Please use server manager to install this feature"

But feature is already installed.

Can somebody help me with this error. How can i fix it.

Its urgent for me.

Regards