Create an Azure SQL database for the RD Connection Broker

Applies To: Windows Server 2016

This article provides steps to deploy an Azure SQL Database instance for Remote Desktop. Alternatively, you could deploy a SQL server AlwaysOn Availability Group in multiple virtual machines or use a database in an existing SQL server deployment. For more details, see Create a SQL AlwaysOn Availability Group in Microsoft Azure End-to-End.

1. Create an Azure SQL Database instance.

2. Copy the connection string for the database you created. You'll need this in the next step.

   1. In the Azure portal, click Browse > Resource groups and click the resource group for the deployment.
   2. Select the SQL database you just created (for example, CB-DB1).
   3. Click Settings > Properties > Show database connection strings.

   4. Copy the connection string for ODBC (includes Node.js), which should look like this:

      Driver={SQL Server Native Client 13.0};Server=tcp:cb-sqls1.database.windows.net,1433;Database=CB-DB1;Uid=sqladmin@contoso;Pwd={your_password_here};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;

   5. Replace "your_password_here" with the actual password. You'll use this entire string, with your included password, when connecting to the database.