which server to install Microsoft Access Database Engine 2010 to?

Question

hi -  i have set up PowerPivot for SharePoint but can't data refresh to work properly.    The install guide mentions to use Microsoft Access Database Engine 2010 to schedule data refresh for workbooks that have Microsoft Access or Excel as their data source.      Do I install this on the SharePoint WFE or on the SQL database server?   I can't seem to find any documentation on it out there.

thanks

Answer 1

I would install it in the WFE Server (where your SharePoint services are running).

Answer 2

Hi SR,

Please refer to the following articles about enabming and configuring PowerPivot Data Refresh:
PowerPivot Data Refresh:http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint/thread/b111e250-43cf-42f4-ad6e-0022c866eab5
Enable and Configure PowerPivot Data Refresh: http://msdn.microsoft.com/en-us/library/ee210595.aspx
Configure Stored Credentials for PowerPivot Data Refresh: http://msdn.microsoft.com/en-us/library/ee210595.aspx

Regards,
Bin Long

---

Bin Long

TechNet Community Support