Error on CreateTables.sql in Linux self hosted installation

Creation date: 12/27/2021 3:34 PM    Updated: 3/17/2022 5:27 PM    installation linux self-hosted
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
Solving problems with on-premises version of Jitbit Helpdesk ticketing system