I had no problem getting connection to the SQLServer on my local WSAD 5.1. On my local WSAD, I got a connection via driver manager and datasource. After setting up connection pool in websphere admin console, I got the following error.
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I googled the error message and got solution which instructed to set the authentication mode of the SQL Server to Mixed mode. Inspecting the setting, I saw that the SQl Server already is set to the mixed mode. Could anybody give me a hint? Thanks in advance.
Kyle, No, I haven't. Could you show me how to set up a JAAS? Is it like hardcoding userid/password?
What I did was when a connection is needed, userid/passwd were retrieved from a table and invoke datasource.getConnection(userid, passwd); I can get Oracle and Informix connection without any problem.
Joined: Aug 10, 2001
No guarantee this will work -- but it's worth a try. You create the JAAS authentication aliases in the Server editor on the page labeled "Security". Just give it a name (like "default") and enter the uid/password. Then in the Datasource configuration dialog you set this as the container-managed security alias.
Do a search in the infoCenter for "JAAS Alias" and you should find more information with screenshots.
Joined: Apr 20, 2001
We found the solution. Unlike Oracle and Informix, SQL Server attempted to authenticate when setLoginTimeOut() was invoked. By avoid setting login timeout, we got the connection. What I don't understand was why it worked on my desktop. I did not need to make any modification on my desktop. The only difference was I needed to avoid setting loggin timeout when configuring sql server datasource in admin console.