It is also possible that you do have the SQL Server Native Client installed but you may have enabled a TLS version that is not compatible with the Native Client you have installed. PI OLEDB itself doesn’t use the TLS protocol to talk to the PI AF Server, but the PI AF Server uses the SQL Server native client to communicate with SQL when a OLEDB connection is made.
You can inspect what versions of TLS you have enabled by inspecting these keys on your SQL server:
DisabledByDefault set to 0.Enabled set to 1
Microsoft has released a version of SQL Server Native Client that supports newer TLS versions. You can download and install that here.
Download Microsoft® SQL Server® 2012 Native Client - QFE from Official Microsoft Download Center
It actually looks like your PI AF server cannot connect to its own back-end SQL server. You might want to check your AF Service and its connection to SQL on that machine. As the message suggests, you can check the AFService.exe.config (in the installation directory of PI AF) to make sure it is pointed to the correct SQL server and database. If the connection string looks correct, then you may want to check the SQL server and make sure it is available to your PI AF service.
I have Microsoft SQL Server 2012 native client version 11.0.2100.60 installed in my server but i still get the same error. Pls help
I have the same issue. Tried installing the SQL Server Native Client but did not work. And also I do not see the below keys on my SQL Server
This issue is just with PI SQL Commander. PI system Explorer connects to the AF Server successfully.
You may have to manually create the keys if they don't exist. Often a restart of the computer is needed after installing the latest native client. You can also take PI out of the equation by creating a .udl file on your system that uses the SQL Native Client and connect to your SQL server that houses your PIFD.
As a side note PSE does not use SQL Native Client to connect.
I was too concentrated on my SQL Server that I overlooked that "SQL Native Client " was not installed on my AF Server. Just installed it and all good.
Retrieving data ...