# Django3.0+ connects to SQL Server
**URL:** https://forum.djangoproject.com/t/django3-0-connects-to-sql-server/2796
**Category:** Using Django
**Created:** [June 4, 2020, 7:47am UTC](https://forum.djangoproject.com/t/django3-0-connects-to-sql-server/2796 "2020-06-04T07:47:35Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@JingChaoLiang](https://forum.djangoproject.com/u/JingChaoLiang)
#### Post date: [June 4, 2020, 7:47am UTC](https://forum.djangoproject.com/t/django3-0-connects-to-sql-server/2796/1 "2020-06-04T07:47:35Z")
What should I do to make Django3.0+ connects to SQL Server?
When I follow “[https://pypi.org/project/django-mssql-backend/](https://pypi.org/project/django-mssql-backend/)” step by step, It tells me that it can support Django 2.2, 3.0 and depend on Django 2.2 or newer.
But When I follow “[https://pypi.org/project/django-pyodbc-azure/](https://pypi.org/project/django-pyodbc-azure/)” to install “django-pyodbc-azure” ,It tells me that it just supports Django 2.1.
So,how can I do now?Can someone help me?!!!
---
### Author:  [@adamchainz](https://forum.djangoproject.com/u/adamchainz)
#### Post date: [June 4, 2020, 8:07am UTC](https://forum.djangoproject.com/t/django3-0-connects-to-sql-server/2796/2 "2020-06-04T08:07:05Z")
You only one of them. Try django-mssql-backend ?
---
### Author:  [@JingChaoLiang](https://forum.djangoproject.com/u/JingChaoLiang)
#### Post date: [June 4, 2020, 8:14am UTC](https://forum.djangoproject.com/t/django3-0-connects-to-sql-server/2796/3 "2020-06-04T08:14:26Z")
I have tried django-mssql-backend only,but it said I should install django-pyodbc-azure.
And I also tried django-pyodbc-azure only,it was a definite failure…
---
### Author:  [@JingChaoLiang](https://forum.djangoproject.com/u/JingChaoLiang)
#### Post date: [June 4, 2020, 8:21am UTC](https://forum.djangoproject.com/t/django3-0-connects-to-sql-server/2796/4 "2020-06-04T08:21:10Z")
My installation records and Settings are as follows:
---
### Author:  [@chriswedgwood](https://forum.djangoproject.com/u/chriswedgwood)
#### Post date: [June 4, 2020, 12:24pm UTC](https://forum.djangoproject.com/t/django3-0-connects-to-sql-server/2796/5 "2020-06-04T12:24:10Z")
Hi
Are you running django in a virtual environment? I created a virtual environment in windows and ran pip install django-mssql-backend and I ran pip freeze after which showed me that pyodbc was installed so your pyodbc error suggests you are not?
---
### Author:  [@adamchainz](https://forum.djangoproject.com/u/adamchainz)
#### Post date: [June 4, 2020, 3:54pm UTC](https://forum.djangoproject.com/t/django3-0-connects-to-sql-server/2796/6 "2020-06-04T15:54:54Z")
The django-mssql-backend docs say:
> _django-mssql-backend_ is a fork of [django-pyodbc-azure](https://pypi.org/project/django-pyodbc-azure/)
A “fork” is an updated copy. Therefore you should only install django-mssql-backend. If you installed django-pyodbc-azure, you should try uninstalling both of them then installing only django-mssql-backend.
django-mssql-backend’s installation instructions say:
> Installation
>
> 1. Install pyodbc and Django
> 2. Install django-mssql-backend
You’re seeing this error:
> Error loading pyodbc module: No module named ‘pyodbc’
This means that you haven’t installed pyodbc as per step 1.
That library is here: [pyodbc · PyPI](https://pypi.org/project/pyodbc/)
I think if you `pip install pyodbc` it should work.
@chriswedgwood is correct - installing django-mssql-backend should install pyodbc automatically. This is because it’s in its `install_requires` declaration: [https://github.com/ESSolutions/django-mssql-backend/blob/master/setup.py#L27](https://github.com/ESSolutions/django-mssql-backend/blob/master/setup.py#L27) .
---
### Author:  [@JingChaoLiang](https://forum.djangoproject.com/u/JingChaoLiang)
#### Post date: [June 5, 2020, 1:20am UTC](https://forum.djangoproject.com/t/django3-0-connects-to-sql-server/2796/7 "2020-06-05T01:20:14Z")
I’m running diango in my desktop.Adopted @adamchainz’s suggestion,which try uninstalling both of them then installing only django-mssql-backend,it works!
---
### Author:  [@JingChaoLiang](https://forum.djangoproject.com/u/JingChaoLiang)
#### Post date: [June 5, 2020, 1:21am UTC](https://forum.djangoproject.com/t/django3-0-connects-to-sql-server/2796/8 "2020-06-05T01:21:17Z")
It works!!! Thank a lot.