问题描述
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTaskrun警告:com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1772c98--AcquisitionAttemptFailed!!!Clearingpendingacquires.Whiletryingtoacquireaneedednewresource,wefailedtosucceedmorethanthemaximumnumberofallowedacquisitionattempts(30).Lastacquisitionattemptexception:com.microsoft.sqlserver.jdbc.SQLServerException:用户'sa'登录失败。atcom.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)atcom.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)atcom.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)atcom.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)atcom.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)atcom.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)atcom.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)atcom.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)atcom.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)atcom.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)atcom.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)atcom.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)atcom.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)atcom.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)本地开发环境只安sql2008r2,jdk1.7使用jdbc3.0正常在一台服务上部署程序，环境有一个sql2000,后安装sql2208r2java1.7在服务使用jdbc3.0报以上错误已经使用了以下方法，仍无效1、更改sql2008r2端口为14352、网络配置启动tcp和命名管道方式连接。3、sql2008r2允许sa方式登录。并可以连接修改程序的数据库连接名为新技术实例名:1435。
解决方案
本帖最后由 system1190 于 2014-10-06 20:49:16 编辑
解决方案二：
调试查看程序调用的哪个port和实例名,,,,,也许你的修改没生效...