Installation: Configuration Utility reports it can not connect to my database server, but I am sure the username and password are correct.
When setting JobTraQ up to use an existing instance of SQL Server, certain caveats apply:
- JobTraQ® can only run on versions 2000 and later.
- JobTraQ® can only connect to SQL Server using "mixed mode" authentication,
- NT authentication is not supported.
If you install JobTraQ over an existing installation of SQL Server, that server must use Mixed Mode authentication. SQL server can run in two authentication modes. The first, Windows Authentication mode, requires services and or applications to run as a specific windows user to gain access to database resources. This is not practical in a large scale environment such as is often supported by JobTraQ. The second mode, mixed mode, allows SQL server to maintain an independent user account base. JobTraQ, like most web based applications requires mixed mode authentication so that JobTraQ can control the access to the database resources regardless of windows accounts or licenses.