• Home
  • Categories
  • WIKI
  • LANGUAGE: en
    • [Newbies] 请大神指教：deepin使用vscode连接mssql数据库错误
    Newbies 588 views · 5 replies ·
    Tofloor
    poster avatar
    仁心无郁
    deepin
    2022-06-23 16:03
    Author

    请大神指教：deepin使用vscode连接mssql数据库错误，使用navicate就可以，提示如下：

    mssql: Connection error : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)

    有没有遇到同样问题的？

    Reply Favorite View the author
    All Replies
    zijinyise
    deepin
    2022-06-23 16:42
    #1

    vscode有插件吧，插件的提示看看

    Reply View the author
    joo
    deepin
    2022-06-23 18:06
    #2

    ssl的版本问题，修改opensll的配置文件，参考如下：

    [system_default_sect]
MinProtocol = TLSv1.0
CipherString = DEFAULT@SECLEVEL=1

    微软的mssql论坛有讨论到

    Reply View the author
    joo
    deepin
    2022-06-23 18:07
    #3

    默认是：

    [system_default_sect]
MinProtocol = TLSv2.0
CipherString = DEFAULT@SECLEVEL=2
    Reply View the author
    joo
    deepin
    2022-06-23 18:34
    #4

    还有连接时加上这个参数：TrustServerCertificate = yes

    Reply View the author
    仁心无郁
    deepin
    2022-06-23 19:29
    #5
    joo：

    还有连接时加上这个参数：TrustServerCertificate = yes

    好的，多谢！太牛了！

    Reply View the author