CryptoLicensing Error

Question

I am currently evaluating several licensed applications for .NET, and the one that I found more convenient for work, but in functional terms is CryptoLicensing.

I downloaded CryptoLicensing v2011, configured WebService license activation, followed the install.aspx steps, and got a SQL Server database with 5 tables.

Then I went into the application and tried to generate a license, and I got the error message "Unable to insert a NULL value in the column identifier." I checked with SQL Profiler and in fact this column (which is the primary key column) does not appear in the insert statement. I noticed that there were 5 columns in the license table: ID, LicenseCode, MachineCode, LicSetting_ID, LicSetting_LicenseCode. So I changed the definition of the table: set the identifier as NULL and removed it from PK and set LicSetting_ID as PK.

Then I was able to generate licenses and verify. Now I would like to know if everyone has this problem or if I did something wrong.

I was thinking of buying CryptoLicensing, but I don’t want to “hack” the database to make it work.

Regards, Manuel Felicio.

Answer 1

I contacted their support, and they answered me quickly and efficiently (less than 10 minutes), so I said it here.

The problem was that I did not specify the table prefix when I created the licensing tables from the management application. The license service creates a table called "License", and the application creates a table called prefix + "License", which caused errors.

In any case, it was not clear to me that mandarin should indicate the table prefix. He is also working now.