Error [HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired

[legioz]

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

I am getting the error above, I am using Django 3.0.5 with django-mssql-backend 2.8.1

My config on settings.py is:

DATABASES = {

   'default': {
       'ENGINE': 'django.db.backends.mysql',
       'NAME': config('MYSQL_DEFAULT_DB'),
       'USER': config('MYSQL_DEFAULT_USER'),
       'PASSWORD': config('MYSQL_DEFAULT_PASS'),
       'HOST': config('MYSQL_DEFAULT_HOST'),
       'PORT': config('MYSQL_DEFAULT_PORT'),
       'OPTIONS': {
           'init_command': "SET sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO'"
       },
   },

     'db2': {
       'ENGINE': 'sql_server.pyodbc',
       'NAME': config('DB2_DB'),
       'HOST': config('DB2_SERVER'),
       'PORT': config('DB2_PORT'),
       'USER': config('DB2_USER'),
       'PASSWORD': config('DB2_PASS'),
       'OPTIONS': {
           'driver': 'ODBC Driver 17 for SQL Server',
       },
   },
.
.
.

The port DB2_PORT variable cannot be an empty string.

All variables are beeing passed correctly and I can connect directly to DB2 using others MSSQL clients

[

[interpeix]

@luizfelipevbll we are facing the same issue on a serverless database, we thought that's related with auto-pause feature, but after digging a bit more we are less confident that is the issue. Any help would be apreciated.

[ibrahimduran]

I don't have much experience with SQL Server but in my case issue was caused by ODBC drivers (testing with sqlcmd failed, mssql-cli from pip worked) and I had to create a data source in /etc/odbc.ini and connect through DSN. Here's a detailed explanation: https://stackoverflow.com/a/48367250

[KhushbooKaul2002]

@luizfelipevbll : did you find a solution to the problem you were facing because I am also facing the same issue trying to connect my django app with the ms sql server.

[nickolasgcb]

I got this same issue, how you solved it?