Hello,

This is my problem. After I setup a sql server datasource in Websphere and test connection, I get the ff error:

"The test connection operation failed for data source Microsoft SQL Server JDBC Driver - DataSource on server server1 at node xyzNode03 with the following exception: java.sql.SQLException: Login failed for user 'xyzadmin'. Reason: Not associated with a trusted SQL Server connection.DSRA0010E: SQL State = S0001, Error Code = 18,452."


Websphere version: 7.0.0.0
I am connecting to: Sqlserver 2008 R2
Driver used: sqljdbc4.jar
Provider used (in WAS): Microsoft SQL Server JDBC Driver

I already made the the authentication setting in Enterprise manager as "SQL Server and Windows Authentication"

Still won't work. Same error happens.

Can anyone help me on this? I would appreciate any advice. Thanks :-)

By the way, this is working in Websphere 6.1 but not in 7.

By the way, I already updated it to 7.0.0.29 using the latest fixpack and still the same thing happens.

Hi floyd4644

  I have found the next technote:
 
  Error message java.sql.SQLException occurs starting Rational Asset Manager V7.0.0.1 server using a Microsoft SQL Server database
  www-01.ibm.com/support/docview.wss?uid=s...
    
  Even the error is for other product try the solution, that is, in your datasource configuration change the Authentication Alias (J2C Alias) scope from  Container-managed authentication alias to Component-managed authentication alias.
    
  Another possible solution I have found is with the path of sqljdbc_auth.dll
 
  Why can not connect SQL server 2008 with integratedSecurity model in Websphere 7.0?
  social.msdn.microsoft.com/forums/sqlserv...
 
  Try and let us. Hope this helps,
 
regards

Thanks for the suggestions Gabriel.

Well, based on the links you have provided, I ended up doing this...

1. Downloaded the sqljdbc_auth.dll from the Microsoft JDBC Driver 4.0 site.
2. Placed this dll file in [WAS_home]\java\bin
3. Restarted WAS and tried to retes datasource connection to the sql server 2008 R2
4. The current error was gone but I got this new one

"The test connection operation failed for data source Microsoft SQL Server JDBC Driver - DataSource on server server1 at node calzoneNode03 with the following exception: java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.. View JVM logs for further details."

This is weird since I already had sqljdbc4.jar as my driver.

^^

Continuation from my previous post.

When I restarted the machine where WAS7 was deployed and tried to retest the datasource connection, this new error shows:

"The test connection operation failed for data source Microsoft SQL Server JDBC Driver - DataSource on server server1 at node calzoneNode03 with the following exception: java.sql.SQLException: SQL Server version 8 is not supported by this driver. ClientConnectionId:e8b5af95-e3a2-47f7-8688-1a9566582c6cDSRA0010E: SQL State = 08S01, Error Code = 0. View JVM logs for further details."

floyd4644,

  have you the latest sqljdbc4.jar?

  Microsoft JDBC Driver 4.0 for SQL Server
  www.microsoft.com/en-us/download/details...

regards

The sqljdbc4.jar is part of the downloaded Microsoft JDBC 4.0 driver so yes, it it the jar file I am using for the datasource.

Initial error looks to be problem at database end. User id setup at SQL server 2008 server doesnt have privilleage to access database defined while creating data source. I recommend you to try connecting database server with credential defined in data source using database client. If you are connection is successful then check if you have correct permission like read, write and execute in defined database name. This can be checked with the help of DBA.

Once problem at database end is resolved, you may try testing db connection on original setup.