Windows Server 2003 SP2
SQL Full STD edition 2005 same box
I am in the process of installing HDLP9.1 Patch1 on our live environment. I have installed WCF and when running the DLP WCF service test I get a Test Database Connection error message:
<stringxmlns="http://schemas.microsoft.com/2003/10/Serialization/">FailureGetTable failed: Invalid object name 'DLP_Score'. atDLPData.Monitor.DataAccess.GetTable(String query, CommandType commandType,SqlParameter parameters) at DLPData.Monitor.DataAccess.GetSeverities() atDLPWCFLib.Admin.TestService.TestDBConnection()</string>
The other tests: Get Database Name, get client user, get named databse user, is user authorized work fine!!!!!
My testing in the test environment was okay and DLP works fine, the only difference being the version of SQL 2005 in the test env. box. A bit puzzled why it is broken in the live.
I've logged a call with McAfee just in case, but was wondering whether someone could provide assistance.
Feel really stupid:
I forgot to install the HDLP extensions on ePO and therefore thre were no DLP tables on SQL server (checking my ePO box in the test env. woke me up).
yes by the time I had installed the HDLP extensions, McAfee support had come back to me with this KB.
I told them that it would be helpful if the included this within their documentation, so customers are not misled to test the connection prior to installing the extensions.
Thanks anyway for taking time to post in htis thread. Much appreciated
Download the new ePolicy Orchestrator (ePO) Support Center Extension which simplifies ePO management and provides support resources directly in the console. Learn more about ePO Support Center
2821 Mission College Blvd.
Santa Clara, CA 95054 USA
Consumer Support | Enterprise Support | McAfee.com
Legal | Privacy | Copyright © 2019 McAfee, LLC