SharePoint 2016 and Business Intelligence

SharePoint 2016 and Business Intelligence - We are trying to setup a separate farm with SharePoint 2016 with SQL 2014 SP2. We already have a SharePoint 2013 farm with SQL 2014 SP2.  New SP 2016 farm will be a single web server using the same SQL on a separate named instance as of existing SP 2013 farm. I have some questions,

1. I read that SQL 2016 works better with SP 2016, but we have to use our current SQL 2014 SP2 server. Will there be any issues setting SP2016 with SQL 2014 SP2?
2. New SP 2016 farm will be used for BI only. Power Pivot, Power View, Power BI , SSRS etc. Can I achieve this with SQL 2014 SP2?
3. Do I really need to use Kerberos auth? Since I am going to use existing SQL server currently used by SP 2013 farm, Can the same SQL server (different named instance of course) work with NTLM for SP2013 farm and Kerberos for SP2016 farm??
4. Do I really need to have separate server for Office Online Server? (Office web apps-previously called)
Member_2_4982638Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
1. You can stand up a SharePoint 2016 farm using SQL 2014 SP2 no issues.
2. No, you need SQL 2016 for the full feature set https://docs.microsoft.com/en-us/sharepoint/administration/business-intelligence-0
3. Yes. It's a big investment and we decided against it
4. Yes. But it provides great features
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Member_2_4982638Author Commented:
Hi Jamie, Thank you for your response.
Upgrading to SQL 2016 is on the road map for us but not in the near future. I was trying to work with SQL 2014 and see I can bring up SP 2016 BI farm, so I guess that's no no??

 I didn't quite get your response for #3. Were you saying that you didn't go with kerberos? the BI stuff and OOS require kerberos as a mandatory, is that true?
0
Jamie McAllister MVPSharePoint ConsultantCommented:
Hi, regarding number 3, yes it's true we didn't implement Kerberos. Someone in the business did indeed want all these bi features, we had everything but kerberos so they never got what they wanted. Someone high up sees investment in SharePoint as a waste... oops.

For clarity though OOS does not require Kerberos. That's fine without. It was the SQL data being surfaced in SharePoint that required kerberos.
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Member_2_4982638Author Commented:
I am in a tricky situation here, I suggested that we will go with SP 2016 with SQL 2014 SP2 but I guess I didn't do much research before hand that Sp 2016 requires SQL 2016 for BI.
So to conclude, there is no way I can work with SQL 2014 SP2 for BI??? If there are workarounds I am open to try them.

if that's a complete no no, then I will have to recommend stay with Sp2013 and SQL 2014SP2.

Your final thoughts before I close this question...
0
Jamie McAllister MVPSharePoint ConsultantCommented:
The documentation says no I'm afraid.

https://docs.microsoft.com/en-us/sharepoint/administration/business-intelligence-0

Strictly speaking the other thing with SharePoint is it isn't recommended to share the DB with anything else including other SP instances.

Maybe that could be leverage to get SQL 2016 in for this.
0
Member_2_4982638Author Commented:
Agree with separate SQL server and that's the approach for production BI farm.

Final note, i was going through below article and it is stated that minimum SQL req. is SQL 2014 SP2 and for BI they say we need to install 2016 version of power view, power pivot add-in on SP 2016 server (Second Note under section "Section Minimum requirements for a database server in a farm"). I am tempted to try this combination. Do you think it's worth a try, if anybody have done this???

https://docs.microsoft.com/en-us/SharePoint/install/hardware-and-software-requirements
0
Jamie McAllister MVPSharePoint ConsultantCommented:
My reading of this is that the BI components will only work with SQL 2016, even though a working farm without BI could be built on SQL 2014 SP2.
0
Member_2_4982638Author Commented:
Thank you. We finally decided to stay with SP 2013 and SQL 2014 SP2 for now. When we upgrade to SQL 2016, we might go for SP 2016.
0
Member_2_4982638Author Commented:
We finally decided to stay with SP 2013 and SQL 2014 SP2 for now. When we upgrade to SQL 2016, we might go for SP 2016.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Business Intelligence (BI)

From novice to tech pro — start learning today.