Explanation


Some stores will see an error connecting from Profill to Kroll to check for orders after performing an update. We are not certain about the cause of this error. It appears to affect some locations and not others.


The error shown in Profill will look (something) like this:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 


Named Pipes is a older networking technology that is still supported by Microsoft Databases and our connectivity library will fall back to it when the connection to Kroll times out.


Here is the fix:


Once applied Profill should not emit this error again.


  1. Close Profill and then re-open it to the default screen as shown. Avoid clicking on "Delivery Orders" yet.



  2. Next click "Central Fill" and then "Configure Central Fill"

  3. On the Kroll tab, click "Test" to check your connection.


    If it does not connect you'll need to call us.

  4. Finally, close the config window, and click on "Delivery Orders".

    Make sure it says "Production" in the indicated drop down. If it doesn't switch it and then attempt to use Profill like you normally do.