Error on CreateTables.sql in Linux self hosted installation

Creation date: 12/27/2021 3:34 PM    Updated: 9/16/2025 7:57 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 via sqlcmd, not via SSMS or similar GUI-tools - then specify the -I flag like described in this answer https://stackoverflow.com/a/51201270/56621

Solving problems with the on-prem, self-hosted version of Jitbit Helpdesk ticketing system