- Email issues
- On-premise version issues
- Integrations and migrating from other apps
- Errors and solutions
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
An example of an error you might get with wrong collation:
System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@ruleID".
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)