Table of contents
TOC
Collapse the table of content
Expand the table of content

Install the ODBC driver for SQL on each RD Connection Broker server

Liza Poggemeyer|Last Updated: 11/15/2016
|
1 Contributor

Applies To: Windows Server 2016

Remote Desktop Services uses an ODBC driver to access Azure SQL. Use the following steps to install an ODBC driver on each RD Connection Broker server:

  1. Create a public IP address for the first RD Connection Broker. (You only have to do this if the RDMS virtual machine does not already have a public IP address to allow RDP connections.)
    1. In the Azure portal, click Browse > Resource groups, click the resource group for the deployment, and then click the first RD Connection Broker virtual machine (for example, Contoso-Cb1).
    2. Click Settings > Network interfaces, and then click the corresponding network interface.
    3. Click Settings > IP address.
    4. For Public IP address, select Enabled, and then click IP address.
    5. If you have an existing public IP address you want to use, select it from the list. Otherwise, click Create new, enter a name, and then click OK and then Save.
  2. Connect to the first RD Connection Broker:
    1. In the Azure portal, click Browse > Resource groups, click the resource group for the deployment, and then click the first RD Connection Broker virtual machine (for example, Contoso-Cb1).
    2. Click Connect > Open to open the Remote Desktop client.
    3. In the client, click Connect, and then click Use another user account. Enter the user name and password for a domain administrator account.
    4. Click Yes when warned about the certificate.
  3. Download the ODBC driver for SQL Server that matches the version in the ODBC connection string.

    Note

    You got the ODBC connection string in Step 2 of Create an Azure SQL database for the RD Connection Broker.

  4. Copy the sqlincli.msi file to the first RD Connection Broker server.

  5. Open the sqlincli.msi file and install the native client.
  6. Repeat steps 1-5 for each additional RD Connection Broker virtual machine (for example, Contoso-Cb2).
© 2017 Microsoft