We are using WebSphere JDBC Adapter 188.8.131.52 and having an SQL 2008 R2 connection issue with Window authentication (integratedSecurity=true) on WPS 7 server on a Solaris box (WAS 184.108.40.206 and Process server 220.127.116.11).
We got the JDBC driver from Microsoft (http://www.microsoft.com/download/en/details.aspx?id=21599) and configured classpath for "sqljdbc4.jar" (must be used with JRE1.6 and later) and setup the native path for "sqljdbc_auth.dll".
Got the following error message during the test connection:
"The test connection operation failed for data source MW_SQLDB_DS on server nodeagent at node WPSNode01 with the following exception: java.sql.SQLException: This driver is not configured for integrated authentication.DSRA0010E: SQL State = 08S01, Error Code = 0. View JVM logs for further details."
Interestingly, the error only happens on the UNIX box. The same configuration on a Local Test Environment (Window XP), the test connection is working just fine.
Appreciate any help !
Pinned topic SQL 2008 R2 connection issue with Windown authen. on WPS 7 (Sun Solaris)
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-01-17T23:45:36Z at 2012-01-17T23:45:36Z by JasonJava
SystemAdmin 110000D4XK67 Posts
Re: SQL 2008 R2 connection issue with Windown authen. on WPS 7 (Sun Solaris)2012-01-02T20:56:50ZThis is the accepted answer. This is the accepted answer.Hi,
I think you will have to check on setting of the native path for "sqljdbc_auth.dll" for unix environment with microsoft.
JasonJava 110000KXX711 Posts
Re: SQL 2008 R2 connection issue with Windown authen. on WPS 7 (Sun Solaris)2012-01-17T23:45:36ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK