QLM v12+ Azure Integration
Last updated
Last updated
The QLM License Server can be hosted 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 the QLM Management Console to the Azure-hosted QLM License Server.
To create the QLM database on the Azure portal:
If you selected to create a new SQL database server in the previous step, you need to configure a user account on the SQL Server.
Set the Connectivity Method to Public endpoint.
Set the Allow Azure services and resources to access this server property to Yes.
Set the Add current IP address property to Yes.
Set the Connection Policy to Default
Set the "Minimum TLS Version" to 1.0. This is required as the default OLEDB drivers that are available on Azure App Services do not currently support TLS 1.2 and there does not seem to be a way to update these drivers.
Now that the database is created, we need to create a user account, tables and stored procedures. Follow the steps below:
Create the tables and DB user account
In SSMS, click Connect
Set the Server Name to the URL of your server. Example: qlmserver1.database.windows.net
Set the Login name to: qlm_admin
Enter your password: <password>
Click the Options button
Set the "Connect to database" to: qlm_db
Click Connect
Right-mouse click the server in SSMS and select New Query
Click Open Query and select: %Public%\Documents\Quick License Manager\DeployToAzure\Db\qlm.createtables.sql
Click on Execute to run the query
Repeat these two steps for the following sql script file: aspnet.sql
Repeat these two steps for the following sql script file: qlm.createuser.sql
Right-mouse click the server in SSMS and select Disconnect
Validate the previous steps:
In SSMS, click Connect
Set the Server Name to the URL of your server. Example: qlmserver1.database.windows.net
Set the Login name to: qlm_user
Enter your password: <password>
Click the Options button
Set the "Connect to database" to: qlm_db
Click Connect
Expand the database tables node and verify that the tables were created
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 Publish property to: Code
Set the Runtime Stack to: ASP.NET V4.8
Set the OS to: Windows
Set a Region of your choice
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
Click App Services in the Azure Portal
Click "Create app service"
Select "Web App"
Click Create
Select your subscription and resource group
Set the App Name to: QlmCustomerSite
Set the Publish property to: Code
Set the Runtime Stack to: ASP.NET V4.8
Set the OS to: Windows