Configure a Microsoft Azure SQL data source

  1. Make sure that you have a valid Microsoft Azure SQL subscription to be able to create your database.
  2. Follow the steps in Create a data source. On Step 4, after having configured the connection settings but before testing the server or otherwise verifying the connection, continue with the steps below.
  3. Select the Upgrade tab and click the Create Database button. If the database is already created on the Microsoft Azure SQL Server, click the Update Database button to add the appropriate tables to the database.
    Upgrade Tab
    Upgrade Tab
  4. Once the database is created, create an administrator account for the database via the Administration – User Management menu.

    If the database is created using a system administrator (example: SA), we recommend to keep this user only for the database creation and the database upgrade. A Remote Desktop Manager administrator account must be created first. Then, regular users are created with this administrator account.

    Create a Administrator Account
    Create a Administrator Account
  5. Connect on the Microsoft Azure SQL database with the Remote Desktop Manager administrator account. To do so, edit the data source used to create the database and change the login information for the administrator account that you have created.
    Connection to the Database with the Administrator Account
    Connection to the Database with the Administrator Account

The Microsoft Azure SQL data source is now correctly configured.

  1. Make sure you have a valid Azure SQL subscription to be able to create your database.
  2. Click on the gear button in the Navigation pane or go to File – Data sources.
    RDMMac2138
  3. Click on the plus sign to create a new data source.
    RDMMac2139
  4. Select Microsoft Azure SQL.
    RDMMac2140
  5. Configure the connection to your Azure SQL with a user with sufficient privileges to create the database.
    RDMMac2141
  6. Click on the Upgrade tab and press the Create Database button. If the database is already created on Azure SQL, press the Update Database button to create the appropriate tables in the database.
    RDMMac2142
  7. Once the database has been created, create a Remote Desktop Manager administrator account via the Administration – Users menu.

If your database was created using a Super User (example: SA), we recommend that you keep this user only for the creation of the database and/or for the upgrade of the database. A Remote Desktop Manager administrator account must first be created, and then users must be created with this Remote Desktop Manager administrator account.

  1. Log in to the Azure SQL data source with the Remote Desktop Manager administrator account. To do this, go to File – Data source and click on the settings button to edit your SQL data source. Then enter the Remote Desktop Manager administrator account that you created in the username.

You can now start creating your sessions or creating your users.

Devolutions Forum logo Give us Feedback