5 Replies Latest reply on Mar 25, 2005 5:41 AM by 3004

    'Login failed' message when trying to create a conn pool with WLS 8.1 SP3

    666705
      I am experiencing issues with configuration of the JDBC connection pool "dctmWebCachePool" on web logic server 8.1 SP3. The database is sql server 2k.

      Heres the connection info:
      Server name: GROAMRAPP161.AMER.PFIZER.COM
      Database name: Pfieldnet_Webcache_2791
      Username: pfieldnet_ro
      Password : pass

      The username/password have been verified thru Query Analyzer and the default database of this user is Pfieldnet_Webcache_2791.

      The properties are:

      URL -> jdbc:documentum:oca:webcache
      DriverClassname -> com.documentum.oca.jdbc.webcache.DjdbcDriver

      Properties:
      jdbc.url=jdbc:bea:sqlserver://GROAMRAPP161.amer.pfizer.com:1433
      user=pfieldnet_ro
      jdbc.driver=weblogic.jdbc.sqlserver.SQLServerDriver
      databaseName=Pfieldnet_Webcache_2791
      serverName=GROAMRAPP161.amer.pfizer.com
      contentURL=http://moppgpwsmprod5.pfizer.com:8015/

      password:
      pass

      When I create this connection pool and go to Testing tab in JDBC -> ConnectionPool -> dctmwebcachePool
      I see that the connection pool is unavailable.

      I have checked the logs and this is the message I get (The attached error with java error messages is there in error.txt):
      ----------------------------------------------------------------------------
      ####<Mar 23, 2005 5:07:57 PM EST> <Info> <JDBC> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-001177> <Creating Connection Pool named dctmWebCachePool, URL = jdbc:bea:sqlserver://GROAMRAPP161.amer.pfizer.com:1433, Properties = {user=pfieldnet_ro, contentURL=http://moppgpwsmprod5.pfizer.com:8015, serverName=GROAMRAPP161.amer.pfizer.com, DatabaseName=Pfieldnet_Webcache_2791, jdbc.driver=weblogic.jdbc.sqlserver.SQLServerDriver, jdbc.url=jdbc:bea:sqlserver://GROAMRAPP161.amer.pfizer.com:1433}.>
      ####<Mar 23, 2005 5:07:57 PM EST> <Info> <Common> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-000625> <The application has disabled periodic testing of free resources in pool "dctmWebCachePool".> ####<Mar 23, 2005 5:07:58 PM EST> <Warning> <JDBC> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-001129> <Received exception while creating connection for pool "dctmWebCachePool": [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails.> ####<Mar 23, 2005 5:07:58 PM EST> <Info> <JDBC> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-001156> <Stack trace associated with message 001129 follows:

      java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails.
           at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
           at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
           at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
           at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
           at weblogic.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
           at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
           at weblogic.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
           at weblogic.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
           at weblogic.jdbc.base.BaseConnection.open(Unknown Source)
           at weblogic.jdbc.base.BaseDriver.connect(Unknown Source)
           at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:189)
           at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:124)
           at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1145)
           at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1079)
           at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:171)
           at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1001)
           at weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:142)
           at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:298)
           at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:180)
           at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:331)
           at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:591)
           at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:569)
           at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:241)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:324)
           at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:731)
           at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:710)
           at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:484)
           at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
           at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
           at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:985)
           at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:943)
           at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
           at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
           at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7351)
           at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1304)
           at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:347)
           at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:229)
           at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
           at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:966)
           at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:361)
           at weblogic.Server.main(Server.java:32)
      >
      ####<Mar 23, 2005 5:07:59 PM EST> <Error> <JDBC> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-001150> <Connection Pool "dctmWebCachePool" deployment failed with the following error: 0:Could not create pool connection. The DBMS driver exception was: [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails..> ####<Mar 23, 2005 5:07:59 PM EST> <Info> <JDBC> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-001156> <Stack trace associated with message 001150 follows:

      weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails.
           at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:153)
           at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1145)
           at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1079)
           at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:171)
           at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1001)
           at weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:142)
           at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:298)
           at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:180)
           at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:331)
           at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:591)
           at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:569)
           at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:241)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:324)
           at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:731)
           at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:710)
           at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:484)
           at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
           at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
           at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:985)
           at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:943)
           at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
           at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
           at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7351)
           at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1304)
           at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:347)
           at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:229)
           at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
           at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:966)
           at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:361)
           at weblogic.Server.main(Server.java:32)
      --------------- nested within: ------------------
      weblogic.common.ResourceException: 0:Could not create pool connection. The DBMS driver exception was: [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails. - with nested exception:
      [weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails.]
           at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1224)
           at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1079)
           at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:171)
           at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1001)
           at weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:142)
           at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:298)
           at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:180)
           at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:331)
           at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:591)
           at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:569)
           at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:241)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:324)
           at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:731)
           at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:710)
           at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:484)
           at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
           at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
           at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:985)
           at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:943)
           at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
           at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
           at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7351)
           at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1304)
           at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:347)
           at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:229)
           at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
           at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:966)
           at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:361)
           at weblogic.Server.main(Server.java:32)

      ----------------------------------------------------------------------------

      The other connection pools are working fine and one difference I see is in the version of the db.

      The version of the sql server db server for which the conn pools work fine:
      Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50
      Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

      The version of the sql server db server where "dctmwebcachepool" connection pool has been deployed:
      Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: )

      Any ideas/inputs will be appreciated.

      Thanx
      Nitin
        • 1. Re: 'Login failed' message when trying to create a conn pool with WLS 8.1 SP3
          3004
          Nitin Kumar wrote:

          I am experiencing issues with configuration of the JDBC connection pool "dctmWebCachePool" on web logic server 8.1 SP3. The database is sql server 2k.

          Heres the connection info:
          Server name: GROAMRAPP161.AMER.PFIZER.COM
          Database name: Pfieldnet_Webcache_2791
          Username: pfieldnet_ro
          Password : pass

          The username/password have been verified thru Query Analyzer and the default database of this user is Pfieldnet_Webcache_2791.

          The properties are:

          URL -> jdbc:documentum:oca:webcache
          DriverClassname -> com.documentum.oca.jdbc.webcache.DjdbcDriver

          Properties:
          jdbc.url=jdbc:bea:sqlserver://GROAMRAPP161.amer.pfizer.com:1433
          user=pfieldnet_ro
          jdbc.driver=weblogic.jdbc.sqlserver.SQLServerDriver
          databaseName=Pfieldnet_Webcache_2791
          serverName=GROAMRAPP161.amer.pfizer.com
          contentURL=http://moppgpwsmprod5.pfizer.com:8015/

          password:
          pass
          Hi Nitin. Would you run the utils.dbping tool to see if we can get a simple
          driver connection to the DBMS? Try this:


          java utils.dbping MSSQLSERVERB pfieldnet_ro pass GROAMRAPP161.amer.pfizer.com:1433/Pfieldnet_Webcache_2791


          This assumes that the DBMS user is pfieldnet_ro, the password is pass, the DBMS machine is
          GROAMRAPP161.amer.pfizer.com, the DBMS listener port is 1433 (typical), and the db_name
          within that DBMS is Pfieldnet_Webcache_2791. Let me know the output of the program.
          Thanks
          Joe

          When I create this connection pool and go to Testing tab in JDBC -> ConnectionPool -> dctmwebcachePool
          I see that the connection pool is unavailable.

          I have checked the logs and this is the message I get (The attached error with java error messages is there in error.txt):
          ----------------------------------------------------------------------------
          ####<Mar 23, 2005 5:07:57 PM EST> <Info> <JDBC> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-001177> <Creating Connection Pool named dctmWebCachePool, URL = jdbc:bea:sqlserver://GROAMRAPP161.amer.pfizer.com:1433, Properties = {user=pfieldnet_ro, contentURL=http://moppgpwsmprod5.pfizer.com:8015, serverName=GROAMRAPP161.amer.pfizer.com, DatabaseName=Pfieldnet_Webcache_2791, jdbc.driver=weblogic.jdbc.sqlserver.SQLServerDriver, jdbc.url=jdbc:bea:sqlserver://GROAMRAPP161.amer.pfizer.com:1
          433}.>
          ####<Mar 23, 2005 5:07:57 PM EST> <Info> <Common> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-000625> <The application has disabled periodic testing of free resources in pool "dctmWebCachePool".> ####<Mar 23, 2005 5:07:58 PM EST> <Warning> <JDBC> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-001129> <Received exception while creating connection for pool "dctmWebCachePool": [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_
          Webcache_2791'. Login fails.> ####<Mar 23, 2005 5:07:58 PM EST> <Info> <JDBC> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-001156> <Stack trace associated with message 001129 follows:

          java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails.
               at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
               at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
               at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
               at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
               at weblogic.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
               at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
               at weblogic.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
               at weblogic.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
               at weblogic.jdbc.base.BaseConnection.open(Unknown Source)
               at weblogic.jdbc.base.BaseDriver.connect(Unknown Source)
               at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:189)
               at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:124)
               at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1145)
               at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1079)
               at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:171)
               at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1001)
               at weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:142)
               at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:298)
               at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:180)
               at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:331)
               at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:591)
               at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:569)
               at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:241)
               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
               at java.lang.reflect.Method.invoke(Method.java:324)
               at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:731)
               at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:710)
               at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:484)
               at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
               at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
               at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:985)
               at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:943)
               at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
               at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
               at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7351)
               at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1304)
               at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:347)
               at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:229)
               at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
               at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:966)
               at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:361)
               at weblogic.Server.main(Server.java:32)

          ####<Mar 23, 2005 5:07:59 PM EST> <Error> <JDBC> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-001150> <Connection Pool "dctmWebCachePool" deployment failed with the following error: 0:Could not create pool connection. The DBMS driver exception was: [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails..> ####<Mar 23, 2005 5:07:59 PM EST> <Info> <JDBC> <moppgpwsmprod5> <PfieldIntPtl81s01> <main> <<WLS Kernel>> <> <BEA-001
          156> <Stack trace associated with message 001150 follows:

          weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails.
               at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:153)
               at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1145)
               at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1079)
               at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:171)
               at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1001)
               at weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:142)
               at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:298)
               at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:180)
               at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:331)
               at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:591)
               at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:569)
               at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:241)
               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
               at java.lang.reflect.Method.invoke(Method.java:324)
               at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:731)
               at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:710)
               at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:484)
               at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
               at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
               at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:985)
               at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:943)
               at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
               at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
               at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7351)
               at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1304)
               at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:347)
               at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:229)
               at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
               at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:966)
               at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:361)
               at weblogic.Server.main(Server.java:32)
          --------------- nested within: ------------------
          weblogic.common.ResourceException: 0:Could not create pool connection. The DBMS driver exception was: [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails. - with nested exception:
          [weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [BEA][SQLServer JDBC Driver][SQLServer]Cannot open database requested in login 'Pfieldnet_Webcache_2791'. Login fails.]
               at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1224)
               at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1079)
               at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:171)
               at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1001)
               at weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:142)
               at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:298)
               at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:180)
               at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:331)
               at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:591)
               at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:569)
               at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:241)
               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
               at java.lang.reflect.Method.invoke(Method.java:324)
               at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:731)
               at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:710)
               at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:484)
               at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
               at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
               at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:985)
               at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:943)
               at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
               at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
               at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7351)
               at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1304)
               at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:347)
               at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:229)
               at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
               at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:966)
               at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:361)
               at weblogic.Server.main(Server.java:32)

          ----------------------------------------------------------------------------

          The other connection pools are working fine and one difference I see is in the version of the db.

          The version of the sql server db server for which the conn pools work fine:
          Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50
          Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

          The version of the sql server db server where "dctmwebcachepool" connection pool has been deployed:
          Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: )

          Any ideas/inputs will be appreciated.

          Thanx
          Nitin
          • 2. Re: 'Login failed' message when trying to create a conn pool with WLS 8.1 S
            666705
            Hi Joe,

            This is the output I get..

            C:\bea81SP3\weblogic81\server\bin>java utils.dbping MSSQLSERVER4 pfieldnet_ro rousr$ GROAMRAPP161.AM
            ER.PFIZER.COM:1433/Pfieldnet_Webcache_2791

            Error encountered:

            java.sql.SQLException: Could not locate entry in sysdatabases for database 'Pfieldnet_Webcache_2791'
            . No entry found with that name. Make sure that the name is entered correctly. Severity 16, State 1,
            Procedure 'GROAMRAPP161 null', Line 1
            at weblogic.jdbc.mssqlserver4.TdsStatement.processWarning(IIIILjava.lang.String;Ljava.lang.S
            tring;)V(TdsStatement.java:1193)
            at weblogic.jdbc.mssqlserver4.TdsStatement.parseMsWarning()V(TdsStatement.java:1104)
            at weblogic.jdbc.mssqlserver4.TdsStatement.getMoreResults()Z(TdsStatement.java:771)
            at weblogic.jdbc.mssqlserver4.TdsStatement.execute(Ljava.lang.String;)Z(TdsStatement.java:21
            0)
            at weblogic.jdbc.mssqlserver4.BaseConnection.setCatalog(Ljava.lang.String;Z)V(BaseConnection
            .java:750)
            at weblogic.jdbc.mssqlserver4.BaseConnection.setCatalog(Ljava.lang.String;)V(BaseConnection.
            java:727)
            at weblogic.jdbc.mssqlserver4.TdsConnection.login(Lweblogic.jdbc.mssqlserver4.BaseConnection
            ;Lweblogic.jdbc.mssqlserver4.ConnectionInfo;)V(TdsConnection.java:82)
            at weblogic.jdbc.mssqlserver4.MicrosoftConnection.login(Lweblogic.jdbc.mssqlserver4.BaseConn
            ection;Lweblogic.jdbc.mssqlserver4.ConnectionInfo;)V(MicrosoftConnection.java:54)
            at weblogic.jdbc.mssqlserver4.BaseConnection.prepareConnection()V(BaseConnection.java:181)
            at weblogic.jdbc.mssqlserver4.Driver.newConnection(Lweblogic.jdbc.mssqlserver4.ConnectionInf
            o;)Ljava.sql.Connection;(Driver.java:34)
            at weblogic.jdbc.mssqlserver4.ConnectDriver.connect(Ljava.lang.String;Ljava.util.Properties;
            )Ljava.sql.Connection;(ConnectDriver.java:147)
            at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;Ljava.lang.C
            lassLoader;)Ljava.sql.Connection;(Unknown Source)
            at java.sql.DriverManager.getConnection(Ljava.lang.String;Ljava.util.Properties;)Ljava.sql.C
            onnection;(Unknown Source)
            at utils.dbping.main([Ljava.lang.String;)V(dbping.java:196)
            -----------------------------------

            Interestingly I invoke isql and get the same message..

            C:\bea81SP3\weblogic81\server\bin>isql -SGROAMRAPP161.AMER.PFIZER.COM -dPfieldnet_Webcache_2791 -Upfieldnet_ro -Ppass
            Msg 911, Level 16, State 1, Server GROAMRAPP161, Line 1
            Could not locate entry in sysdatabases for database 'Pfieldnet_Webcache_2791'.
            No entry found with that name. Make sure that the name is entered correctly.

            ----------------------------------
            But when I access this using sql query analyzer, this works fine.Any ideas?

            Thanx
            Nitin
            • 3. Re: 'Login failed' message when trying to create a conn pool with WLS 8.1 S
              3004
              Nitin Kumar wrote:

              Hi Joe,
              This is the output I get..

              C:\bea81SP3\weblogic81\server\bin>java utils.dbping MSSQLSERVER4 pfieldnet_ro rousr$ GROAMRAPP161.AM
              ER.PFIZER.COM:1433/Pfieldnet_Webcache_2791

              Error encountered:

              java.sql.SQLException: Could not locate entry in sysdatabases for database 'Pfieldnet_Webcache_2791'
              . No entry found with that name. Make sure that the name is entered correctly. Severity 16, State 1,
              ...
              at utils.dbping.main([Ljava.lang.String;)V(dbping.java:196)

              Interestingly I invoke isql and get the same message..

              C:\bea81SP3\weblogic81\server\bin>isql -SGROAMRAPP161.AMER.PFIZER.COM -dPfieldnet_Webcache_2791 -Upfieldnet_ro -Ppass
              Msg 911, Level 16, State 1, Server GROAMRAPP161, Line 1
              Could not locate entry in sysdatabases for database 'Pfieldnet_Webcache_2791'.
              No entry found with that name. Make sure that the name is entered correctly.

              ----------------------------------
              But when I access this using sql query analyzer, this works fine.Any ideas?

              Thanx
              Nitin
              Hi.
              This proves that the database 'Pfieldnet_Webcache_2791' does not exist.
              Once you've connected to the DBMS via query analyser, do this query:


              select * from master..sysdatabases


              That will show you all the real existing databases in the DBMS (it the
              user has select permissions on master tables.)
              then call:


              select db_name()


              That will show you the real database context your connection has.
              So far, it seems to be a silent bug in the query analyser.


              Joe Weinstein at BEA
              • 4. Re: 'Login failed' message when trying to create a conn pool with WLS 8.1 S
                666705
                Thanx Joe. I was able to get it working. The db was case sensitive and I was not using the correct case in the db name.

                Since query analyzer does not ask for a db name (it only prompts for server namer, user and password), I was able to log in.

                Nitin
                • 5. Re: 'Login failed' message when trying to create a conn pool with WLS 8.1 S
                  3004
                  Nitin Kumar wrote:

                  Thanx Joe. I was able to get it working. The db was case sensitive
                  and I was not using the correct case in the db name.
                  Since query analyzer does not ask for a db name (it only prompts
                  for server namer, user and password), I was able to log in.
                  Nitin
                  Cool. Glad to help.
                  Joe