gfox 发表于 2024-11-28 21:20:50

【待反馈】不能同步SQL SERVER 数据库

为了能快速了解并处理您的问题,请提供以下基础信息:面板、插件版本:8.2 windows
系统版本:win server 2022
问题描述:不能同步 SQL SERVER 数据库
相关截图(日志、错误):
Traceback (most recent call last): File "C:\BtSoft\panel/class\flask_sockets.py", line 30, in __call__ handler, values = adapter.match() File "C:\Program Files\python\lib\site-packages\werkzeug\routing.py", line 1945, in match raise NotFound() werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. During handling of the above exception, another exception occurred: Traceback (most recent call last): File "pymssql.pyx", line 636, in pymssql.connect File "_mssql.pyx", line 1957, in _mssql.connect File "_mssql.pyx", line 676, in _mssql.MSSQLConnection.__init__ File "_mssql.pyx", line 1683, in _mssql.maybe_raise_MSSQLDatabaseException _mssql.MSSQLDatabaseException: (20009, b'DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (127.0.0.1:1433)\nNet-Lib error during Unknown error (10061)\nDB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (127.0.0.1:1433)\nNet-Lib error during Unknown error (10061)\n') During handling of the above exception, another exception occurred: Traceback (most recent call last): File "C:\BtSoft\panel/class\panelMssql.py", line 61, in __Conn self.__DB_CONN = pymssql.connect(server = self.__DB_HOST, port= str(self.__DB_PORT),login_timeout = 30,timeout = 0,autocommit = True) File "pymssql.pyx", line 642, in pymssql.connect pymssql.OperationalError: (20009, b'DB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (127.0.0.1:1433)\nNet-Lib error during Unknown error (10061)\nDB-Lib error message 20009, severity 9:\nUnable to connect: Adaptive Server is unavailable or does not exist (127.0.0.1:1433)\nNet-Lib error during Unknown error (10061)\n')

运维技术阿闯 发表于 2025-2-12 14:57:15

您好,方便提供一下更详细的信息吗,您提供的这个完全看不出来具体问题
目前只了解到,是无法跟数据库sql server端口1433进行连接,可能的原因有
1、sql server未运行
2、检查端口是否放行
3、如果你使用的是SQL Server Express,它默认可能不使用TCP/IP协议。你需要在SQL Server配置管理器中启用TCP/IP协议。
页: [1]
查看完整版本: 【待反馈】不能同步SQL SERVER 数据库