MS SQL Server 2000 Connection problem
joethehacker Jan 9, 2002 6:26 PMHello:
I'm new to these products, and am having some trouble configuring the database connection. I thought I had it working yesterday, but, alas, it is not working today...
I'm running Windows 2000 SQL Server, jBoss 2.4.4, and Tomcat 3.2.3. I'm not positive of the MS JDBC driver version, but I downloaded it yesterday, so it's pretty recent.
When booting the jBoss server, it hangs at when starting/creating the connection pools with the exception, "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."
The user, sa, is a valid user on database with a null password. Why would the connection be rejected based on a lack of a 'trusted' connection?
Any help is greatly appreciated.
Joe
Here is the jboss.jcml JDBC snippet:
<!-- ==================================================================== -->
<!-- JDBC -->
<!-- ==================================================================== -->
org.hsqldb.jdbcDriver,com.microsoft.jdbc.sqlserver.SQLServerDriver
1476
true
default
false
java:/SQLServerDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor
1200000
sa
10
false
false
false
true
120000
1800000
false
true
1.0
0
DefaultDS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:hsqldb:hsql://localhost:1476
1200000
sa
10
false
false
false
true
120000
1800000
false
false
1.0
0
Here is the Exception printout:
[INFO,HypersonicDatabase] Database started
[INFO,HypersonicDatabase] Started
[INFO,java:/SQLServerDS] Starting
[INFO,java:/SQLServerDS] XA Connection pool java:/SQLServerDS bound to java:/java:/SQLServerDS
[INFO,java:/SQLServerDS] java.sql.SQLException: [Microsoft][SQLServer JDBC Driver][SQLServer]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
[INFO,java:/SQLServerDS] at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
[INFO,java:/SQLServerDS] at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
[INFO,java:/SQLServerDS] at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
[INFO,java:/SQLServerDS] at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
[INFO,java:/SQLServerDS] at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
[INFO,java:/SQLServerDS] at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
[INFO,java:/SQLServerDS] at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
[INFO,java:/SQLServerDS] at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
[INFO,java:/SQLServerDS] at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
[INFO,java:/SQLServerDS] at java.sql.DriverManager.getConnection(UnknownSource)
[INFO,java:/SQLServerDS] at java.sql.DriverManager.getConnection(UnknownSource)
[INFO,java:/SQLServerDS] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown Source)
[INFO,java:/SQLServerDS] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown Source)
[INFO,java:/SQLServerDS] at org.jboss.pool.jdbc.xa.XAConnectionFactory.createObject(Unknown Source)
[INFO,java:/SQLServerDS] at org.jboss.pool.ObjectPool.createNewObject(Unknown Source)
[INFO,java:/SQLServerDS] at org.jboss.pool.ObjectPool.getObject(Unknown Source)
[INFO,java:/SQLServerDS] at org.jboss.pool.ObjectPool.getObject(Unknown Source)
[INFO,java:/SQLServerDS] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
[INFO,java:/SQLServerDS] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
[INFO,java:/SQLServerDS] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
[INFO,java:/SQLServerDS] at java.lang.reflect.Method.invoke(Native Method)
[INFO,java:/SQLServerDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[INFO,java:/SQLServerDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[INFO,java:/SQLServerDS] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)
[INFO,java:/SQLServerDS] at $Proxy0.start(Unknown Source)
[INFO,java:/SQLServerDS] at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
[INFO,java:/SQLServerDS] at java.lang.reflect.Method.invoke(Native Method)
[INFO,java:/SQLServerDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[INFO,java:/SQLServerDS] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[INFO,java:/SQLServerDS] at org.jboss.Main.(Main.java:208)[INFO,java:/SQLServerDS] at org.jboss.Main$1.run(Main.java:110)
[INFO,java:/SQLServerDS] at java.security.AccessController.doPrivileged(Native Method)
[INFO,java:/SQLServerDS] at org.jboss.Main.main(Main.java:106)