0

I fully understand that SharePoint 2016 DBs must be on SQL SERVER 2016+. My question is NOT related to SharePoint databases (DBs SharePoint uses to manage the site).

However, my environment has many 2008R2 databases. SSRS reports run independently through Report Server (2008 Report Server). However, we also have SharePoint2010 (through Excel services) grabbing data from both SQL Server 2008R2 DBs as well as SSAS (2008). What is the compatibility of those with SQL Server 2008R2?

Could Excel Services (Office Online) access SQL 2008? Are there any documentation on these compatibilities? Because I was unable to find anything.

Improve this question
2
  • There is this and also this. hope it helps. Commented Feb 2, 2018 at 6:51
  • @JohnKelheim thank you, this gave me a very good point to look for. However, those links 1) were for 2013, and 2) did not specify, even for 2013, what versions of SQL would be supported. Commented Feb 3, 2018 at 2:17

1 Answer 1

Reset to default
0

I haven't tried with SQL 2008/R2, but this article gives no limitation to the used AS-Versions:

https://technet.microsoft.com/en-us/library/jj219634(v=office.16).aspx#Software%20requirements%20for%20Excel%20Online

If you plan to use Excel Online with advanced data models, at least one SQL Server Analysis Services in SharePoint mode must be registered in the Office Online Server configuration. Excel Online can use multiple Analysis Services servers, but they must all use SQL Server Management Studio. For more information, see Download SQL Server Management Studio (SSMS). Note that if you use multiple Analysis Services servers with Excel Online they don't need to be SQL Server 2016.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.