Unable to load the Vertipaq Engine

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » PowerPivot » Unable to load the Vertipaq Engine

Unable to load the Vertipaq Engine

Rate Topic

Display Mode

Topic Options

Author

Message

Eric Mamet

Posted Tuesday, November 15, 2011 10:25 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 10, 2013 2:41 AM
Points: 1,129, Visits: 685

I was looking forward to play with this (new) toy but can't get anything working...

I have installed
- Office 2010 with Excel 32 bits
- Sql Server 2008 R2
- PowerPivot 10.50.2500.0 (the one coming with 2008R2 I think)
- Sql Denali ctp3

When I try to open the "PowerPivot Window" on a brand new spreadsheet, I get various error messages:
- Embedded Analysis Services Engine: Could not open embedded PowerPivot data. (twice)
- Then an option to "Do Nothing" or "remove the PowerPivot data"

Finally, I get an error message "Unable to load the Vertipaq Engine".

Any idea what I could do to fix this?

Should I install PowerPivot from Denali CTP3 instead of 2008R2?

I have already tried
- uninstal PowerPivot
- reboot
- re-install PowerPivot

But no joy so far...

Any idea welcome! Smile

Post #1206171

Koen Verbeeck

Posted Wednesday, November 16, 2011 3:00 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:54 AM
Points: 9,409, Visits: 6,494

The PowerPivot that comes off the SQL Server installation media is intended for integration with SharePoint. For Excel itself (locally on your desktop), you need to download a plug-in from www.powerpivot.com. Did you do this?

Make sure you download and install the 32-bit plug-in, as you have Office 32-bit. Even if you have a 64-bit OS!

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1206494

Derek Markel

Posted Wednesday, November 16, 2011 6:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, July 25, 2012 8:58 AM
Points: 4, Visits: 190

Try installing the Denali version of PowerPivot. After installing SQL Server Denali CTP3 on my PC I also received this error when trying to use the SQL 2008 R2 version of PowerPivot.

http://www.microsoft.com/download/en/details.aspx?id=26721

Post #1206629