Python中pymssql报错

问题遇到的现象和发生背景

pymssql库连接数据库时一直报错，网上找各种攻略，都没解决，什么设置防火墙打开电脑1433端口，SQL Server资源管理器TCP设置，都试过了，都不行呀，有没有会的指导一下。

遇到的现象和发生背景，请写出第一个错误信息

一直报这个错：
pymssql._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)\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)\nNet-Lib error during Unknown error (10061)\n')

用代码块功能插入代码，请勿粘贴截图。 不用代码块回答率下降 50%
import pymssql
conn = pymssql.connect(host="127.0.0.1:2301",
                       user="sa",
                       password="123456",
                       database="Career",
                       charset="utf8")
cursor = conn.cursor()
运行结果及详细报错内容

Traceback (most recent call last):
File "src\pymssql_pymssql.pyx", line 647, in pymssql._pymssql.connect
File "src\pymssql_mssql.pyx", line 2109, in pymssql._mssql.connect
File "src\pymssql_mssql.pyx", line 701, in pymssql._mssql.MSSQLConnection.init
File "src\pymssql_mssql.pyx", line 1818, in pymssql._mssql.maybe_raise_MSSQLDatabaseException
File "src\pymssql_mssql.pyx", line 1835, in pymssql._mssql.raise_MSSQLDatabaseException
pymssql._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)\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)\nNet-Lib error during Unknown error (10061)\n')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:/Users/刘华腾/PycharmProjects/pythonProject/test.py", line 6, in
charset="utf8")
File "src\pymssql_pymssql.pyx", line 653, in pymssql._pymssql.connect
pymssql._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)\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)\nNet-Lib error during Unknown error (10061)\n')

我的解答思路和尝试过的方法，不写自己思路的，回答率下降 60%

打开电脑防火墙1433端口，打开SQLserver资源管理器进行tcp设置

我想要达到的结果，如果你需要快速回答，请尝试 “付费悬赏”

解决pymssql连接sql server数据库报错
如有帮助望采纳
https://blog.csdn.net/weixin_42198265/article/details/124840388

img

img

img

img

你上面的设置都尝试了，那你写的代码和别人的代码还是有点区别。你好像没加server='SZS\SQLEXPRESS',为啥呢？
你重启服务尝试没？

img


import pymssql
conn = pymssql.connect(host="127.0.0.1",
                      prot = 2301
                       user="sa",
                       password="123456",
                       database="Career",
                       charset="utf8")
cursor = conn.cursor()