Skip to Content

Time Guardian did not create a MSSQL db and client software fails to open

247  Frank Mateo Thu, Mar 24, 2011  Time Guardian Pro 3.7 or lower, Time Guardian Series (TG 5.x, TG Plus 2.x, TG Pro 4.x) 1

The Time Guardian server install does not create a MSSQL db and the client software fails to provide access.

Fix:
  1. Browse to the Time Guardian db folder and run the mssql.sql script via MSSQL studio or SQL Query Analyzer
  2. Run the TG_Default_inserts.sql scripts towards the TG db
  3. Create a copy of the applicationContext.xml file in the Time Guardian conf folder then update the 17th line of the file with your db server’s IP address or computer name. The line should look like this:
            <value>jdbc:jtds:sqlserver://MSSQL_SERVER_IP_OR_NAME/tg</value>

Note: To identify a different MSSQL instance is used than the default:

            <value>jdbc:jtds:sqlserver://MSSQL_SERVER_IP_OR_NAME tg;instance=MSSQL_INSTANCE_NAME</value>
mssql sql ms sql microsoft database db
Rating: 1 (2 Votes)
  1.

    Please outline the modifications required to tg.conf and/or applicationContext.xml in order to connect to an mssql installation. I have taken the steps you mentions but TimeGuardian just stays at the splash screen and never gets going. Reply: We will need to remote in to generate the db in your ms sql. Normally this fails if the credentials are incorrect. Please call 800 896 7035.

Security Code

Get notified when new articles are added to the knowledge base.

Powered by PHPKB (Knowledge Base Software)