Configuring SQL Server 2005 on Jboss 4.03 error
cortlander Feb 28, 2006 11:12 AMHello,
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