java吧 关注:1,295,200贴子:12,828,443
  • 8回复贴,共1

java连接sql报错:用户登入失败

只看楼主收藏回复

java连接服务器数据库sql,项目能够运行完,但是中间报错 用户“sa”登入失败;用sqlserver又能够登入,不知道是什么原因;求大神指教:
com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。 ClientConnectionId:0d36e5e3-6051-466a-a348-ea662a8189f0
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)
......


IP属地:河南1楼2016-11-21 23:04回复
    百度了好久都没有找到解决方案


    IP属地:河南2楼2016-11-21 23:05
    回复
      2026-01-20 06:06:00
      广告
      不感兴趣
      开通SVIP免广告
      去问百度,更详细,记得更改过配置生效需要重启数据库引擎。


      IP属地:江苏来自iPhone客户端3楼2016-11-21 23:51
      收起回复
        数据库连接有问题,你这个用户sa登录不上,所以连接不了你的数据库


        IP属地:江苏来自iPhone客户端4楼2016-11-22 01:57
        回复
          人工暖贴


          来自Android客户端6楼2016-11-22 03:10
          回复




            IP属地:河南来自Android客户端8楼2016-11-22 11:42
            回复
              楼主解决没有啊?同跪


              IP属地:四川9楼2016-12-19 10:00
              回复
                我给你看看 q1650563029


                来自iPhone客户端10楼2016-12-19 12:22
                回复