Using Windows Authentication

Solution

In case you need to use Windows Authentication (and not userid & password) to connect to the SQL Server, ITS NOT RECOMMENDED for the reasons below

All the TimeTrack users will not have the same credentials and it may not connect to the SQL Server for all the users.
Even if it starts working now, in future if the admin changes credentials for some users TimeTrack will crash
Any new users may not be able to access SQL server.

Advisable: Create a specific user for TimeTrack database and provide access

If you want Windows authentication, your conn.set file should have this one line only.

-------------------------------------------------

Provider=SQLOLEDB.1;Server=yourservername;Database=TimeTrack;Trusted_Connection=yes;

-------------------------------------------------

Replace yourservername with the actual server name

KeyWords: SQL Server, Windows Authentication, Connection, Trusted Connection

Was this article helpful? yes / no

Article details