-
Título
Cannot enable SQL PI when creating a database in the SQL Server PI repository -
Descrição
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."
-
Causa
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.
-
Resolução
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. -
Anexos