MS SQL & storage questions


1. I’ve some doubts on the MS SQL licensing.
Jitbit offering unlimited agents, which means all the agents can login and manage the system. Does that mean I need to purchase 50 MS SQL License if I have 50 jitbit agents? How about end users?

2. Location to store ticket attachment. Where actually Jitbit keeps the attached file (e.g. pdf, excel…. Etc)? is it store directly in SQL table?

3. Can Jitbit connect to other Database Engines? MySql for example


1. Jitbit Helpdesk uses just one "database user" account to connect to the database. However, MS licensing is tricky. They don't count "database users", they might want you to buy a license for every actual user who uses the application. You might want to look at "core" licensing that does not count users, but processor cores. Also, note that the free SQL Express Edition should work fine in most cases. You'll think about licensing once your database gets big (10GB of data, and that's not going to happen soon).

2. Attachments are stored in the database, yes, but there is a way to move them to disk. You'll find this key in the "web.config" file (for versions 9.x and earlier):

<add key="AttachmentsPath" value="c:\xxx\yyy" />

Or "appsettings.json" file for versions 10.x and later

"AttachmentsPath": "c:\\xxx\\yyy",

Point it to the right folder and that's it. Just make sure the folder has "write" permissions for the account that runs the application process.

3. No, sorry, only MS SQL Server is supported
Creation date: 11/6/2017 6:36 AM      Updated: 8/14/2023 9:57 AM
Solving problems with on-premises version of Jitbit Helpdesk ticketing system