SQL 2012 Power View installation issues

Question

I have followed each single steps on Mike Wilmot's video guide on channel 9:

http://channel9.msdn.com/posts/SQLShorts-Installing-and-Configuring-PowerPivot-Power-View-and-the-BI-Semantic-Model--BISM-

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:

Win2008x64 R2+SP1

SQL2012RTM

SharePoint2010+SP1

Office2010(Excel)+PowerPivot add-ons for SQL2012

Anyone know what got wrong here? Thank you very much for any possible answers!

-Eunice

Answer 1

Try to ignore the error message and see what happens.

Share the results please.

Cheers

---

Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

Answer 2

Hi Eunice,

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:
http://support.microsoft.com/kb/2723587

For the latter possible reason, if the SSRS instance is a named instance, please be sure to specify the <Server Name>\<Instance Name> for the "Database server" option.

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.

Regards,
Mike Yin

If you have any feedback on our support, please click here

---

Mike Yin
TechNet Community Support