error while configuring SSRS in sharepoint farm

Question

Hi

after installing denali with sharepoint report services add in, you get a tool powerpivot configuration tool
here you validate the whole thing, and then run it, that all succeeded

then installing denali again, this time not with sharepoint for powerpivot, but selecting features, i pick analysis services, and
report services add in and stuff, just like the steps i follow from the guide (http://msdn.microsoft.com/en-us/library/gg492276(v=sql.110).aspx)

then starting up the sharepoint configuartion wizard: manual wizard. you see all the checkboxes leave them default , press ok
then its processing your configuration then i get an error that says:

The service application(s) for the service SQL Server Reporting Services Service Application could not be provisioned because of the following error: Invalid object name 'SQL Server Reporting Services Service ApplicationTempDB.dbo.TempDataSources'.

so that failed, but i can go to the sharepoint administration center. if you go to system settings => manage serveces on server you see that SSRS is started, but if you go to  Application manager => manage service application you see that SSRS service application is stopped but the proxy started, I click on the SSRS that is stopped, press properties then in the next screen just click OK and the following error appears

The version of database 'SQL Server Reporting Services Service Application_5ff9d39fb7ab4bfaa26bf11265c2ce68' on server 'MYSERVER\POWERPIVOT' is not supported by the current reporting services version.

I installed Windows server 2008 R2 + SP1  =>  sharepoint server 2010 with SP1 => denali RC0 
All 64-bit

Hope someone can help me 

regards
Matthias

Answer 1

I feel, there is some issue with the installation steps that you performed. Let me tell what we did:

1. Install SQL Server 2012 with BI except the reporting services two addins.
2. Ensure that you select the "Install only" option while installing SQL Server Reporting Services
3. Once you are done with this, install SharePoint .
4. While doing this, you need to point the SharePoint databases to SQL Server 2012 instance installed above.
5. After completing the install, install the Reporting Services addins.
6. Install PowerPivot for SharePoint
7. Install PowerPivot instance of SQL Server 2012
8. Configure the PowerPivot with SharePoint using the wizard avaialble
9. Now, upload the PowerPivot model into the gallery
10. You will see option to create PowerView on top of the PowerPivot model.

Hope this helps.

Regards,

---

Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

Answer 2

 Hi,

 Here is complate installation priocess video for PowerView. Follow this and it will 100% work   :)

 http://social.technet.microsoft.com/wiki/contents/articles/3726.power-view-overview.aspx

---

Cheers, Ashish

Answer 3

Well I followed this video from Mike Wilmot, now I only have one problem, i've got those SSRS working i think but when i try to start my 
Project crescent on a powerpivot excel workbook I got this error: 

<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://amdv-ss12-mpo01/sites/Crescent/PowerPivot%20Gallery/validation-error-infos-powerpivot.xlsx'. 
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.1440.19</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.1440.19</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.1440.19"
xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 
'http://amdv-ss12-mpo01/sites/Crescent/PowerPivot%20Gallery/validation-error-infos-powerpivot.xlsx'. 
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>Microsoft.AnalysisServices.SharePoint.Integration</Source>
<Message>The creator of this fault did not specify a Reason.</Message>
</MoreInformation></MoreInformation></MoreInformation></MoreInformation></MoreInformation>
<Warnings xmlns="http://www.microsoft.com/sql/reportingservices" />
</detail>