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

To create the QLM database on the Azure portal:

Go to the Windows Azure Portal. Select SQL Databases. Click on the Add. Set the database name to: qlm Pick the Subscription, and Resource Group server of your choice. Set the Select Source field to "Blank database" Select an existing Server or create a New Server Select whether you want to use a SQL Elastic pool Select a Pricing tier Use the default Collation Click Create

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.

In the Server name field, enter a name of your choice. Example: qlm-server In the Server admin login field, enter a name of your choice. Example: qlm_admin In the password and confirm password fields, enter a new password Select a Location Click Select

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 Click Tools Click Query Editor Click login and enter your credentials Click Open Query and select: %Public%\Documents\Quick License Manager\DeployToAzure\Db\qlm.createtables.sql Click on Run to execute the query Repeat these two steps for the following sql script file: aspnet.sql

Create the QlmLicense Server App Service

• Click App Services in the Azure Portal
• Click "Create app service"
• Select "Web App"
• Click Create
• Set the App Name to: QlmLicenseServer (or any name of your choice)
• Select your subscription
• Select a Resource Group or create a new one
• Set the OS to: Windows
• Set Publish to: Code
• Select the App Service plan
• Click Create
• Click App Services to view the newly created App Service
• Locate and note the URL to access the App Service in Azure. The URL will look like: https://qlmlicenseserver.azurewebsites.net

Next, you need to create the QLM Azure packages that should be uploaded to Azure.

• Launch the QLM Management Console (v12+)
• Go to the Manage Keys tab
• Click Sites
• Click Add to add a new site
• Specify a site name
• In the Primary site field, enter the URL to the License Server: For example: https://qlmlicenseserver.azurewebsites.net/qlmservice.asmx
• Set the Database Engine to SQL Server
• Click on the Encryption Keys tab, then click New for CommunicationEncryptionKey and 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 Overview tab.
    • Click Show database connection strings
    • In the ADO.NET tab, copy the value of the Server entry. The value typically looks like: tcp:qlm-server.database.windows.net,1433
  • Database Name: qlm or any other name you have entered earlier in the process when you created the database
  • User Name: name of the sql admin user you specified earlier in the process
    User Password: password of the sql admin user you specified earlier in the process
• Click "Create Azure Package"

• Modify the azure app service URL by adding the "scm" subdomain and the ZipdeployUI as a suffix. Example:https://qlmlicenseserver.scm.azurewebsites.net/ZipDeployUI
• Open this URL in a browser
• Locate the QlmLicenseServer.zip file in %Public%\Quick License Manager\DeployToAzure
• Drag and Drop QlmLicenseServer.zip in the browser explorer area.
• Once deployment is completed, you can access the QLM License Server at the following URL: https://qlmlicenseserver.azurewebsites.net/qlmservice.asmx
• In the QLM Sites edir, go to the General tab and click the Test button to verify the connection to the server.

Create the QlmCustomerSite App Service

• Click App Services in the Azure Portal
• Click "Create app service"
• Select "Web App"
• Click Create
• Set the App Name to: QlmCustomerSite
• Select your subscription
• Select a Resource Group or create a new one
• Set the OS to: Windows
• Set Publish to: Code
• Select the App Service plan
• Click Create
• Click App Services to view the newly created App Service

Once the App Service is created, we need to deploy the QLM Customer Site to this App Service.

• Locate the URL to access the App Service in Azure. The URL will look like: https://qlmcustomersite.azurewebsites.net
• Modify the URL by adding the "scm" subdomain and the ZipDeployUI as a suffix. Example: https://qlmcustomersite.scm.azurewebsites.net/ZipDeployUI
• Open this URL in a browser
• Locate the QlmCustomerSite.zip file in %Public%\Quick License Manager\DeployToAzure
• Drag and Drop QlmCustomerSite.zip in the browser explorer area.
• Once deployment is completed, you can access the QLM License Server at the following URL:https://qlmcustomersite.azurewebsites.net

Create the QlmPortal App Service

• Click App Services in the Azure Portal
• Click "Create app service"
• Select "Web App"
• Click Create
• Set the App Name to: QlmPortal
• Select your subscription
• Select a Resource Group or create a new one
• Set the OS to: Windows
• Set Publish to: Code
• Select the App Service plan
• Click Create
• Click App Services to view the newly created App Service

Once the App Service is created, we need to deploy the QLM Customer Site to this App Service.

• Locate the URL to access the App Service in Azure. The URL will look like: https://qlmportal.azurewebsites.net
• Modify the URL by adding the "scm" subdomain and the ZipDeployUI as a suffix. Example: https://qlmportal.scm.azurewebsites.net/ZipDeployUI
• Open this URL in a browser
• Locate the QlmPortal.zip file in %Public%\Quick License Manager\DeployToAzure
• Drag and Drop QlmPortal.zip in the browser explorer area.
• Once deployment is completed, you can access the QLM License Server at the following URL: https://qlmportal.azurewebsites.net/qlmportal.aspx

Is it recommended to set the Default Document of the QLM Portal to QlmPortal.aspx as follows:

• In the Azure QLM Portal panel, locate the Settings section and click Application Settings
• Locate the Default Documents section
• Click Add new document
• Enter QlmPortal.aspx
• Click Save