import pymssql
import pandas as pd

conn = pymssql.connect(server = r"DELLG3SQLEXPRESS", database = "MyDB", user="sa", password="******")
Q = pd.read_sql_query("select * from Scripts", conn)
df = pd.DataFrame(Q, columns=['Script'])

df.head()

runfile('E:/Dir/Code/002.py', wdir='E:/Dir/Code')
Traceback (most recent call last):

  File "<ipython-input-16-95d434087a3f>", line 1, in <module>
    runfile('E:/Dir/Code/002.py', wdir='E:/Dir/Code')

  File "C:UsersUserIDAnaconda3libsite-packagesspyder_kernelscustomizespydercustomize.py", line 786, in runfile
    execfile(filename, namespace)

  File "C:UsersUserIDAnaconda3libsite-packagesspyder_kernelscustomizespydercustomize.py", line 110, in execfile
    exec(compile(f.read(), filename, 'exec'), namespace)

  File "E:/Dir/Code/002.py", line 4, in <module>
    conn = pymssql.connect(server = r"DELLG3SQLEXPRESS", database = "MyDB", user="sa", password="******")

  File "srcpymssql.pyx", line 642, in pymssql.connect

OperationalError: (20009, b'DB-Lib error message 20009, severity 9:nUnable to connect: Adaptive Server is unavailable or does not exist (DELLG3\SQLEXPRESS)n')