Thursday, December 06, 2012 10:42 PM
I have followed each single steps on Mike Wilmot's video guide on channel 9:
However, the SharePoint 2010 Products Configuration Wizard failed in the end with the following error message:
The following errors were encountered while provisioning services:
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'.
Correlation ID: 4140caf7-b93b-4c0e-8bcb-632ee3acd364
The only difference between my environment and the video is that I am using SQL 2012 RTM and the video is using SQL 2012 RC01. And this error is repeatable during my install on several virtual machines.
My system includes:
Office2010(Excel)+PowerPivot add-ons for SQL2012
Anyone know what got wrong here? Thank you very much for any possible answers!
Friday, December 07, 2012 4:00 AM
Try to ignore the error message and see what happens.
Share the results please.
Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP
Tuesday, December 11, 2012 5:19 PMModerator
Based on the current information, the issue may occur due to one of the following factors:
- The service account you speicified for the application pool of the Reporting Services Service Application.
- The SSRS Service database server is invalid.
For the former possible reason, please be sure to use a managed account for the application pool. If it was not configured to use a managed account, you can associate the application pool with an existing managed account. For the detailed information, please see the "Create the Reporting Services service application and proxy" section of the following KB article:
Additionally, here is a blog about configuring SSRS 2012 to integrated with SharePoint 2010 for your reference:
SharePoint 2010 – SQL 2012 Reporting Services
Hope this helps.
If you have any feedback on our support, please click here
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Sunday, December 16, 2012 1:29 PM