Skip to content

Frequently Asked Questions

Jump to bottom
Sicong edited this page Feb 4, 2021 · 9 revisions

1. Will this project be open sourced?

It is! https://github.com/microsoft/mssql-django

2. What versions of Django and SQL Server are supported?

  • Supports Django 2.2, 3.0
  • Supports Microsoft SQL Server 2008/2008R2, 2012, 2014, 2016, 2017, 2019

3. Will this project work with Azure SQL DB?

Yes, this project is tested and works against Azure SQL DB.

4. Where do I submit feature requests or bug reports?

Issues should be opened under this GitHub repository.

5. Are there any limitations or known issues?

The following features are currently not supported:

  • mssql-django does not support SQL-based regex commands
  • Altering a model field from or to Autofield at migration

6. What are the future plans for this project?

The following features and additions are planned:

  • install instructions for a CLR .dll file to add SQL-based regex command support to SQL Server or Azure SQL DB
  • refactor project test suite to account for expected test case failures

7. 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.

8. '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",
        },
    }
}
Clone this wiki locally