June 16, 2009 at 1:09 am
Hello SSAS Experts,
In one of the SSAS project I connected to the SSAS database from BI. I only dropped and then re-created few objects there and saved the changes.
Then after I took a backup of my SSAS database torestore it to a different machine but during restoration I am getting the below error:
Please note that MYSSAS is the server from where the backup was taken.
All servers are running SQL 2005 DEV SP2
===================================
Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'MySSAS' server.
Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'MYSSAS' server.
Either a connection cannot be made to the MYSSAS\SQLAna2k5 server, or Analysis Services is not running on the computer specified.
Errors in the metadata manager. An error occurred when loading the Invoicing times 1 dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\FlexLab_New.2.db\Invoicing times 1.0.dim.xml'.
Errors in the metadata manager. An error occurred when loading the FlexLab_Economy cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\FlexLab_New.2.db\FlexLab_Economy.52.cub.xml'.
(Microsoft.AnalysisServices)
Any Idea?
June 16, 2009 at 3:46 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic735486-147-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply