Helpdesk
General issues
Helpdesk
How-to's
Miscellaneous
Email issues
On-premises version issues
Integrations and migrating from other apps
Errors and solutions
FAQ
Other (legacy) products
Macro Recorder
AspNetForum
AutoText

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

SQL Server collation

Contents