[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)

我会带着你远行 2022-12-01 05:10 188阅读 0赞

# Pyodbc \[HYT00\] \[Microsoft\]\[ODBC Driver 17 for SQL Server\]Login timeout expired (0) (SQLDriverConnect) #

使用pyodbc连接SQL Server时，报超时错误。

## 代码 ##

import pyodbc
    
    driver = '{ODBC Driver 17 for SQL Server}'
    server = '192.168.50.106,1433'
    database = 'books'
    username = 'sa'
    password = '123456'
    cnxn = pyodbc.connect(
        'DRIVER={};SERVER={};DATABASE={};UID={};PWD={}'.format(
            driver,
            server,
            database,
            username,
            password
        )
    )
    
    cursor = cnxn.cursor()
    
    cursor.execute("SELECT @@version;")
    row = cursor.fetchone()
    while row:
        print(row[0])
        row = cursor.fetchone()

## 报错信息 ##

/usr/bin/python3.8 /home/wj/wj/project/test/test.py
    Traceback (most recent call last):
      File "/home/wj/wj/project/test/test.py", line 10, in <module>
        cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER=192.168.50.106,1433;DATABASE=books;UID=sa;PWD=123456')
    pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
    
    Process finished with exit code 1

## 找出报错原因 ##

### 关闭防火墙 ###

控制面板\\系统和安全\\Windows Defender 防火墙\\自定义设置

关闭防火墙可成功连接。

### 得出结论 ###

SQL Server TCP连接端口没有开放。

## 解决方法 ##

### Windows ###

1.  打开SQL Server 配置管理器（SQL Server Configuration Manager），按图示查看SQL Server TCP端口号。![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center]
2.  进入`控制面板\系统和安全\Windows Defender 防火墙`，点击`高级设置`。![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 1]
3.  在`高级设置`中，点击`入站规则`，然后点击`新建规则`。![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 2]
4.  `新建规则`中，要创建的规则类型选择`端口(O)`。![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 3]
5.  下一步选择`TCP`和`特定本地端口`，`特定本地端口`就是SQL Server 配置管理器中找到的端口号。![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 4]
6.  下一步选择`允许连接`。![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 5]
7.  下一步何时应用该规则，默认选择即可。![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 6]
8.  下一步填写`名称`和`描述`，这一步可自定义。![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 7]
9.  下一步`完成`即可。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/1e22396b3f91469c861600f6b7504866.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221123/79b7de30ee2f44dda3f5a7288a4cd4f1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221123/e05e27c04c834fd68a634a8f50885fff.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 3]: /images/20221123/0d0ee5f81e46467fb5918adcbc698918.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 4]: /images/20221123/284265f28dbc42ada0182ddd4f7a4e69.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 5]: /images/20221123/66291f8e72e24de1a57bfe49a18877a8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 6]: /images/20221123/032186db2ec34eaa9e2eb4d82a586f00.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg1Njg3MQ_size_16_color_FFFFFF_t_70_pic_center 7]: /images/20221123/c1055883c8cf44fc8cf21fbae6ad4d81.png