When trying to Restore SSAS Database get error The Request is not supported

Marius Smit 5 Reputation points
2025-02-27T11:33:30.2533333+00:00

Good Day,

I am trying to restore a SSAS Database on SQL 2019, however keep getting the error:

The following system error occurred: The request is not supported. (Microsoft.AnalysisServices.Core)

I have tried running SSMS as admin and made sure my use has SSAS Admin rights and folder rights.

The database does restore fine on other server except this one.

What was tried and checked:

  1. Tried with SSMS normaly and logged in as administrator
  2. Tried another version backup of the SSAS Database
  3. Tested the SSAS Backup on another machine (Worked Fine)
  4. Made sure the logged user has rights to the SSAS Data Folder and Backup Folder
  5. Tried the backup from another folder
  6. Tried recreate database with xmla (same error)

Full Error text:

=================================== The following system error occurred: The request is not supported. The following system error occurred: The request is not supported. The following system error occurred: The request is not supported. (Microsoft.AnalysisServices.Core)

Program Location: at Microsoft.AnalysisServices.Core.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError) at Microsoft.AnalysisServices.Core.AnalysisServicesClient.Restore(String file, String databaseName, String databaseID, Boolean allowOverwrite, ICollection locations, RestoreSecurity security, String password, String dbStorageLocation, ReadWriteMode readWriteMode, Boolean ignoreIncompatibilities) at Microsoft.AnalysisServices.Core.Server.Restore(String file, String databaseName, Boolean allowOverwrite, RestoreLocation[] locations, RestoreSecurity security, String password, String dbStorageLocation, ReadWriteMode readWriteMode, Boolean ignoreIncompatibilities) at Microsoft.AnalysisServices.Core.Server.Restore(String file, String databaseName, Boolean allowOverwrite, RestoreLocation[] locations, RestoreSecurity security, String password, String dbStorageLocation) at Microsoft.AnalysisServices.ManagementDialogs.RestoreDialogBase.DoPreProcessExecution(ExRunType runType, ExExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(ExRunType runType) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForOlap(ExPreProcessExecutionInfo executionInfo, ExExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExExecutionAwareSqlControlCollection.PreProcessExecution(ExPreProcessExecutionInfo executionInfo, ExExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.ExExecutionAwareSqlControlWrapper.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,323 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.