Skip to main content

SQL Server Connection

Sigmafine Server access the PIFD and Sigmafine reporting database in SQL Server by using SQL server authentication, but for a SQL Server failover cluster environment, the domain user account that belongs to a domain group is applied instead.

To change the connection string for connection between PI AF server and PIFD, navigate to \\PIPC\\AF folder and modify the AFService.exe.config file by providing the name SQL server and the named instance in the connect string server.

Below are the following lines:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
 <appSettings>
 <add key="connectString" value="Persist Security Info=False;Integrated Security=SSPI;server=<SQLName>[\SQLInstance];database=PIFD;Application Name=AF Application Server;"/>
 <add key="streamedPort" value="5459"/>
 </appSettings>
</configuration>

If SQL Server is running on a cluster, it is important to use the clustered resource IP address, instead of a computer name:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
 <appSettings>
 <add key="connectString" value="Persist Security Info=False;Integrated Security=SSPI;server=<SQLClusterName>[\SQLInstance];database=PIFD;Application Name=AF Application Server;"/>
 <add key="streamedPort" value="5459"/>
 </appSettings>
</configuration>

If SQL Server is configured to use SQL Server mirroring, then add Failover Partner=<SQLServerName>[\<InstanceName>] after the server=, as shown in the following lines of code:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
 <appSettings>
 <add key="connectString" value="Persist Security Info=False;Integrated Security=SSPI;server=<SQLName>[\SQLInstance];failover partner=<SQLServerName>[\SQLInstance];database=PIFD;Application Name=AF Application Server;"/>
 <add key="streamedPort" value="5459"/>
 </appSettings>
</configuration>

Note:

  • SQL Server connection string is done automatically when you specify the name of the SQL server AF will use during installation
  • Please view the "PI AF SQL database installation in a fail-over cluster" documentation for more information on clustering procedures.