SharePoint 2010: PRoject Crescent Feature is not working

Question

I have followed all the steps for the installation and configuration of Sharepoint 2010, Power pivot with Denali CTP3 option as guided in the Microsoft sites 
But Unfortunatly I am getting following error message while I click on the "Create Crescent Report" option from the "Document Library"

"An error occurred while loading the model for the item or data source 'http://dynsqldenali/Yellowstrom/Shared Documents/HelloWorldPicnicDenaliCTP3.bism'. Verify that the connection information is correct and that you have permissions to access the data source."

<detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsCannotRetrieveModel</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://dynsqldenali/Yellowstrom/Shared Documents/HelloWorldPicnicDenaliCTP3.bism'. Verify that the connection information is correct and that you have permissions to access the data source.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.1515.0</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">11.0.1515.0</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsCannotRetrieveModel" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.1515.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://dynsqldenali/Yellowstrom/Shared Documents/HelloWorldPicnicDenaliCTP3.bism'. Verify that the connection information is correct and that you have permissions to access the data source.</Message><MoreInformation><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsErrorOpeningConnection" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsErrorOpeningConnection&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=1.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Cannot create a connection to data source 'TemporaryDataSource'.</Message><MoreInformation><Source>Microsoft.AnalysisServices.AdomdClient</Source><Message>A connection cannot be made. Ensure that the server is running.</Message><MoreInformation><Source>Microsoft.AnalysisServices.SharePoint.Integration</Source><Message></Message><MoreInformation><Source>mscorlib</Source><Message>The version number of the local AnalysisServices in VertiPaq Mode service instance did not match the version associated with the bits on the machine. This usually occurs do to a failure during setup. The setup extension timer job is being started which should correct the problem."</Message></MoreInformation></MoreInformation></MoreInformation></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>

Answer 1

I think the root cause of the error is that you installed Juneau on top of Denali CTP3: http://support.microsoft.com/kb/2580208

This causes a mix of incompatible dlls that as a result cause PowerPivot System Service inside SharePoint to no longer work.  You should still be able to put your model on a stand-alone AS server outside the SP farm, and point Crescent to that one.

The issue is currently investigated, and already filed as a MSConnect bug here: http://connect.microsoft.com/SQLServer/feedback/details/684436/installing-project-juneau-on-a-denali-ctp3-project-crescent-installation-breaks-the-crescent-environment

HTH,
Robert

---

Robert Bruckner   http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

Thanks for the reply.

But I am sure that I havn't installed Juneau on top of Denali CTP3.

Though it would be helpful , if you could tell me how to verify that the Juneau is installed or not?

Or any other help in this regards would be appriciated.

Answer 3

The error message details you posted originally contains a SQL build number: 11.0.1515.0  

That build number is newer than Denali CTP3.  Hence, my assumption that you could have only gotten that build number if you installed the KB I mentioned in my previous response and/or Juneau, because they are build 1515.

HTH,
Robert

---

Robert Bruckner   http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.