Latest mssql-django db backend (officially from Microsoft) for Django 3.2 (LTS) MS SQL Server setup

[@gulamfahadahmed9365]

Thanks a lot, your 2 years ago video helped me today!

[@puluncode9929]

Glad to know that

[@asgeralia8802]

superb, this what i have been searching for the past 1 months. it is very helpful video....thanks.....

[@puluncode9929]

Great! Glad to know you've found what you are looking for.

[@classico360]

Thank you very much!

[@marwinfrancis6294]

Very Informative! How is it possible to connect Django with existing tables on a MS SQL Server?

[@puluncode9929]

Hi! You can use inspectdb tool by executing manage.py inspectdb command. This tool will create models.py file that is similar to your existing table(s). After the creation, you can check and customize it if required. I believe it is a helping hand rather than you type and refer to your existing table manually. The best reference that I can give you is this : django-book.readthedocs.io/en/latest/chapter18.html#integrating-with-a-legacy-database .😀

[@marwinfrancis6294]

@@puluncode9929 Thanks for taking the time to reply. This is really useful

[@puluncode9929]

@@marwinfrancis6294

[@킴슈-j5g]

😍😍😍😍😍

[@kanchanasupun]

Hi ! Iam using Local Host with Windows authenticator. how can i connect Please help me

[@puluncode9929]

I recommend you to use sql server authentication. but if you still want to use it with windows authentication, you need to change the settings in Step 6 of this video Python DATABASES = { 'default': { 'ENGINE': 'mssql', 'NAME': 'yourdatabasename', 'HOST': 'yourservername', 'OPTIONS': { 'driver': 'ODBC Driver 17 for SQL Server', # Adjust if needed 'Trusted_Connection': 'yes', # Enable Windows Authentication }, } } Hope this helps

[@zulfiqar7967]

Will it support for Ms Sql server 2012 version??

[@puluncode9929]

According to github.com/microsoft/mssql-django#features this engine has been tested on ms sql 2016, 2017 and 2019. None of them mentions about ms sql 2012. Don't worry, as for your question, I've test it with MS SQL 2012. Good news. Yes, mssql-django supports MS SQL 2012 version. it works bro...

[@alexanderconley5164]

thanks for the video, however, i seem to get an error when i try to make migrations. see error msg below: Got an error checking a consistent migration history performed for database connection 'default': ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]Neither DSN nor SERVER keyword supplied (0) (SQLDriverConnect); [08001] [Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute (0)') warnings.warn(

[@puluncode9929]

I believe it is regarding your Django to ms sql server. You can try to troubleshoot from the steps of this url : www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/