5 Replies Latest reply on Jan 11, 2002 12:15 PM by Joe

    MS SQL Server 2000 Connection problem

    Joe Newbie

      Hello:

      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)