When trying to Restore SSAS Database get error The Request is not supported
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:
- Tried with SSMS normaly and logged in as administrator
- Tried another version backup of the SSAS Database
- Tested the SSAS Backup on another machine (Worked Fine)
- Made sure the logged user has rights to the SSAS Data Folder and Backup Folder
- Tried the backup from another folder
- 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)