How to install the QLM License Server on Microsoft Azure

QLM and Windows Azure Integration

Important: If you are using QLM v12 or higher, refer to the instructions here.

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

To create the QLM database on the Azure portal:

Go to the Windows Azure Portal. Select SQL Databases. Click on the New button. Click on Quick Create. Set the database name to: qlm Pick the server of your choice or create a new SQL database server. Click on Create SQL database.
Go to the Windows Azure Portal.
Select SQL Databases.
Click on the New button.
Click on Quick Create.
Set the database name to: qlm
Pick the server of your choice or create a new SQL database server.
Click on Create SQL database.

2. Server settings

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.

Enter qlm as the login name of the server Enter a password Select a region When done, confirm that you see the database in the list of available databases.
Enter qlm as the login name of the server
Enter a password
Select a region
When done, confirm that you see the database in the list of available databases.

3. Configure the database

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

Click on the QLM database in the list In the Connect to your database panel, click on "Run Transact-SQL queries against your SQL database.
Click on the QLM database in the list
In the Connect to your database panel, click on "Run Transact-SQL queries against your SQL database.
When prompted to login, enter your SQL Server credentials.
When prompted to login, enter your SQL Server credentials.
Click on New Query and paste the content of the file: %Public%\Documents\Quick License Manager\DeployToAzure\Db\qlm.createtables.sql Click on Run to execute the query Repeat these two steps for the following files, in the exact order listed here: InstallCommon.sql, InstallRoles.sql, InstallPersonalization.sql, InstallProfile.sql, InstallMembership.sql
Click on New Query and paste the content of the file: %Public%\Documents\Quick License Manager\DeployToAzure\Db\qlm.createtables.sql
Click on Run to execute the query
Repeat these two steps for the following files, in the exact order listed here: InstallCommon.sql, InstallRoles.sql, InstallPersonalization.sql, InstallProfile.sql, InstallMembership.sql

4. Creating the QLM package

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

Launch the QLM Management Console and go to the Manage Keys tab Click on the Sites button in the toolbar, then click on Add Enter a name for your Azure site, say QlmAzure, and click OK. In the Primary Site field, enter (you can replace 'myqlm' with any value of your choice): http://myqlm.cloudapp.net/qlmwebservice/QlmService.asmx If you replaced 'myqlm' with any other value, note that you will need to use the same value later on in this procedure. Set the Database Engine to: SQL Server Click on the Encryption Keys tab, then click New for both fields to generate a CommunicationEncryptionKey and an AdminEncryptionKey Click on the Database Connection tab and enter all the fields on this tab 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 Database Name: qlm or any other name you have entered earlier in the process User Name: name of the user you specified earlier in the process User Password: password of the user you specified earlier in the process Click on Update config files Do not click OK -- leave the Sites editor open. The next steps involve building the package using Visual Studio 2015. You will need to first install the Azure SDK for .NET. Open and Build the QlmAzure solution located in the %Public%\Documents\Quick License Manager\DeployToAzure\ folder using Visual Studio 2012 Right mouse click on the QlmAzure project and select "Package" Set the Service Configuration to Cloud and Build Configuration to Release then click on Package The following 2 files will be created in the QlmAzure\QlmAzure\bin\Release\app.publish folder: QlmAzure.cspkg and ServiceConfiguration.Cloud.cscfg files
Launch the QLM Management Console and go to the Manage Keys tab
Click on the Sites button in the toolbar, then click on Add
Enter a name for your Azure site, say QlmAzure, and click OK.
In the Primary Site field, enter (you can replace 'myqlm' with any value of your choice): http://myqlm.cloudapp.net/qlmwebservice/QlmService.asmx
If you replaced 'myqlm' with any other value, note that you will need to use the same value later on in this procedure.
Set the Database Engine to: SQL Server
Click on the Encryption Keys tab, then click New for both fields to generate a CommunicationEncryptionKey and an AdminEncryptionKey
Click on the Database Connection tab and enter all the fields on this tab
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
Database Name: qlm or any other name you have entered earlier in the process