none
RD Connection Broker HA - SQL Connection String

    Pertanyaan

  • Hi,

    I'm trying to configure HA for our Remote Desktop Connection Broker on Windows Server 2016, but I cannot connect to the database during the wizard. I'm not sure if I have the correct SQL Connection String?

    I've followed this guide, https://nedimmehic.org/2017/05/16/remote-desktop-services-2016-standard-deployment-part-6-rd-connection-broker-high-availability/, and I've tried both of the options, Dedicated database server and Shared database server. I've pre-created the database and given the RD Connection Broker servers db_owner permission (via an AD group).

    But on the wizard where the DB connection string is specified I only get the error "The database specified in the database connection string is not available from the RD Connection Broker server..."
    I can connect to the database from ODBC Data Source Administrator on the RD Connection Broker Server.

    It feels like the connection string is wrong. We're using SQL Server 2014, version 12.0.4422.0. The connection string:
    DRIVER=SQL Server Native Client 11.0;SERVER=LABSRV01;Trusted_Connection=Yes;APP=Remote Desktop Services Connection Broker;Database=RDCB

    Is that connection string correct?

    Kind regards,
    Andreas


    AN



    17 Mei 2018 14:29

Semua Balasan