1. How do I fix the Error: "Connection refused..." from SQL Server?
Check if TCP/IP is enabled.
Open SQL Server Configuration Manager. Under SQL Server Network Configuration. Enable TCP/IP and active the IP used for connection in TCP/IP Properties.
2. 'ODBC Driver 17 for SQL Server' : file not found
If multiple versions of ODBC driver installed on the machine, specify the path to the driver in settings.py
DATABASES = {
"default": {
...
"OPTIONS": {
"driver": "/location/to/libmsodbcsql-17.0.so.2.1",
},
}
}