When I opened the system explorer, an error occurred "AF Server cannot connect to specified SQL Server", I have checked the services and they seemed ok, who can help me to find what is the cause?
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.
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:
Cannot connect to the specified SQL Server
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.
I had this same issue. I fixed it by changing who the AFService was running as within services to an account with more proper permissions.
Hi @david du,
Which Version of sql express are using?
Retrieving data ...