Step 1: Confirm the database schema version

Execute the following query against the compliance database to confirm the database schema version:

select * from DatabaseConfiguration where Property = 'CMSchemaVersion'

Step 2: Verify the SqlProceduresClr assembly is configured in the database

Execute the following query against the compliance database:

select a.name, a.clr_name, a.permission_set_desc, a.create_date, content_len = LEN(af.content)
from sys.assemblies a
    join sys.assembly_files af on af.assembly_id = a.assembly_id
where a.name = 'SqlProceduresClr'

Sample results look like:

The content_len value should reflect the size of the SqlProceduresClr.dll file that comes with the FlexNet Manager Suite release in use.

Step 3: Check certificate, login and user configuration

Execute the following query to check an appropriate Flexera certificate is configured and mapped to a login and user:

select sp.name, sp.principal_id, dp.name, dp.principal_id, c.name, c.cert_serial_number, c.expiry_date
from master.sys.certificates c
    left outer join master.sys.server_principals sp on sp.sid = c.sid
    left outer join master.sys.database_principals dp on dp.sid = c.sid
where c.name like 'Flexera%'

Sample results look like:

Verify that the cert_serial_number value matches the serial number of the certificate from the version of FlexNet Manager Suite in use. You can find the serial number of the certificate by opening the original .cer certificate file from Windows Explorer and viewing the Details tab:

NOTE: The expiry_date value doesn't need to be in the future for the certificate to be usable.

Step 4: Check the Flexera login has 'UNSAFE ASSEMBLY' permission

Execute the following query to check that the UNSAFE ASSEMBLY permission has been granted to the Flexera login:

select sp.name, sperm.grantee_principal_id, sperm.permission_name, sperm.state_desc
from master.sys.server_principals sp
    join master.sys.server_permissions sperm on sperm.grantee_principal_id = sp.principal_id
where sp.name like 'Flexera%'

Results should include a record like the following:

Step 5: Check CLR is enabled

Execute the following query to check that CRL is enabled:

select name, value_in_use, description
from sys.configurations
where name = 'clr enabled'

Results should look like the following, with the value_in_use value of “1”:

If the problem persists after making adjustments based on these steps, create a support case that includes your results and error messages you received.