Configure a Microsoft Azure SQL workspace

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 workspace. 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.
4. Once the database is created, create an administrator account for the database via the Administration – User Management 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. Connect on the Microsoft Azure SQL database with the Remote Desktop Manager administrator account. To do so, edit the workspace used to create the database and change the login information for the administrator account that you have created.

The Microsoft Azure SQL workspace is now correctly configured.