Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to load the Vertipaq Engine Expand / Collapse
Author
Message
Posted Tuesday, November 15, 2011 10:25 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 7, 2014 1:29 AM
Points: 1,189, Visits: 787
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!
Post #1206171
Posted Wednesday, November 16, 2011 3:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 13,261, Visits: 10,140
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
Posted Wednesday, November 16, 2011 6:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, November 16, 2011 7:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 7, 2014 1:29 AM
Points: 1,189, Visits: 787
Yes, I installed the 32 bits version
Post #1206687
Posted Wednesday, November 16, 2011 7:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 7, 2014 1:29 AM
Points: 1,189, Visits: 787
Thanks Derek, I'll try that as soon as I get a minute.

Seems to make sense
Post #1206690
Posted Wednesday, November 16, 2011 7:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 7, 2014 1:29 AM
Points: 1,189, Visits: 787
Marvellous!

It worked. Many thanks

Post #1206708
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse