CODEWITHSUNDEEP
datasourcewebsphere-8
learnerforlife
learnerforlife

Reputation: 37

test connection failed in websphere-DSRA0010E: SQL State = S0001, Error Code = 18,456

I created a data source on my local WAS.The database I am trying to connect is on a dev sql server 2012 host.When I do a test connection it fails with below error :

java.sql.SQLException: Login failed for user ''. ClientConnectionId:c1c4d500-ad7c-4014-b9c2-96e8f54e4a3f DSRA0010E: SQL State = S0001, Error Code = 18,456 [7/18/18 13:18:51:387 IST] 00000061 SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) [7/18/18 13:18:51:387 IST] 00000061 SystemErr R at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254) [7/18/18 13:18:51:387 IST] 00000061 SystemErr R at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84

Any help in how can I resolve this?

Upvotes: 0

Views: 13275

Answers (1)

njr
njr

Reputation: 3484

The error message indicates that you are trying to connect without a user name specified.

Check your configuration to see if you have specified user/password on the data source or a valid authentication alias. The following knowledge center doc lists the precedence for determining the user/password that are used for test connection operations.

Upvotes: 0

Related Questions