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)