wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 134
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.
 
Consider Paul's rocket mass heater.
 
subject: Websphere 7 Datasource cannot connect to SqlServer 2008 R2
 
Similar Threads
Not associated with a trusted SQL Server connection
Could not Create Connection in MS SQL Server 2000
Websphere 6.0 DataSource and Microsoft's JDBC driver
HELP please with SQL Server
Datasource Test Connection is successful but the application is not able to connect to the Database