# How to install the QLM License Server on Microsoft Azure

## QLM and Windows Azure Integration <a href="#h_01he5rjsvvq2txyef5nq6yfctd" id="h_01he5rjsvvq2txyef5nq6yfctd"></a>

**Important:** If you are using QLM v12 or higher, refer to the instructions [here.](https://support.soraco.co/hc/en-us/articles/360024356392-QLM-v12-Azure-Integration)

You can host the QLM License Server on a Windows Azure portal. The procedure outlined in this section will show you how to build a QLM Azure deployment package, how to create the database on the Azure Portal and finally how to connect QLM to the Azure hosted QLM License Server.

### 1. Database Creation <a href="#h_01he5rjsvvbgbxfpnmn1fzanan" id="h_01he5rjsvvbgbxfpnmn1fzanan"></a>

To create the QLM database on the Azure portal:

| cfd179310e1a417983b969f7fb8ccf98                                                      | ![](https://support.soraco.co/hc/en-us/article_attachments/207883063/Azure01.png) |
| ------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------- |
| <ul><li>Go to the Windows Azure Portal.</li></ul>                                     |                                                                                   |
| <ul><li>Select <strong>SQL Databases.</strong></li></ul>                              |                                                                                   |
| <ul><li>Click on the New button.</li></ul>                                            |                                                                                   |
| <ul><li>Click on <strong>Quick Create.</strong></li></ul>                             |                                                                                   |
| <ul><li>Set the database name to: <strong>qlm</strong></li></ul>                      |                                                                                   |
| <ul><li>Pick the server of your choice or create a new SQL database server.</li></ul> |                                                                                   |
| <ul><li>Click on <strong>Create SQL database.</strong></li></ul>                      |                                                                                   |

### 2. Server settings <a href="#h_01he5rjsvvpjpr9smgy0mrv6cs" id="h_01he5rjsvvpjpr9smgy0mrv6cs"></a>

If you selected to create a new SQL database server on the previous step, you need to configure a user account on the SQL Server.

| fe0e3ea9138b4b378383b7a468758b54                                                                   | ![](https://support.soraco.co/hc/en-us/article_attachments/207875866/Azure02.png) |
| -------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------- |
| <ul><li>Enter qlm as the login name of the server</li></ul>                                        |                                                                                   |
| <ul><li>Enter a password</li></ul>                                                                 |                                                                                   |
| <ul><li>Select a region</li></ul>                                                                  |                                                                                   |
| <ul><li>When done, confirm that you see the database in the list of available databases.</li></ul> |                                                                                   |
| ![](https://support.soraco.co/hc/en-us/article_attachments/207883103/Azure03.png)                  |                                                                                   |

### 3. Configure the database <a href="#h_01he5rjsvv9xy83s21x4r2jb00" id="h_01he5rjsvv9xy83s21x4r2jb00"></a>

Now that the database is created, we need to create the tables and stored procedures. Follow the steps below:

| cde9d166c29d4f19a6d447ff444a637e                                                                                                                                                                             | ![](https://support.soraco.co/hc/en-us/article_attachments/207883143/Azure04.png) |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------- |
| <ul><li>Click on the QLM database in the list</li></ul>                                                                                                                                                      |                                                                                   |
| <ul><li>In the Connect to your database panel, click on "Run Transact-SQL queries against your SQL database.</li></ul>                                                                                       |                                                                                   |
| 0109b5403f284862aa2fa980bb4f4640                                                                                                                                                                             | ![](https://support.soraco.co/hc/en-us/article_attachments/207875906/Azure06.png) |
| <ul><li>When prompted to login, enter your SQL Server credentials.</li></ul>                                                                                                                                 |                                                                                   |
| ea5d5a3bbc9b4020b9bc2d7ead8238e7                                                                                                                                                                             | ![](https://support.soraco.co/hc/en-us/article_attachments/207883203/Azure07.png) |
| <ul><li>Click on New Query and paste the content of the file: %Public%\Documents\Quick License Manager\DeployToAzure\Db\qlm.createtables.sql</li></ul>                                                       |                                                                                   |
| <ul><li>Click on Run to execute the query</li></ul>                                                                                                                                                          |                                                                                   |
| <ul><li>Repeat these two steps for the following files, in the exact order listed here: InstallCommon.sql, InstallRoles.sql, InstallPersonalization.sql, InstallProfile.sql, InstallMembership.sql</li></ul> |                                                                                   |

### 4. Creating the QLM package <a href="#h_01he5rjsvvn2yje13c4kkb3c9m" id="h_01he5rjsvvn2yje13c4kkb3c9m"></a>

To deploy the QLM License Server to Windows Azure, you must create an Azure package by following the steps oultined below:

| 677756eb4c064d139c75306095569845                                                                                                                                                                                                                 | ![](https://support.soraco.co/hc/en-us/article_attachments/207875946/Azure08.png) |
| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------- |
| <ul><li>Launch the QLM Management Console and go to the Manage Keys tab</li></ul>                                                                                                                                                                |                                                                                   |
| <ul><li>Click on the Sites button in the toolbar, then click on Add</li></ul>                                                                                                                                                                    |                                                                                   |
| <ul><li>Enter a name for your Azure site, say QlmAzure, and click OK.</li></ul>                                                                                                                                                                  |                                                                                   |
| <ul><li>In the Primary Site field, enter (you can replace 'myqlm' with any value of your choice): <http://myqlm.cloudapp.net/qlmwebservice/QlmService.asmx></li></ul>                                                                            |                                                                                   |
| <ul><li>If you replaced 'myqlm' with any other value, note that you will need to use the same value later on in this procedure.</li></ul>                                                                                                        |                                                                                   |
| <ul><li>Set the Database Engine to: SQL Server</li></ul>                                                                                                                                                                                         |                                                                                   |
| <ul><li>Click on the Encryption Keys tab, then click New for both fields to generate a CommunicationEncryptionKey and an AdminEncryptionKey</li></ul>                                                                                            |                                                                                   |
| <ul><li>Click on the Database Connection tab and enter all the fields on this tab</li></ul>                                                                                                                                                      |                                                                                   |
| <ul><li>Server Hostname or IP: to get this value, select your database in Azure, and click on the Dashboard link. The SERVER NAME field is displayed in the right hand panel and typically looks like: o5ad7dxk8e.database.windows.net</li></ul> |                                                                                   |
| <ul><li>Database Name: qlm or any other name you have entered earlier in the process</li></ul>                                                                                                                                                   |                                                                                   |
| <ul><li>User Name: name of the user you specified earlier in the process</li></ul>                                                                                                                                                               |                                                                                   |
| <ul><li>User Password: password of the user you specified earlier in the process</li></ul>                                                                                                                                                       |                                                                                   |
| <ul><li>Click on Update config files</li></ul>                                                                                                                                                                                                   |                                                                                   |
| <ul><li>Do not click OK -- leave the Sites editor open.</li></ul>                                                                                                                                                                                |                                                                                   |
| <ul><li>The next steps involve building the package using Visual Studio 2015. You will need to first install the <a href="https://azure.microsoft.com/en-ca/downloads/">Azure SDK for .NET</a>.</li></ul>                                        |                                                                                   |
| <ul><li>Open and Build the QlmAzure solution located in the %Public%\Documents\Quick License Manager\DeployToAzure\ folder using Visual Studio 2012</li></ul>                                                                                    |                                                                                   |
| <ul><li>Right mouse click on the QlmAzure project and select "Package"</li></ul>                                                                                                                                                                 |                                                                                   |
| <ul><li>Set the Service Configuration to Cloud and Build Configuration to Release then click on Package</li></ul>                                                                                                                                |                                                                                   |
| <ul><li>The following 2 files will be created in the QlmAzure\QlmAzure\bin\Release\app.publish folder: QlmAzure.cspkg and ServiceConfiguration.Cloud.cscfg files</li></ul>                                                                       |                                                                                   |

### 5. Cloud Service <a href="#h_01he5rjsvvf7zz033wtnx0v6jc" id="h_01he5rjsvvf7zz033wtnx0v6jc"></a>

Finally, we need to create the Azure Cloud Service and deploy the QLM package to the Azure portal:

| 720469f3126649a1a0855930ebc7ca05                                                                                                                      | ![](https://support.soraco.co/hc/en-us/article_attachments/207883263/Azure09.png) |
| ----------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------- |
| <ul><li>Go to the Windows Azure Portal.</li></ul>                                                                                                     |                                                                                   |
| <ul><li>Select <strong>Cloud Services.</strong></li></ul>                                                                                             |                                                                                   |
| <ul><li>Click on the New button.</li></ul>                                                                                                            |                                                                                   |
| <ul><li>Click on <strong>Quick Create.</strong></li></ul>                                                                                             |                                                                                   |
| <ul><li>Set the URL to any value of your choice that matches the value you set earlier on Sites page: <strong>myqlm</strong></li></ul>                |                                                                                   |
| <ul><li>Set the region to any value of your choice.</li></ul>                                                                                         |                                                                                   |
| <ul><li>Click on <strong>Create Cloud Service.</strong></li></ul>                                                                                     |                                                                                   |
| 6a9516e6c88a416ead6a9893bdcbb010                                                                                                                      | ![](https://support.soraco.co/hc/en-us/article_attachments/207883303/Azure10.png) |
| <ul><li>Once created, click on the service and select <strong>Upload a new production deployment.</strong></li></ul>                                  |                                                                                   |
| <ul><li>In the Deployment label field, enter: QLM</li></ul>                                                                                           |                                                                                   |
| <ul><li>In the Package field, click <strong>From Local</strong> and select the QlmAzure.cspkg file created earlier</li></ul>                          |                                                                                   |
| <ul><li>In the Configuration field, click <strong>From Local</strong> and select the Service.Configuration.Cloud.cscfg file created earlier</li></ul> |                                                                                   |
| <ul><li>Check "Deploy even if one or more roles contain a single instance".</li></ul>                                                                 |                                                                                   |
| <ul><li>Check "Start deployment".</li></ul>                                                                                                           |                                                                                   |
| <ul><li>Click on the checkmark at the bottom of the page</li></ul>                                                                                    |                                                                                   |
| 2163f60ada0d4c4cbefdb5c32d315f87                                                                                                                      | ![](https://support.soraco.co/hc/en-us/article_attachments/207883383/Azure12.png) |
| <ul><li>Once the package is created, click on Dashboard link to view details about the package. Take note of the <strong>Site Url</strong></li></ul>  |                                                                                   |
| <ul><li>Now go back to the QLM Management Console, Manage Keys / Sites which you left open earlier.</li></ul>                                         |                                                                                   |
| <ul><li>On the General tab, set the Primary Site to: \<siteUrl>/qlmwebservice/qlmservice.asmx</li></ul>                                               |                                                                                   |
| <ul><li>Click the <strong>Test</strong> button next to the primary site URL and confirm that all tests have passed.</li></ul>                         |                                                                                   |

This completes the configuration of the Azure site.