pymssql._pymssql.OperationalError: (18456这个问题怎么解决？

2022-06-17 19:21:06 2.6k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

解决pymssql连接sql server数据库报错【18456和20009】我真的会谢，连接了四个小时的server，我终于把python和我的server连接上去了，希望我的教训可以给大家帮助！！！！错误18456： pymssql._pymssql.OperationalError: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 ‘sa’ \xe7\x99\xbb\xe5\xbd\x95\xe5\xa4\xb1\xe8\xb4\xa5\xe3\x80\x82DB-Lib error message 20018, severity 14:\nGener 阅读详情

# 向SQL Server数据库中添加数据
import warnings
warnings.filterwarnings('ignore', category=DeprecationWarning)
from pymssql import *

conn=connect(host='localhost', user='sa', password='SQL2008r2', database='stuinfo5')
conn.autocommit(True)
cursor=conn.cursor()
operation='INSERT INTO students VALUES (%s, %s, %s, %s, %s)'
params=('2020182001', '王强', '男', '2002-03-21', 'wangqiang@163.com')
cursor.execute(operation, params)
print('成功添加1行数据！')
params=[
   ('2020182002', '王曜', '男', '2002-05-11', 'wangyao@163.com')
   ('2020182003', '李思思', '女', '2002-03-02', 'lisisig@shou.com')
   ('2020182004', '刘千梅', '女', '2001-09-20', 'liumei@sina.com')
   ('2020182005', '马亮', '男', '2002-05-11', 'maliangg@qq.com')
   ('2020182006', '肖嘉莉', '女', '2002-09-21', 'xiaolig@sina.com')
]
print('成功添加5行数据！')
cursor.executemany(operation, params)
cursor.execute('SELECT * FROM students')
rows=cursor.fetchall()
print('表数据如下：')
for row in rows:
   print(f'{row[0]}\t{row[1]}\t{row[2]}\t{row[3]}\t{row[4]}')
cursor.close()
conn.close()

程序执行后出现错误，提示如下：

E:\Python程序设计微课版\10.13 向SQL Server数据库中添加数据示例.py:14: SyntaxWarning: 'tuple' object is not callable; perhaps you missed a comma?
('2020182002', '王曜', '男', '2002-05-11', 'wangyao@163.com')
Traceback (most recent call last):
File "src\pymssql\_pymssql.pyx", line 646, in pymssql._pymssql.connect
File "src\pymssql\_mssql.pyx", line 2106, in pymssql._mssql.connect
File "src\pymssql\_mssql.pyx", line 698, in pymssql._mssql.MSSQLConnection.__init__
File "src\pymssql\_mssql.pyx", line 1815, in pymssql._mssql.maybe_raise_MSSQLDatabaseException
File "src\pymssql\_mssql.pyx", line 1832, in pymssql._mssql.raise_MSSQLDatabaseException
pymssql._mssql.MSSQLDatabaseException: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 'sa' \xe7\x99\xbb\xe5\xbd\x95\xe5\xa4\xb1\xe8\xb4\xa5\xe3\x80\x82DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n")

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "E:\10.13 向SQL Server数据库中添加数据.py", line 6, in <module>
conn=connect(host='localhost', user='sa', password='SQL2008r2', database='stuinfo5')
File "src\pymssql\_pymssql.pyx", line 652, in pymssql._pymssql.connect
pymssql._pymssql.OperationalError: (18456, b"\xe7\x94\xa8\xe6\x88\xb7 'sa' \xe7\x99\xbb\xe5\xbd\x95\xe5\xa4\xb1\xe8\xb4\xa5\xe3\x80\x82DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (localhost)\n")
[Finished in 546ms]

请问这问题怎么解决？

...全文