Error on CreateTables.sql in Linux self hosted installation

Question:

I am trying to install Jitbit Helpdesk on Linux SQL Server and get following error when creating SQL tables. What might cause this issue?

CREATE INDEX failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

Answer:

If you execute the script sqlcmd, not via SSMS or other GUI-tools - then specify the "-I" flag like described in this answer https://stackoverflow.com/a/51201270/56621

installation linux self-hosted

Creation date: 12/27/2021 3:34 PM Updated: 3/17/2022 5:27 PM

Solving problems with on-premises version of Jitbit Helpdesk ticketing system