RDS 2019 HA configuration fails when using Azure SQL database

Nikhil Lotia 26 Reputation points
2021-04-28T21:34:34.15+00:00

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

Remote Desktop
Remote Desktop
A Microsoft app that connects remotely to computers and to virtual apps and desktops.
4,344 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Leila Kong 3,691 Reputation points
    2021-04-29T06:13:41.997+00:00

    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.

    0 comments No comments

  2. Leila Kong 3,691 Reputation points
    2021-05-11T06:02:57.643+00:00

    Hello @Nikhil Lotia ,

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

    0 comments No comments