KTA 7.6 - Why is the database failing to install?

Question / Problem: 

After installing KTA 7.6, the summary screen shows the error "Error Installing database"

The CEBPMDatabaseErrorLog.txt has the following error message:

Msg 7736, Level 16, State 1, Server DEVDBSQL02, Line 1
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 should resolve the issue.  Once installed, rerun the KTA installation.

Bug 1292097: KTA 7.6 Installation Fails on SQL Server 2016 Standard Edition without SP1

Applies to: