Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

Michael Gauntlett

Brass Contributor

Nov 29, 2016

Can SQL 2016 be used with Project 2016 for OLAP cubes?

The software reqs document for Project Server 2016 clearly states that it supports "Microsoft SQL Server 2016 RTM". But further down in the same doc under the heading of "Cube Building Service requir...

Chad_Olson_Sensei

Brass Contributor

Jan 03, 2017

I got it to work using SQL Server Analysis Services 2016 along with Project Server 2016. The trick is to install the SQL AMO from the 2014 Feature Pack on the SharePoint app server that is running the Project Service Application and then restart the Project Service Application service (or do a reboot).