Subscribe Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security. Subscribe

Unable to connect to SQL DB on Installation Wizard

I am trying to install the TestRail on my windows Server 2019. I have gone through the guide and followed all steps but I am having trouble on the Installation Wizard, when I get to step 2 for DataBase settings. I enter all information but it keeps saying:

Could not connect to the specified database: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user ‘testrail’.

i checked and the user can connect to the SQL DB. SQL is installed on the same server as testrail.

Hello @sameerrao,

Thanks for posting. You will likely need to enable SQL authentication on your database server as shown here.

Thanks, I managed to fix it from properties and select SQL and Windows authentication.