QLM v20+ Azure Integration

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.

1. Database Creation

To create the QLM database on the Azure portal, go to the Azure SQL node and click Create / SQL Database:

2. Server settings

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.

Networking

• 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.

Configure the database

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: qlmadmin Enter your password: <password> Click the Options button Set the "Connect to database" to: qlmdb1 (or any name that you selected) Click Connect Right-mouse click the QLM database node 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: sql.aspnetcore.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: qlmdbserver1.database.windows.net Set the Login name to: qlmadmin Enter your password: <password> Click the Options button Set the "Connect to database" to: qlmdb1 Click Connect Expand the database tables node and verify that the tables were created

Create the QlmLicenseServerNetCore App Service

• Click App Services in the Azure Portal

• Click "Create app service"

• Select "Web App"

• Click Create

• Select your subscription

• Select a Resource Group or create a new one

• Set the Name to: QlmLicenseServerNetCore (or any name of your choice)

• Set "Publish" to "Code"

• Set the Runtime stack to ".NET 10"

• Set the OS to: Windows

• Set a Region of your choice

• Select the App Service plan

• Click Next until you get to the "Monitor + secure" page

• Set Enable Application Insights to False

• Click Review + Create

• Click App Services to view the newly created App Service

• Expand the Settings section and select Configuration

• Set the Platform to 64 Bit

• Click Appy

• Locate and note the URL to access the App Service in Azure. The URL will look like: qlmlicenseservernetcore-fud3ceecgzfqa6a9.canadacentral-01.azurewebsites.net

Create the QlmCustomerSiteNetCore App Service

• 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: QlmCustomerSiteNetCore

• Set the Publish property to: Code

• Set the Runtime Stack to: NET 10

• Set the OS to: Windows

• Set a Region of your choice

• Select the App Service plan

• Click Next until you get to the "Monitor + secure" page

• Set Enable Application Insights to False

• Click Create

• Click App Services to view the newly created App Service

• Expand the Settings section and select Configuration

• Set the Platform to 64 Bit

• Click Apply

Create the QlmPortalNetCore App Service

• 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: QlmPortalNetCore

• Set the Publish property to: Code

• Set the Runtime Stack to: NET 10

• Set the OS to: Windows

• Select the App Service plan

• Click Next until you get to the "Monitor + secure" page

• Set Enable Application Insights to False

• Click Create

• Click App Services to view the newly created App Service

• Expand the Settings section and select Configuration

• Set the Platform to 64 Bit

• Check the "Web sockets" option

• Click Apply

Create the QlmCustomerPortalNetCore API Service

• 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: qlm-portal-api

• Set the Publish property to: Code

• Set the Runtime Stack to: NET 10

• Set the OS to: Windows

• Select the App Service plan

• Click Next until you get to the "Monitor + secure" page

• Set Enable Application Insights to False

• Click Create

• Click App Services to view the newly created App Service

• Expand the Settings section and select Configuration

• Set the Platform to 64 Bit

• Click Apply

• Locate and note the URL to access the App Service in Azure. The URL will look like: https://qlm-portal=api.azurewebsites.net

Create the QlmCustomerPortalNetCore APP Service

• 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: qlm-portal-app

• Set the Publish property to: Code

• Set the Runtime Stack to: NET 10

• Set the OS to: Windows

• Select the App Service plan

• Click Next until you get to the "Monitor + secure" page

• Set Enable Application Insights to False

• 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://qlm-portal=api.azurewebsites.net

Deploy packages to your App Services

Now that all App Services have been created, you need to create and deploy the QLM Azure packages to your App Services.

Create the App Packages

• Launch the QLM Management Console

• 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://qlmlicenseservernetcore-fud3ceecgzfqa6a9.canadacentral-01.azurewebsites.net/api/v1/QlmApi

• Set the Database Engine to SQL Server

• Go to the Encryption Keys tab, then click New for CommunicationEncryptionKey and AdminEncryptionKey

• If you want to configure the QLM Customer Portal to support 3rd party authentication, go to the Authentication tab and set the Client ID of each provider as described in the Authentication Configuration section of this article.

• Go to the Deployment tab (formerly 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 user created earlier (qlm_user) User Password: password of the sql user created earlier

  • Set the URL to the QLM Customer Portal API (as per the App Service created earlier)

  • Set the URL to the QLM Customer Portal App (as per the App Service created earlier)

• Click "Create Azure Package"

• 4 zip files will be created. You will upload these zip files to your server in the next step.

Deploy the QLM License Server Package

• Go to the Azure Portal and click the QlmLicenseServerNetCore App Service.

• In the left-hand panel, locate the Deployment node, expand it and select Deployment Center.

• Click the Source drop down and select "Publish files"

• Locate the QlmLicenseServerNetCore.zip file in %Public%\Quick License Manager\DeployToAzure and select it

• Click Save

• Once the deployment is completed, you can access the QLM License Server at the following URL: https://qlmlicenseservernetcore1-fud3ceecgzfqa6a9.canadacentral-01.azurewebsites.net/api/v1/QlmApi

• In the QLM Sites editor, go to the General tab

• Set the Primary Site value to: https://qlmlicenseservernetcore1-fud3ceecgzfqa6a9.canadacentral-01.azurewebsites.net/api/v1/QlmApi

• Click the Test button to verify the connection to the server.

• If this is a new installation of the server, click "Upload your products to the License Server".

Deploy the QlmCustomerSite App Service

• Go to the Azure Portal and click the QLM Customer Site App Service.

• In the left-hand panel, locate the Deployment node, expand it and select Deployment Center.

• Click the Source drop down and select "Publish files"

• Locate the QlmCustomerSiteNetCore.zip file in %Public%\Quick License Manager\DeployToAzure and select it

• Click Save

• Once the deployment is completed, you can access the QLM License Server at the following URL:https://qlmcustomersite.azurewebsites.net

Deploy the QlmPortal App Service

• Go to the Azure Portal and click the QLM Customer Site App Service.

• In the left-hand panel, locate the Deployment node, expand it and select Deployment Center.

• Click the Source drop down and select "Publish files"

• Locate the QlmPortalNetCore.zip file in %Public%\Quick License Manager\DeployToAzure and select it

• Click Save

• Once the deployment is completed, you can access the QLM Portal at the following URL: https://qlmportal.azurewebsites.net/qlmportal.aspx

Deploy the QlmCustomerPortal API Service

• Go to the Azure Portal and click the QlmCustomerPortalAPi App Service.

• In the left-hand panel, locate the Deployment node, expand it and select Deployment Center.

• Click the Source drop down and select "Publish files"

• Locate the QlmCustomerPortalApiNetCore.zip file in %Public%\Quick License Manager\DeployToAzure and select it

• Click Save

• Once the deployment is completed, you can access the QLM Portal API at the following URL: https://qlm-portal-api.azurewebsites.net

Deploy the QlmCustomerPortalApp Service

• Go to the Azure Portal and click the QlmCustomerPortalApp App Service.

• In the left-hand panel, locate the Deployment node, expand it and select Deployment Center.

• Click the Source drop down and select "Publish files"

• Locate the QlmCustomerPortalAppNetCore.zip file in %Public%\Quick License Manager\DeployToAzure and select it

• Click Save

• Once the deployment is completed, you can access the QLM Portal API at the following URL: https://qlm-portal-app.azurewebsites.net

Upgrading your QLM License Server from v20.x to v20.y

To upgrade your QLM License Server to a new version, install the latest version of the QLM Management Console on your workstation and repeat the steps starting from the "Deploy packages to your App Services" section of this article.