Connecting to Azure SQL Database

Starting with version 2.1.1 pymssql can be used to connect to Microsoft Azure SQL Database.

Make sure the following requirements are met:

Use FreeTDS 0.91 or newer
Use TDS protocol 7.1 or newer
Make sure FreeTDS is built with SSL support
Specify the database name you are connecting to in the database parameter of the relevant connect() call
IMPORTANT: Do not use username@server.database.windows.net for the user parameter of the relevant connect() call! You must use the shorter username@server form instead!

Example:

pymssql.connect("xxx.database.windows.net", "username@xxx", "password", "db_name")

or, if you’ve defined myalias in the freetds.conf FreeTDS config file:

[myalias]
host = xxx.database.windows.net
tds version = 7.1
...

then you could use:

pymssql.connect("myalias", "username@xxx", "password", "db_name")

pymssql