Loading...

Knowledge Center

How to test SQL database connectivity using the test.udl file
Technical Articles ID:   KB70929
Last Modified:  7/9/2018
Rated:

Environment

McAfee ePolicy Orchestrator (ePO) 5.x, 4.x

Microsoft SQL 2014
Microsoft SQL 2014 Express Edition
Microsoft SQL 2012
Microsoft SQL 2012 Express Edition
Microsoft SQL 2008
Microsoft SQL 2008 Express Edition
Microsoft SQL 2005
Microsoft SQL 2005 Express Edition

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:

2010-11-10 14:50:47,757 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 ePO's 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

Affected Products

Troubleshooting

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.