Skip to main content

Database, SQL Server

I'm not familiar with databases, can I still use it?​

By simply following the instructions on the installer screen,
the database necessary for using TimeTracker RX will be created, and you can start using it.

You will need to use SQL Server management tools to manage the database,
The procedure for doing so is also explained in the "Database Management Guide", so please don't worry.

How do I install SQL Server?​

Please refer to the "Installation Procedure" published by Microsoft, the seller of SQL Server.

Notes​

  • During installation, please set the SQL Server authentication mode to 'Mixed Mode'.
  • When using mixed authentication mode, set the password for the "SQL Server system administrator (sa) account". This password is required when installing TimeTracker RX, so please be sure to manage it carefully.
  • SQL Server Management Studio (SSMS), used for database backups and troubleshooting, also uses the above password to connect to SQL Server.

Are there any limitations when using SQL Server Express?​

SQL Server Express is a free edition of Microsoft SQL Server. There are no functional limitations when using TimeTracker RX.

However, SQL Server Express has the following limitations compared to the paid edition:

  • Maintenance plans are not available, so "regular database backups" are not possible. Manual DB backups are required.
  • Even with a high-spec database server, the software has the following limitations. Therefore, the problem of "the server specs are sufficient, but it doesn't work" may occur.
    • Physical Memory Capacity: 1GB
    • DB Size Capacity: 10GB

Depending on the scale of your license, we cannot guarantee sufficient performance due to the "Maximum Available Resources" mentioned above. Therefore, please use this only if you have fewer than 10 TimeTracker RX licenses.

info

This may vary depending on the scale of your project and items, so please use this as a guideline and we recommend regularly monitoring your database capacity.

We have received inquiries from users using Express in environments with more licenses than those listed above, regarding resource-related issues, such as the following:

In this case, we will guide you towards migrating to the paid version.

  • Slow loading of timesheets
  • Unable to save projects

If using in conjunction with other applications, please build the database on a separate instance of SQL Server.

Last updated on