aspose file tools*
The moose likes Websphere and the fly likes Websphere 7 Datasource cannot connect to SqlServer 2008 R2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Websphere 7 Datasource cannot connect to SqlServer 2008 R2" Watch "Websphere 7 Datasource cannot connect to SqlServer 2008 R2" New topic
Author

Websphere 7 Datasource cannot connect to SqlServer 2008 R2

Andres Delrotti
Ranch Hand

Joined: Aug 11, 2005
Posts: 117
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Websphere 7 Datasource cannot connect to SqlServer 2008 R2
 
Similar Threads
HELP please with SQL Server
Could not Create Connection in MS SQL Server 2000
Not associated with a trusted SQL Server connection
Datasource Test Connection is successful but the application is not able to connect to the Database
Websphere 6.0 DataSource and Microsoft's JDBC driver