cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Dynamic watchlist with MSSQL connection

Hi,

I'm currently trying to configure a dynamic watchlist from MSSQL database but I don't manage to find the right way to configure it.

My MSSQL connection is working with a SQL client. But when I configure my ESM (v9.6.0 MR7) I only receive "can't open session with user XXX".

Here is what I do:

- Type: MSSQL

- Host: 192.168.20.xxx

- Port: 1433

- DB Name: SIEM (that's the name of my SQL db)

- DB Instance: DEVCHU (found doing "SELECT @@SERVICENAME" on the MSSQL Server)

- Username: LecteurSIEM

- Password: xxxxxxxxx

I think I don't have the right syntax around the user field. The authentication is done with a local user of the database (not a LDAP account).

Any ideas ?

Thanks !

1 Reply
Reliable Contributor sssyyy
Reliable Contributor
Report Inappropriate Content
Message 2 of 2

Re: Dynamic watchlist with MSSQL connection

Has the user got sufficient rights to read the DB? which data source?

More McAfee Tools to Help You
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • Visit: Business Service Portal
  • More: Search Knowledge Articles
  • ePolicy Orchestrator Support
  • The McAfee ePO Support Center Plug-in is now available in the Software Manager. Follow the instructions in the Product Guide for more.