Enable SQL Server CLR

FlexNet Manager Suite requires Microsoft's SQL Server Common Language Runtime (CLR) Integration to be enabled prior to upgrading for increased performance.

Important: Failure to move the database to the new SQL Server instance prior to running the database upgrade scripts, can lead to Common Language Runtime (CLR)/Flexera certificate issues.

To enable SQL Server CLR:

1. In SQL Server Management Studio, locate the SQL Server instance to be used by FlexNet Manager Suite.
2. Enable Microsoft SQL Server Common Language Runtime (CLR) Integration.
   1. For SQL Server 2017 or later, you first need to install a Flexera signed security certificate which identifies the installation as a trusted assembly.
      Tip: If it happens that your various databases for FlexNet Manager Suite are on separate database servers running SQL Server 2017 or later, remember to install a copy of the certificate on each server, as follows.

      1. Download the file Flexera Signed Security Certificate for SQL Server 2017 and 2019.zip from the Product & License Center. Extract the FlexeraCodeSignining.cer file from the downloaded archive to a temporary location on the host where Microsoft SQL Server is running, in a file path to which the SQL Server service account has read access.
      2. Edit the SQLScript.sql file from the archive, and replace <location> with the path where you have copied the FlexeraCodeSigning.cer file. Save your change.
      3. Open SQL Server Studio and execute your updated SQLScript.sql file.
   2. Enable Microsoft SQL Server Common Language Runtime (CLR) Integration by executing the following stored procedure:

      sp_configure 'show advanced options', 1;  
                              GO  
                              RECONFIGURE;  
                              GO  
                              sp_configure 'clr enabled', 1;  
                              GO  
                              RECONFIGURE;  
                              GO 

      Note: By default the CLR integration feature is disabled and must be enabled by the DB system administrator before database creation and installation. CLR is disabled by default to increase security in shared hosting contexts. However, in this context, Flexera is a known vendor supplying trusted code for an environment fully controlled by your administrators. Flexera warrants that the CLR DLL signed by Flexera does not attempt to elevate privileges or behave maliciously.