<div>
Hi,<br />
Ah that sounds like it would have done it. <br />
Our Network and System admin had attempted to do a reinstall of SSAS but it was giving him error's so he installed a new SQL instance. <br />
Thanks.
</div>


Hi,
Ah that sounds like it would have done it.
Our Network and System admin had attempted to do a reinstall of SSAS but it was giving him error's so he installed a new SQL instance.
Thanks.

<div>
<div class="content wysiwyg-content">
Hi<br />
&nbsp;<br />
I have a virtual test server which is running SQL Server 2008 R2, on it I have 2 SSAS databases which are linked to Sharepoint Dashboards I had everything was working fine then windows updates happend, in SSMS it only sees one of the databases but it has no content, no cube, no views and is no longer working on the dashboard now the really weird thing is that the other database has vanished from the SSMS entirely but is still working on the Dashboard. <br />
When I attempt to redeploy / process the databases I get error messages about their being errors in the metadata manager. from the error message it gives pointers to the database files and it seems that all of the objects are there.<br />
<br />
Currently I can't reprocess either database, neither can I delete the one SSMS can see. As it is a test server it wasnt being backed up by our IT guys due to lack of resources.<br />
<br />
Can anyone help shed some light on what's going on here? <br />
Thanks,<br />
David <a href="https://filedb.experts-exchange.com/incoming/2010/10_w43/359995/ERROR1.JPG" target="_blank" title="ERROR1.JPG (26 KB)"><img alt="ERROR1.JPG" class="file-block lazyload" style="max-width: 611px;" data-src="https://filedb.experts-exchange.com/incoming/2010/10_w43/359995/ERROR1.JPG" /></a>
</div>
</div>


ERROR1.JPG

Hi
 
I have a virtual test server which is running SQL Server 2008 R2, on it I have 2 SSAS databases which are linked to Sharepoint Dashboards I had everything was working fine then windows updates happend, in SSMS it only sees one of the databases but it has no content, no cube, no views and is no longer working on the dashboard now the really weird thing is that the other database has vanished from the SSMS entirely but is still working on the Dashboard. 
When I attempt to redeploy / process the databases I get error messages about their being errors in the metadata manager. from the error message it gives pointers to the database files and it seems that all of the objects are there.

Currently I can't reprocess either database, neither can I delete the one SSMS can see. As it is a test server it wasnt being backed up by our IT guys due to lack of resources.

Can anyone help shed some light on what's going on here? 
Thanks,
David 

Missing SSAS databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.