Upgrade encryption

Applies to: SQL Server Analysis Services Azure Analysis Services Power BI Premium

SQL Server 2022 Analysis Services CU1 includes enhanced encryption for certain write operations to the model database schema. To ensure your model databases use the latest encryption, those databases must be upgraded. If encryption isn't upgraded, certain database schema write operations, such as adding a new data source or altering connection strings are blocked and an error is returned.

Caution

New or upgraded Analysis Services databases with enhanced encryption cannot be loaded if SQL Server CU1 is uninstalled.

Tabular mode

For tabular model databases at the 1200 and higher compatibility level, the following error can be returned during certain schema write operations:

"New Tabular database '%{DatabaseName/}' is not using latest encryption schema. Please run RemoveDiscontinuedFeatured command with EnsureProperEncryption option (or restore DB from backup file with the same option) to upgrade to the latest encryption."

To upgrade encryption, either backup the database and then restore with the EnsureProperEncryption option enabled, or if the database is already loaded, run the following XMLA command in SQL Server Management Studio:

<RemoveDiscontinuedFeatures xmlns=http://schemas.microsoft.com/analysisservices/2003/engine xmlns:ddl922=http://schemas.microsoft.com/analysisservices/2022/engine/922>
  <DatabaseID>DatabaseName</DatabaseID>
  <ddl922:EnsureProperEncryption>true</ddl922:EnsureProperEncryption>
</RemoveDiscontinuedFeatures>

Multidimensional mode

For multidimensional model databases at all compatibility levels, the following error can be returned during certain schema write operations:

"Multi-dimensional database '%{DatabaseName/}' is not using latest encryption schema. Please create a backup file and restore DB from backup file with the option EnsureProperEncryption to upgrade to the latest encryption."

To upgrade encryption, backup the database and then restore with the EnsureProperEncryption option enabled.

See also

Backup and restore Analysis Services Databases
Compatibility level for tabular models