| What database support is needed |
| Written by Dave Wickert |
| Saturday, 30 January 2010 00:20 |
|
I get this question a lot and I thought that it was a good one to address here in the blog. If you look at the PowerPivot for SharePoint architecture, you know that we use several SQL Server 2008 R2 components within the architecture, but how about SharePoint itself . . . What RDBMS does PowerPivot with SharePoint 2010 use? and does it need to be R2? The answer is that we use the farm’s regular SharePoint RDBMS database instance. We do NOT need SQL 2008 R2 relational engine support for the SharePoint farm. SharePoint 2010 requires 64-bit SQL Server 2005 SP3 or later (yes, 64-bit is required), see http://technet.microsoft.com/en-us/library/cc262485(office.14).aspx for more details. And PowerPivot lives quite happily in that environment.
|
Author articles
- Video - Deploying and Managing Microsoft SQL Server PowerPivot for SharePoint
- General problems with Gallery snapshots not being taken - no items listed in the ULS log
- Importing XML data
- Data feeds: Cannot get schema? But it is there ...
- Snapshots not being taken
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
