|
|
|
date: 27 Feb 2006 17:57:24 -0800,
group: microsoft.public.sqlserver.jdbcdriver
back
RE: Connection to SQL Server 2005 from Jboss 4.03
It looks like your class name and URL are correct, so I would suggest checking:
1) ensure that your SQL Server is setup to access SQL authentication
2) ensure you SQL Server is listening on TCP/IP
The easiest way to test this is to create a UDL and then try to connect to your SQL Server using a connection string of the form:
tcp:servername
and using SQL Authentication
Evan
--------------------
>From: "leslie_tighe@yahoo.com"
>Subject: Connection to SQL Server 2005 from Jboss 4.03
>
>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
>Leslie
>
>
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
date: Tue, 28 Feb 2006 19:57:49 GMT
author: (Evan T. Basalik (MSFT))
|
|
