none
ODBC 连接SQL Server时总是出现17809错误 RRS feed

  • 问题

  • 已按网上的解决方案,用sp_configure 修改了user connections 参数为0,为100,依然不能连接,出现错误17809:Could not connect because the maximum number of '2' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: 192.168.138.64]
    2020年1月14日 9:20

全部回复

  • What's sql server edition? You can check it with 'select @@version'.
    2020年1月14日 20:04
  • 您好,这是查询结果:Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64)   Apr 29 2016 23:23:58   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: ) 
    2020年1月15日 0:57
  • 你可以尝试以下步骤:

    1. 重启SQL Server服务
    2. 打开SSMS连接SQL Server
    3. 将concurrent connection改为0
    4. 然后重启SQL Server,再用ODBC连接试试

    希望对你有用,还有任何问题请随时告知。


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2020年1月15日 6:17
  • 现在已经是这个设置,按您的操作指导,有都重启了一遍,还是不可以。
    2020年1月15日 7:02
  • 这就有点奇怪了,你用/mSQLCMD (SQLServr.exe –mSQLCMD –s<InstanceName>)参数启动连接SQL Server, 然后用SQLCMD执行以下参数试试:

    exec sp_configure 'user connections',0
    go
    reconfigure with override
    go


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2020年1月15日 7:12
  • Install latest service pack then try again.
    2020年1月15日 21:38
  • 已解决,非常感谢!
    2020年1月16日 3:33
  • 很高兴你解决了问题。

    如果您觉得我们的解决方案解决了该问题,请帮忙‘Mark as Answer'以帮助其他社区成员迅速找到有用的答复。十分感谢


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    2020年1月16日 5:29