Question / Problem:
The customer is performing an upgrade from KTA 7.4.1 to KTA 7.5 or higher. The upgrade fails on the the database with: "Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning".
Answer / Solution:
The installation script uses Partitioning when SQL Server 2016 or higher is detected. SQL Server 2016 Standard edition requires Service Pack 1 or higher for using this feature. Applying update SP2 to SQL Server 2016 Standard edition resolved the issue.
KTA 7.5 or higher requires at least SQL Server 2016 Standard Service Pack 1. With SP1, support is added for partitioning which is used for creating the databases. The technical specification guide does only state that SQL Server 2016 is supported. It does not state that for SQL Server 2016 Standard at least SP 1 is required. A defect is raised to have the technical specifications document updated. Resolution is to apply SP1 to SQL Server 2016 Standard.