title: How to configure the Database setting Django-MSSQL (windows)?
body: <p>I'm new to Django and currently trying to connect my project using python 3.6.4 and Django2.1.2 with SQL server, I tried multiple drivers connectors
  (<a href="https://i.stack.imgur.com/lXPQA.png" rel="nofollow noreferrer">libraries installed</a>),</p>
  
  <pre><code>&gt; (irisha) C:\Users\MOHMMED-PC\Desktop\SOUS BUREAU\WEB\irisha\src&gt;pip freeze
  adodbapi==2.6.0.7
  Django==2.1.2
  django-mssql==1.8
  django-pyodbc==1.1.3
  django-pyodbc-azure==2.1.0.0
  django-sqlserver==1.11
  pyodbc==4.0.24
  pypyodbc==1.3.4
  python-tds==1.9.1
  pytz==2018.6
  six==1.11.0
  </code></pre>
  
  <p>but without result, the last driver connector I used is pyodbc:
  <a href="https://i.stack.imgur.com/UiIVf.png" rel="nofollow noreferrer">Settings</a>,</p>
  
  <pre><code>DATABASES = {
  'default': {
      'ENGINE': 'sql_server.pyodbc',
      'NAME': 'iristest',
      'USER': 'sa',
      'PASSWORD': '1234',
      'HOST': '127.0.0.1\test',
      'PORT': '1433',
  
  
  },}
  </code></pre>
  
  <p>but some errors appeared:<a href="https://i.stack.imgur.com/815VZ.png" rel="nofollow noreferrer">errors</a></p>
  
  <blockquote>
    <p>django.db.utils.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')</p>
  </blockquote>
  
  <p>thanks for helping me to find a solution.</p>