1

Has anyone tried to install SP2016 with SQL 2016 SP? I checked https://technet.microsoft.com/en-us/library/cc262485(v=office.16).aspx and I know it's supported with SQL 2016 RTM.

My questions are

Is SQL 2016 SP1 support SP2016? What is the sql edition will be used standard or enterprise (farm has 2 DB Server)? and what's the difference between both from license and capability view.?

1

Technet says *Minimum* requirements for a database server in a farm. So any newer ServicePack of SQL Server 2016 is supported (including SP1).

Your second question is not really clear to me. Please specify your question if the following answer does not match your question: During Installation of SQL Server 2016 you have to enter a license key. This decides about the installed edition of SQL-Server. SharePoint can be installed on both Standard and Enterprise-Edition. Enterprise-Edition is only a requirement for some BI-Features. You also might need an Enterprise-license for database High-Availability (as you mentioned "2 DB Server").

1

SQL Server 2016 SP1 is fully supported for the SharePoint 2016.

SQL enterprise come with all features as standard only subset of it. For SharePoint, I would go for the SQL Enterprise edition, as this will give us full functionality of Always-On .

Check the below blog for more about SQL feature comparison. https://msdn.microsoft.com/en-us/library/cc645993.aspx

1

Is SQL 2016 SP1 support SP2016?

Yes, it's supported.

What is the SQL edition will be used standard or enterprise (farm has 2 DB Server)

It's recommended to use Enterprise edition especially if you will configure Always on availability group that not supported with the standard edition. but if you will configure Always-on failover cluster you can use Standard edition (Support for 2 nodes).

for more details check Editions and Supported Features for SQL Server 2016

what's the difference between both from license and capability view.?

Regarding capability, you can check also the above mention URL Editions and Supported Features for SQL Server 2016

Regarding Pricing, it's known the Enterprise is so expensive than standard as shown below

enter image description here

For more details check SQL Server pricing

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.