Issue:
How to resolve the error "The 'SQLNCLI11’ provider is not registered on the local machine." This error is seen when trying to open the Tools menu or System Log Events, in Management Console.
Product Line:
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Environment:
PME Management Console
Cause 1
A connection error between SQL and PME has occurred.
Cause 2
The SQL Native Client version referenced in the error is not installed.
Resolution 1
1. Reboot the PME application server
2. If the issue persists, refer to this video https://youtu.be/XJmUCK5uqPY to test the SQL connection using a UDL file
3. Troubleshoot the connection to SQL server using suggestions from this Microsoft article: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/resolve-connectivity-errors-overview#common-connectivity-issues
Resolution 2
1. In the Windows Start menu, search for and open “ODBC Data Sources (32-bit)”
2. On the Drivers tab, scroll down and look for SQL Server Native Client 11.0
3. If not found in the list, download it from https://www.microsoft.com/en-us/download/details.aspx?id=50402
4. Install SQL Server Native Client 11.0 by running the ENU\x64\sqlncli.msi file
