App Control: Server upgrade failure Common language runtime (CLR) execution is not supported under lightweight pooling

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Not able to complete an App Control Server upgrade because of the following error:

A critical database script 'migrate' needed to install the Cb Protection server failed with an error.
Common language runtime (CLR) execution is not supported under lightweight pooling. Disable one of two options: "clr enabled" or "lightweight pooling".

 

Environment

• App Control Server: All Versions
• Microsoft SQL Server: All Supported Versions

Cause

SQL Server's lightweight pooling is enabled.

Resolution

1. If there is a DAS database backup taken prior the update, restore the backup.
2. Logon into the DAS database with an SA account and execute the following query:

   USE master
   GO
   EXEC sp_configure 'show advanced options', 1
   GO
   RECONFIGURE WITH OVERRIDE
   GO
   EXEC sp_configure 'lightweight pooling', 0
   GO
   EXEC sp_configure 'clr enabled', 1
   GO
   RECONFIGURE WITH OVERRIDE
   GO
   EXEC sp_configure 'show advanced options', 0
   GO

3. Execute the App Control Server upgrade installer again and complete the upgrade.