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. Whenever I attempt to edit an automation rule, I get this error below:

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 (Vlad)      Updated: 11/26/2021 6:08 PM (Alex)
Files   
image001[1].png
37.2 KB
OriginalEmail[10].eml
136.4 KB
OriginalEmail[2].eml
146.3 KB
OriginalEmail[3].eml
149.2 KB
OriginalEmail[4].eml
108.3 KB
OriginalEmail[5].eml
159.1 KB
OriginalEmail[6].eml
210.8 KB
OriginalEmail[7].eml
189.1 KB
OriginalEmail[8].eml
189.7 KB
OriginalEmail[9].eml
188 KB
Solving problems with on-premise version of Jitbit Helpdesk ticketing system