RDS CB HA SQL client

Question

hello,
i'm trying to setup ha on a connection broker in rds deployment with windows 2019

i have 2 SQL 2016 servers configured with availability groups;
i created a new database and setup availability group and listener

now, all howto guides found on the internet say to use SQL native client on the connection brokers.
but that seems to be deprecated and it is advised to use micrososft ole db driver.

is this setup supported ? should've work ?

i have tried a lot of connection strings but none of them seems to work and i get the general error:

here is one of them:
Provider=MSOLEDBSQL;Server=tcp:rdscbdbl,1450;MultiSubnetFailover=Yes;Database=RDSCBDB;Trusted_Connection=Yes;Connect Timeout=30;

any help would be much apreciated.
thanks

Answer 1

Hi,
Thanks for posting in our Q&A forum.

According to the step by step deployment guidance, the Prerequisites listed out following:
Ensure that all RDCB Servers have the SQL Server Native Client Installed

I managed to setup RDS CB HA with SQL Server Native Client installed and conducted below command.

Reference link:
https://nedimmehic.org/2017/05/16/remote-desktop-services-2016-connection-broker-high-availability/
Please note: Information posted in the given link is hosted by a third party. Microsoft does not guarantee the accuracy and effectiveness of information.

Moreover, the official guidance also utilize the SQL Server Native Client when configuring the database for the Connection Broker.
https://learn.microsoft.com/en-us/windows-server/remote/remote-desktop-services/rds-connection-broker-cluster#step-1-configure-the-database-for-the-connection-broker

-----Please "Accept as answer" if the reply is helpful-----
Thanks,
Jenny

Answer 2

hello,
thanks for taking the time to give a detailed answer.

from what i understand, i should use SQL naive client even though it is deprecated and not ole db driver ?