Which IIQ version are you inquiring about?
8.5
When I am trying to connect external “sqlserver” database from rule using windows authentication when I add the parameter “authenticationScheme=NTLM” in the connection URL getting below error
com.microsoft.sqlserver.jdbc.SQLServerException: The authenticationScheme NTLM is not valid.
Without any parameters also the connection is getting error with invalid user.
Any recommendation on how to connect the database using windows authentication.
Below is the code for reference
String connectionUrl = “jdbc:sqlserver://XXXX;databaseName=IdentityIQPrevalidation;multisubnetfailover=true;sendStringParametersAsUnicode=true;domain=XXXX;integratedSecurity=true;authenticationScheme=NTLM”;
String dbUser = “XXXXXX”;
String dbPass = “XXXXXX”;
connection = DriverManager.getConnection(connectionUrl, dbUser, dbPass);