Can't start self hosted service

[DannyC]

Hi,

I'm getting this error trying to start the Jiwa 7 API self hosted service.
Version 7.2.
The config file has been modified correctly with valid SQL server name, database name, username & password.
REST API plugin is enabled.

[SBarnes]

I believe the issue is related to trying to run the Web API on SQL 2008 as the SQL syntax in the error is only available on SQL 2012 or above but Mike or Scott will need to confirm this.

[Scott.Pearce]

I reckon Stuart has nailed it.

Offset . . .Fetch Next syntax is SQL 2012 and later. Check your SQL server version and upgrade it as necessary.