Showing results for 
Show  only  | Search instead for 
Did you mean: 
Level 8
Report Inappropriate Content
Message 1 of 2

Dynamic watchlist with MSSQL connection


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:

- 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
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?

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community