Creating the EUM Database on SQL Server 2012 / SQL Server 2014

|
Published

While running the EUM_PopulateSQLDatabase.ps1 an error is encountered if SQL server is lower than 2016 (SQL 2012 or higher is supported for the changes below). This is because SQL 2012 and 2014 does not support the ForJSON function used in a few Stored Procedures.

SQL_Error.JPG

Carry out the following steps to ensure that the functions and stored procedures are created:

SQL2012Steps1_3.JPG

SQL2012Steps4_5.JPG

SQL2012Steps7_8.JPG

SQL2012Steps9_11.JPG