1 Reply Latest reply on Feb 28, 2006 11:23 AM by Scott Stark

    Configuring SQL Server 2005 on Jboss 4.03 error

    A Shah Newbie

      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