Loading...

Knowledge Center

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

Environment

McAfee ePolicy Orchestrator (ePO) 5.x

All supported Microsoft SQL servers

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

Summary

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

Problem

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.

Solution

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>

    Examples: 
    EPO53SVR\EPOSERVER,1433 
    EPO53SVR,1433
     
  7. Type the SQL database credentials.
  8. Click Test Connection.

Rate this document

Beta Translate with

Select a desired language below to translate this page.

Glossary of Technical Terms


 Highlight Glossary Terms

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