What’s the problem?
There are two methods for installing an ISV license on a Dynamics 365 Finance and Operations. Those methods are described here. But what if you cannot use either option available? On Tier-1 Dev and Test environments you only have elevated admin privileges for the User supplied from LCS, so you cannot use the command prompt to install an ISV license. And you cannot apply an ISV License package from LCS to that environment. So, what do you do? We recently had a customer whose ISV solution added a license to their module. We were able to successfully install the new module and the license file on a cloud-hosted Development VM using the command prompt method described in the post above (see section Create a package and generate a customer-specific license, item #3). We checked the code into Source control, but we couldn’t apply the license on the Tier-1 Dev and Test environment using the command prompt method and we could not use the “apply package” method. But you can manually apply the license code using a SQL script directly on the sysConfg table in the AxDB database.
What to do
- You must have first installed the license file on another environment, such as we had done on the cloud-hosted development VM.
- Find the corresponding key in the sysConfig table in the AxDB database. We found the corresponding key in the table by searching the table for the same license value as we see in the license text file from the ISV.
- The ID value from the sysConfig table is important as we would need to update the same record on the sysConfig table in the Tier-1 environment. We used the same information from the sysConfig table from our cloud-hosted development VM. Here is the SQL script we used in the Tier-1 AxDB database
- After updating the table, we ran a database sync.
This technique is only required on Tier-1 Dev and Test environments where you do not have full admin access because you will not be able to use the command prompt to install the ISV license, and you cannot apply an ISV license package via LCS to a Tier-1 environment.