I created a new fresh SharePoint 2013 farm with two servers ( win 2012 R2)
- Application server ( running, secure store,performance point service, )
- wfe server
after that i created a simple BI site and opened dashboard designer and try to connect to SSAS server.
SSAS SERVER ( SQL SERVER 2008 R2 ( 10.50.2868.0)
Problem:
When i connect to ssas server database from dashboard designer , it can not load any databases and database list is always empty.
when i enable verbose logs, i found below errors in application server logs.
An unexpected error occurred. Error 33056. Exception details: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' at Microsoft.PerformancePoint.Scorecards.BIMonitoringServiceApplication.GetRenderCo
Note:
this SSAS datasource is in production server, it already sharepoint 2010 Bi site connected to these data sources and every thing working perfectly.
but from sharpoint 2013 there is no connectivity to this same ssas server
when i search in the net i found some people say to install
https://www.microsoft.com/en-us/download/details.aspx?id=16978 (Microsoft® SQL Server® 2008 R2 Feature Pack)
but it can solve my issue and not disturb sharepoint 2010 production.