RDS 2019 HA configuration fails when using Azure SQL database

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

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.
3,031 questions
No comments
{count} votes

2 answers

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

    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.

    No comments

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

    Hello @Nikhil Lotia ,

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

    No comments