How to install MSSQL for Python on Windows

SQL Server (Microsoft) is being used by organizations to manage their enterprise level applications built on the .Net framework.

Python comes into play while building applications for complex algorithms in a simple manner with high performance.

The scenario is to make a connection between MS SQL and Python application on Windows environment. 

MS SQL Express Installation on Windows

1. Go to https://www.microsoft.com/en-in/sql-server/sql-server-downloads 

2. Scroll down to see “download a free specialised edition”.

3. Click Download now below the Express section.
4. Once the executable is downloaded, go to the folder in which it is downloaded. 
5. Double-click exe. 

6. Once ready, the below screen shall be shown.

7. Keep the option as Custom. Click it to move to the next screen.

8. Specify the location in which the SQL Server should be downloaded.
9. Press Install. The process is initiated.

10. Once the download process is done, it shall be shown.

11.  The installation process is initiated by Wizard.

12. Go with the first option. The license terms shall be shown.

13. Tick the box – I accept terms and conditions. Press Next.

14. Do not do anything. The next processing starts after this.

15. Press Show Details. The view is expanded.

16. Once completed, the below screen shall be shown.

17. Press Next. The setup file installation starts.

18. Once done, the screen is shown as below.

19. Press Next. 

20. Tick the first check box – Database Engine Servers.

21. Press Next. The Instance Configuration screen shall be shown.

22. Give the instance a name and press Next.

23. Press Next on the Server Configuration page.

24. Choose the Mixed Mode option under the Authentication Mode section.

25. Set the password in the password boxes that appeared on the above screen.

26. Press Next. The process started.

27. Once the process completes, it asks for restarting the computer.

28. OK to restart. 

SSMS Setup

1. Go the Microsoft Web page to download SSMS.

2. Once downloaded, run the executable.

3. Press Install. The progress bar screen shall be shown.

4. On success, the screen is shown.

5. Close to shut the screen. 
6. To verify the successful installation, start MSSQL server from the Windows menu.

7. Under that, SQL Server Management menu is available. Click that.

8. The console opens up as below.

9. Type the instance name you gave in the Server name field.
10. Click Connect. Success.

Also read:

• How to install MySQL in Linux for Python
• How to install Python on Chromebook
• How to install Kali Linux on Mac
• How t install MySQL on Mac for Python
• How to install MySQL on Windows for Python
• Best Linux Distros for gaming
• How to replace Chrome OS with Linux
• Debian vs Ubuntu
• How to install Python IDLE in Linux

Installation of pyodbc

1. Make sure python is available in the system.
2. Open the command prompt.
3. The below command shall be executed.

c:\user\> pip install pyodbc

4. The installation shall begin and finish as below.

5. Enter the command “python” as below.

C:/users> python

6. The version shall be displayed.

7. The next command is to be executed by pressing ENTER as below.

import pyodbc

8. All good. 

9. Execute the below –

cnx = pyodbc.connect(‘Driver ={SQL Server};’‘Server=localhost;’ ‘Database=test;’ ‘Trusted_Connection=yes;’)

10. Success as shown below.

11.  Next, type the command and execute as below.

cursor = cnx.cursor()

12. Then, execute  the below command.

cursor.execute (‘SELECT FNAME from EMPLOYEE_MASTER’)

13. Now, type the following to print the row as a result of Above SQL statement.

for row in cursor: print(row)

14. You shall see the records displayed in the command window.
15. The connectivity between SQL Server db and Python is established successfully.

Takeaway

Following the steps correctly makes the developer life easy in setting up the multi-tier application environment and easily interact with different components easily.