Q: Can we connect the Client interface using SQL authentication?

A: Yes, you may use SQL authentication; however, if you do, you will need to add both the Windows user and the SQL user as users within TRAIN TRACK. When logging in to TRAIN TRACK, there are multiple levels of security. The user needs to log in to the user interface, and then also log in to the SQL database to retrieve the data. If you are using Windows authentication, the Windows user needs to be given permission both in TRAIN TRACK and in SSMS (SQL Server Management Studio). If you are using SQL authentication, then the Windows user only needs to be given permission in TRAIN TRACK, and the SQL user needs to be given permission both in TRAIN TRACK AND SSMS.

Authentication	Permission in TRAIN TRACK	Permission in SSMS
Windows	Windows User	Windows User
SQL	Windows User AND SQL User	SQL User

When using SQL authentication, multiple users may share the same SQL login; however, they will all need to have the same user level permissions. For different levels, you will need different SQL users.