Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-32495%22%20slang%3D%22en-US%22%3ECan%20SQL%202016%20be%20used%20with%20Project%202016%20for%20OLAP%20cubes%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-32495%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20software%20reqs%20%3CA%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2FEN-US%2Flibrary%2Fee683978%2528v%3Doffice.16%2529.aspx%3Ff%3D255%26amp%3BMSPPError%3D-2147217396%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Edocument%26nbsp%3B%3C%2FA%3Efor%20Project%20Server%202016%20clearly%20states%20that%20it%20supports%20%22Microsoft%20SQL%20Server%202016%20RTM%22.%20But%20further%20down%20in%20the%20same%20doc%20under%20the%20heading%20of%20%22Cube%20Building%20Service%20requirements%22%2C%20it%20states%3A%20%22SQL%20Server%202014%20is%20the%20supported%20database%20server%20for%20SharePoint%20Server%202016%20Enterprise%22%2C%20and%20also%3A%20%22SQL%20Server%202014%20Analysis%20Services%20must%20also%20be%20installed%20on%20your%20SQL%20Server%202014%20database%20server%20for%20your%20SharePoint%20Server%202016%20Enterprise%20deployment%20if%20you%20plan%20to%20use%20the%20Cube%20Building%20Service%20in%20Project%20Server%202016.%22%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20is%20SQL%202014%20Analysis%20Services%20required%20to%20support%20the%20project%20server%20cubes%2C%20or%20is%20the%20documentation%20out%20of%20date%20and%26nbsp%3BSQL%202016%20Analysis%20Services%20is%20fully%20supported%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-37531%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20SQL%202016%20be%20used%20with%20Project%202016%20for%20OLAP%20cubes%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-37531%22%20slang%3D%22en-US%22%3E%3CP%3EI%20got%20it%20to%20work%20using%20SQL%20Server%20Analysis%20Services%202016%20along%20with%20Project%20Server%202016.%20The%20trick%20is%20to%20install%20the%20SQL%20AMO%20from%20the%202014%20Feature%20Pack%20on%20the%20SharePoint%20app%20server%20that%20is%20running%20the%20Project%20Service%20Application%20and%20then%20restart%20the%20Project%20Service%20Application%20service%20(or%20do%20a%20reboot).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Michael Gauntlett
Contributor

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 requirements", it states: "SQL Server 2014 is the supported database server for SharePoint Server 2016 Enterprise", and also: "SQL Server 2014 Analysis Services must also be installed on your SQL Server 2014 database server for your SharePoint Server 2016 Enterprise deployment if you plan to use the Cube Building Service in Project Server 2016." 

 

So, is SQL 2014 Analysis Services required to support the project server cubes, or is the documentation out of date and SQL 2016 Analysis Services is fully supported?

1 Reply

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).

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies