Knowledge Center

How to test SQL database connectivity using the test.udl file
Technical Articles ID:   KB70929
Last Modified:  8/15/2019


McAfee ePolicy Orchestrator (ePO) 5.x

All supported Microsoft SQL servers

For details of ePO and SQL supported environments, see KB51569.


If you are experiencing a database connection issue, use the test.udl file to confirm the database credentials outside of ePO.


The following error in the orion.log file establishes that there is a database connection issue:

ERROR [Thread-1] plugin.PluginManager - Initialization of plugin core failed.
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'core.db' defined in URL [jndi:/localhost/core/WEB-INF/beans.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.mcafee.orion.core.db.base.Database]: Constructor threw exception;
nested exception is java.sql.SQLException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.


Confirm the database credentials outside of ePO using test.udl and the following steps:
  1. Create a file on the ePO server called test.udl.
  2. Double-click the test.udl file.
  3. Click the Provider tab.
  4. Select Microsoft OLE DB Provider for SQL Server.
  5. Click Next.
  6. On the Connection tab, enter the same information entered in the ePO core/config page for the database connection. In the Select or enter a server name field, type the SQL Server name in the following format: <servername>\<instancename>,<port>

    NOTE: If no named instance is in use, use the following format: <servername>,<port>


  7. Type the SQL database credentials.
  8. Click Test Connection.

Rate this document

Glossary of Technical Terms

 Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.