Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

TAC Vista can not read trend values but all values get written to the SQL Server

Issue

TAC Vista can not read trend values but all values get written to the SQL Server

Test Connection to SQL server from Server Setup is working

No queue files

Environment

TAC Vista

SQL Server

Cause

If TAC Vista runs as a Service it will try to access the SQL data using the account it is started under if you have configured SQL to use Windows user.

If the account that the TACOS Service runs under does not have access to the SQL server you will not be able to read any values.

The DSS writer service that is used to write the values in to the SQL Database is using the account that is set up in the TAC Vista server setup.

Resolution

Make sure that the TACOS server runs under an account that have access to the SQL server.

Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2018-09-06 11:05 AM
Updated by: