Cannot enable SQL PI when creating a database in the SQL Server PI repository (4228972)

Cannot enable SQL PI with the SQL Server PI repository because a message similar to the following appears

Failed to enable SQL PI monitoring extension

Suggestions

• Please retry. If the issue still occurs, please contact Quest Software technical support.

"Failed to enable SQL PI monitoring extension for SQL Agent AGENTNAME.

Failed to create SPI repository schema. Error: The server failed to resume the transaction. Desc:44000000106."

The environment is using SQL Server 2016 Standard RTM version which does not support data compression.

The built in installer script includes a block at the end of the script to compress the database.

 

WORKAROUND

None
 

STATUS

As per the Foglight for Databased deployment guide, the minimum supported release of SQL Server to be used a PI repository is SQL Server 2016 Service Pack 1 (SP1) [13.0.4001.0]

Upgrade the SQL Server version to 2016 SP1 (Service Pack 1) or higher (13.0.4001.0) for Windows Standard or Enterprise.