SQL Server collation

Creation date: 11/26/2021 5:13 PM    Updated: 9/26/2022 10:37 AM
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)
Solving problems with on-premises version of Jitbit Helpdesk ticketing system