Knowledgebase
TimeTrack support > TimeTrack support > Knowledgebase

Search help:


Using Windows Authentication

Solution

Using Windows Authentication

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

  1. All the TimeTrack users will not have the same credentials and it may not connect to the SQL Server for all the users.
  2. Even if it starts working now, in future if the admin changes credentials for some users TimeTrack will crash
  3. 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
Related articles Database connection - SQL Server - Windows Authentication Mode
Win7 Issues
SQL Version Connection Error
TTAutoOps - Standard Punch Report
SQL Server version - Installation at Multiple PC's
Article details
Article ID: 40
Category: SQL Server Version
Date added: 24/08/2013 13:34:52
Views: 438
Rating (Votes): Article rated 4.0/5.0 (4)

 
« Go back