While creating a SQLServer (or SQLServer3) Type DB Collector, I'm getting the below error.
DB Connection is successful, and even the most simplest query fails.
I have the same issue with 184.108.40.206 .
This is a bug in the GUI.
Once you complete the collector, you will be able to test and collect without any issues - if everything else is correct.
I suggest testing your query in a separate program of your choice.
Thanks for replying Shlomo,
Ya, it looks like a bug.
We had same issue, as a workaround we used JTDS drivers. Worked for MS-SQL server.
This is what I am using and see the error:
I am not seeing error from your image.
URL example -
the useNTLMv2 & domain options are if you are using Windows Authentication.
Also you need to have JTDS drivers also, for that you can refer section "Customize RSA Identity Governance and Lifecycle" in installation guide.
Retrieving data ...