1 of 1 people found this helpful
Can you tell me how your connection is broken? Have you changed the name/ip of your SQL Servers?
Please also see below:
Check the connection string in Program Files\PIPC\AF\AFService.exe.config. The connection string is located in the
section and looks similar to the following:
<add key="connectString" value="Persist Security Info=False;Integrated Security=SSPI;server=FQDNOFSQLSERVER\SQLEXPRESS;database=PIFD;Application Name=AF Application Server;" />
Make sure that the server and database specified in the configuration file are correct. If the SQL Server is not local, the hostname must be specified as follows:MySQLServer\SQLEXPRESS.
Some reference page from our installation guide is as below:
Actually, I installed the AF Server just now and the connection has never been established.
SQL Server and PI System are on the same node.
I checked the configuration file it seems correct(As below),
<add key="connectString" value="Persist Security Info=False;Integrated Security=SSPI;server=V-WINSRV12\sqlexpress;database=PIFD;Application Name=AF Application Server;" />
In addition, I found the PI AF Server Health is 1.
2 of 2 people found this helpful
I see. in which case, you may need to install 'PI AF database' for your SQL server. But first please check if you have 'PIFD' database within your MS SQL Server. You can check it via SQL Server Management Tool(SSMS)
When repairing/installing your AF Server, have you checked the running PI AF SQL database scripts to be run? If this is not checked, please run the installation kit again to add this feature.
Hi @david du,
Which Version of sql express are using?