Topic
  • 2 replies
  • Latest Post - ‏2012-01-17T23:45:36Z by JasonJava
JasonJava
JasonJava
11 Posts

Pinned topic SQL 2008 R2 connection issue with Windown authen. on WPS 7 (Sun Solaris)

‏2011-12-28T21:25:13Z |
We are using WebSphere JDBC Adapter 7.0.0.3 and having an SQL 2008 R2 connection issue with Window authentication (integratedSecurity=true) on WPS 7 server on a Solaris box (WAS 7.0.0.11 and Process server 7.0.0.3).

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 !
Updated on 2012-01-17T23:45:36Z at 2012-01-17T23:45:36Z by JasonJava
  • SystemAdmin
    SystemAdmin
    67 Posts

    Re: SQL 2008 R2 connection issue with Windown authen. on WPS 7 (Sun Solaris)

    ‏2012-01-02T20:56:50Z  
    Hi,

    I think you will have to check on setting of the native path for "sqljdbc_auth.dll" for unix environment with microsoft.

    Thanks.
  • JasonJava
    JasonJava
    11 Posts

    Re: SQL 2008 R2 connection issue with Windown authen. on WPS 7 (Sun Solaris)

    ‏2012-01-17T23:45:36Z  
    Hi,

    I think you will have to check on setting of the native path for "sqljdbc_auth.dll" for unix environment with microsoft.

    Thanks.
    OK, I found out SQLserver window authentication (integratedSecurity=true) is for window clients, not for UNIX platform. That explains why it run just fine on my local Windows XP Test environment, but not on UNIX.