eNICQ 6 Error: ""CONCAT" is not a recognized built-in function name"

Reported Issue: When trying to install the eNICQ 6 database an error message the error '"CONCAT" is not a recognized built-in function name" appears during database creation. 

 

Root Cause: The most common reason for this error message is that the target SQL Server instance does not meet the minimum requirements for the eNICQ database.  A minimum of SQL Server 2012 is required.

Please click here for the eNICQ 6 System Requirements.  

Please check your server specifications against the requirements.  If you believe your server meets the requirements and are still seeing this message, please contact Vermont Oxford Network technical support.