question

nikhillotia-4738 avatar image
0 Votes"
nikhillotia-4738 asked LeilaKong-MSFT answered

RDS 2019 HA configuration fails when using Azure SQL database

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@xxxx.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-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeilaKong-MSFT avatar image
0 Votes"
LeilaKong-MSFT answered

Hello @nikhillotia-4738 ,

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://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeilaKong-MSFT avatar image
0 Votes"
LeilaKong-MSFT answered

Hello @nikhillotia-4738 ,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.