SQL Server collation

Jitbit Helpdesk requires case insensitive server collation. If your server is case sensitive, then you can simply override this for Jitbit's database only.

Please run this SQL query against your database to resolve the issue:

ALTER DATABASE JitbitHelpdesk

COLLATE SQL_Latin1_General_CP1_CI_AS

An example of an error you might get with wrong collation:

Exception:
System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@ruleID".
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

Creation date: 11/26/2021 5:13 PM Updated: 9/26/2022 10:37 AM

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