Sigmafine SQL Access Publisher Service

The Sigmafine SQLAccess Publisher is a Windows Service with the ability to process the publishing requests that are submitted by users. In addition, the service has the responsibility to detect when Sigmafine Analysis Cases are Run, and any changes over Sigmafine tables configured for self-publish. In such cases, the service activates an automatic publish request. As the service runs, it records to a log file (SQLAccessPublisher_Trace.txt) stored in the service installation directory. you can view live messages in the log file by running the ViewLog.bat batch file.

The Sigmafine SQL Access Publisher Service should be configured to run under a Windows account ("Log on" as) having the privileges specified in the following table for each system:

Required Access Privileges for Each System

System	Required Privileges
Sigmafine SQL Access REST Services	The publisher service’s windows user should be a registered user having ‘Admin’ privileges (Sigmafine SQL Access Publisher Service is a client of Sigmafine SQL Access Services).See User Management section.
SQL Server instance(The SQL Server instance used to publish data over SQL Server)	When the authentication for the SQL Server connection is configured as Windows Authentication, the publisher service’s windows user should have the following privileges over SQL Server:Can create a databaseCan modify the table schemaCan Read/write data over the tables
PI Server(The PI Server used to publish data over PI tags)	If publishing over PI Server tags is needed, the publisher service’s windows user must be able to connect to the designated PI Server, and must be able to write values over the configured tags.
Sigmafine Server(AF Server and Sigmafine database connected for data publishing)	The publisher service’s windows user must be able to connect to the AF Server and Sigmafine database configured for data publishing. Furthermore, it must be able to read data from Sigmafine Analysis Cases and Sigmafine tables.