Hi
I'm hoping somebody can assist with this as I'm currently slipping into a pit of dispair. I actually had HA up and running, but then had to tear everything down due to an outside issue and start again and now (of course) I cannot get HA to work. As per most other people stuck on this, I get the 'the database specified in the database connection string is not available' error after entering my connection string.
My env consists of 1 Gateway, 2 brokers and 2 hosts sitting on seperate VMs running Server 2019. I have a SQL Server 2019 instance running on another VM. I have both SQL Server Native Client 10 & 11 installed across the board (both fail). I have a Security Group configured with both my CB's present and said group has DBCREATOR/SYSADMIN privilages on the SQL instance (CB's were rebooted after being added to said group). DNS/Round Robin is configured for both CBs.
TCP Port 1433 is configured via protocols for the sql instance in SQL Config manager and I've added inbound/outbound rules for TCP Port 1433 and UDP port 1434 on the SQL Server/CB's.
In term of the connection string, I've tried both with and without the port present in the string (conflicting advice on this being required) and I have tried creating the DB first/with without login credentials in the string, but no joy;
DRIVER=SQL Server Native Client 11.0;SERVER=SQL Server\Instance;1433;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;DATABASE=DatabaseName
As I said, I got this working the first time so I have no idea where I'm going wrong now, the internet seems to be full of people with the same issue though.
Any help would be greatly appreciated.
Thank you
Daniel


