- How-to's
- Miscellaneous
- Email issues
- On-premise version issues
- Integrations and migrating from other apps
- Errors and solutions
- FAQ
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)