Knowledgebase
TimeTrack support > TimeTrack support > Knowledgebase

Search help:


SQL Version Connection Error

Solution

Connection Error

When TimeTrack is not able to connect to SQL Server, the software will disconnect or not start and will give an error message saying "SQL Server does not exist or access denied".

Reasons

  1. Connection Parameters are wrong
  2. SQL Server not accessible.
  3. Firewall is blocking out going connections.

How to Check

  1. Open Ms-Excel
  2. Go to Data -> Import Data -> New SQL Server connection
  3. Enter the SQL Server parameters as displayed in the conn.set file.
  4. If MS-Excel connects to the SQL Server
    • Check if TimeTrack is running under administrator mode
    • Disable firewall and once again start TimeTrack
  5. If Ms-Excle does not connect
    • SQL Server parameters are wrong
    • The Server does not allow you to connect.
    • Only the company's IT Team can check and solve it.

 

KeyWords: Error, SQL Connection Error, Firewall Error, Access Denied.

 
Was this article helpful? yes / no
Related articles Using Windows Authentication
Database connection - SQL Server - Windows Authentication Mode
SQL Server version - Installation at Multiple PC's
Crashes Before entering Password
Software Slow
Article details
Article ID: 43
Category: SQL Server Version
Date added: 28/01/2014 11:34:17
Views: 525
Rating (Votes): Article rated 3.9/5.0 (7)

 
« Go back