Hello,
I am trying to setup a datasource in Jboss 4.03 with Sql server 2005
using the new Sql server 2005 jdbc driver.
I have the following parameters in the mssql_ds.xml file:
<connection-url>jdbc:sqlserver://localhost;databaseName=DIAMELLE;selectMethod=cursor</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
However, keep getting the following error, which indicates that the
login failed, but the user id and password are correct.
2006-02-27 18:43:55,953 DEBUG
[org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
Checking driver for URL:
jdbc:sqlserver://localhost:1433;databaseName=DIAMELLE;selectMethod=cursor
2006-02-27 18:43:55,953 DEBUG
[org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
Driver not yet registered for url:
jdbc:sqlserver://localhost:1433;databaseName=DIAMELLE;selectMethod=cursor
2006-02-27 18:43:56,015 DEBUG
[org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory]
Driver already registered for url:
jdbc:sqlserver://localhost:1433;databaseName=DIAMELLE;selectMethod=cursor
2006-02-27 18:43:56,062 WARN
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection;
- nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException:
Login failed for user 'idmuser'.)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:164)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:519)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:208)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:529)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login
failed for user 'idmuser'.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
Source)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:154)
Any thoughts on how I can resolve this?
Thanks
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3926841#3926841
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3926841
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
