TestRail 8.0 is available for Server customers who wish to upgrade urgently to an "early access" version. We recommend that all other customers wait until the "default" version of TestRail 8.0 is available. TestRail 8.0 "default" will be available after the release is deployed to cloud customers.
To connect to a SQL Server database when TestRail is installed on a Windows Server system, you need to install the Microsoft SQL Server Driver for PHP (called sqlsrv). This new extension is a high-performance driver optimized for PHP and SQL Server 2012, 2016, and 2019. TestRail doesn’t support the legacy SQL Server driver mssql that is still shipped with some PHP distributions.
The easiest way to install the sqlsrv extension is to install it together with PHP by using the process described in our PHP installation guide. If you have already installed PHP on your server without using the Web Platform Installer, you need to manually install this extension. You can download the driver from Microsoft’s website.
After extracting the files, please copy them to your PHP’s ext directory. To make PHP load the extension, just add the following line to your PHP.ini (this is for the non-thread-safe version of PHP, which you are most likely using when you have installed PHP to use IIS FastCGI, which we recommend):
extension=php_sqlsrv.dll
extension=sqlsrv_81_nts_x64Remember to NOT to include "php_" or ".dll" from the original filename in the above lines.
The driver also needs the ODBC Driver to be installed, so make sure to download and install it:
After you activated the extension in the PHP.ini configuration file and after you installed the ODBC Driver, please restart your IIS web server. You can check if the extension has been successfully loaded by running the phpinfo() function.