RDS 2019 HA configuration fails when using Azure SQL database

Question

when trying to do configure high availablity for conneciton broker using azure sql database.

Getting error

could not set the client access name on xxxx.xxx.xxx.com on connection broker server. Generic failure.

event log errors.

Config sync failed with error: 0x80070490. Check database connectivity, connect string: Driver={SQL Server Native Client 11.0};Server=tcp:xxxx.database.windows.net,1433;Database=xxxxdb1;Uid=rdssqladmin@xxxxxxxxxxxxx .com;Pwd={password_replaced};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;.

Setting Client Access Name - Failed: Could not set the client access name

Answer 1

Hello @Nikhil Lotia ,

What's your RDS environment? Is it session-based deployment or VDI deployment?
How did you configure high availability for connection broker using azure SQL database?

Does it work if you try the following solution:
MultiSubnetFailover=TRUE isn't correct, and to use =YES instead;
Set up the license server type (per user or per computer).

For your reference:
https://social.technet.microsoft.com/Forums/ie/en-US/611af73a-e224-47f6-949d-0f2acdd3ee37/rds-2016-cb-in-ha-getting-config-sync-failed?forum=winserverTS
https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/using-connection-string-keywords-with-sql-server-native-client?view=sql-server-ver15
https://social.technet.microsoft.com/Forums/ie/en-US/320a7167-899e-4700-a254-15716c6952c6/remote-desktop-broker-config-sync-error?forum=winserverTS
https://blog.alschneiter.com/2015/03/02/rd-connection-broker-config-sync-failed-following-error-occurred-0x88250001/

Best regards,
Leila

----------

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hello @Nikhil Lotia ,

How are things going there on this issue?
Please let me know if you would like further assistance.