Issue: A 3rd party application couldn´t connect to a MS SQL Database. In the log from the application you can see the error message 800A0E7A. How can you solve that?
Solution: Most 3rd party applications which need to connect to a MS SQL Database require the “SQL 2005 Native Client”. If this component is missing on the system where you installed the 3rd party application on you might see error messages like the following on the system:
Unable to open database at 'Provider=SQLNCLI;Initial Catalog=NME40DB;Trusted_Connection=yes;':
Description: Provider cannot be found. It may not be properly installed.
Message: Unknown error 0x800A0E7A
To solve that, download and install the “SQL 2005 Native Client” from here, which fits your OS: