How To Connect Python to Microsoft SQL Server

Prerequisites To Follow this Exercise : 
  1. Microsoft SQL Server Database Express Edition & Adventure Works DataWarehouse - If you Don't have a Microsoft SQL Server express Database and want to install it in your system and also install AdventureWorks DW , Follow - 
  2. Python Installed in your System : If you are a new user to Python and want to know how to install Python via the Anaconda Distribution , You can go through the step by step Blog i have written to install Python via Anaconda Distribution & start using Jupyter Notebook :

Once you have the Microsoft SQL Server Express Edition and Python Installed in your system you are Good to Go ahead and follow the below Use Case and Example. 

Connecting Python with SQL Server
 If you are looking for Python Corporate Training - Instrovate Corporate Training
 If you are looking for Python Consulting Work - Instrovate Consulting Services

IN porder to connect python to Microsoft SQL Server we first need to set up ODBC Connection in system control-panel. Following are the steps for the same:

  1. Open Control Panel
  2. In the search Bar on top right corner type ODBC:

(3) As per your System Configuration click on the link either Set up ODBC data sources (32-bit) or Set up ODBC data sources (64-bit)

(4) After clicking below screen will get displayed :


(5) Click on the Add Button :

(6) After clicking add following screen is displayed:


(7) Click on the SQL Server Native Client 11.0 as indicated above

(8) Now click FInish  and then below screen will be displayed:


(9) IN the name filed give some name to your new DataBase source.

(10) IN description try to give some description of the ODBC Data SOurce.

(11) IN the server column type in the Server name or DSN of your SQL Server Database installed on your system

(12) After this click on Next. After which below screen will be displayed :

(13) Click ON Next to continue to get the below screen

(14 ) After clicking Next below screen is displayed in which click finish

(15) Click Test Data SOurce which must be successful if all the details filled are correct

(17) Click OK and then in the next screen again click OK to get the initial Set up DOne

(18) NOw in order to test the connection from python script first of all make sure that the SQL Server is up and running in your system.

(19) Below is the simple program to fetch the result of select query form the SQL Server Database:

(20) pyodbc is a python library to establish an ODBC Connection to desired Data SOurce

(21) Following are the property needs to be set while establishing connection from python:

       Driver - Name which we have added earlier while setting up ODBC COnfiguration



       Server - Server Name or DSN of SQL Server running on local or remote system

       Database - Database Name to which connection needs to be established

       Trusted_connection - By default is yes so need to be used as it as given in above


(22) Running the above python code must display the content of the table queried in the program:

Note :- The Database used here is AdventureWorks2017






There are no entries yet.
Please enter the code
* Required fields

Subscribe to Our YouTube Channel To recieve updates on Free Learning



Visit Our Website to View the Upcoming Training Schedule

Looking for Corporate Training ? Reach out to us at

Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of  Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business. 

We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares  being rebuilt with Artificial Intelligence Capabilities .

We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return . 


Whatsapp at +91-9953805788 or email at - if you would like to know more . 


  • Corporate Tableau Training in Gurgaon
  • Corporate Data Analytics Training in Gurgaon
  • Corporate Microsoft Power BI Training in Gurgaon
  • Corporate Microstrategy Training in Gurgaon
  • Corporate Google Data Studio Training in Gurgaon
  • Corporate Python Training in Gurgaon
  • Corporate Advance Analytics in R Programming Training in Gurgaon
  • Corporate Machine Learning Training in Gurgaon
  • Corporate Deep Learning Training in Gurgaon
  • Corporate Data Visualization Training in Gurgaon



Instrovate Technologies

Noida, Gurgaon 

Hit Your Refresh Button To Rise Higher

Subscribe to Our YouTube Channel To Receive Updates on the Latest Free Learning Video Added

Print Print | Sitemap
All rights reserved @ Instrovate Technologies

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy