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 22.214.171.124 .
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.
Has there been a fix or workaround to this "bug". I was getting the error when using the SQL driver and have since switched to the jTDS driver (thanks to Tushar for the Windows Auth tip) but even after a successful collection, I still get an error message which is counter to what Shlomo stated.
EDIT: After rereading, it looks like Shlomo was referring testing via the main page and not within the collector itself as his later post refers to still getting the error. Maybe Tushar Sutar had a different workaround?
Message with SQL driver
This statement type might not be supported, or it has syntax errors: com.microsoft.sqlserver.jdbc.SQLServerException: The method executeQuery() cannot take arguments on a PreparedStatement or CallableStatement.
Message with jTDS driver
This statement type might not be supported, or it has syntax errors: java.sql.SQLException: Use of the executeQuery(String) method is not supported on this type of statement.
The sql query in the collector doesn't contain anything special, this is obviously coming from the system as it consumes the SQL for injection.
Currently on 7.1
Retrieving data ...