Recently I was tasked to rewrite some Perl cgi scripts. My time is valuable to me, so I rewrote them in Python! One of the functions of the cgi scripts was to connect to a Microsoft SQL Server 2008 r2 instance. A quick glance at the perl scripts showed me we were using ODBC to connect to SQL Server. After a few hours of reading online, I settled upon what I believe is the best method, using pyodbc.
pyodbc is an open source library for python, available at https://code.google.com/p/pyodbc/ Installation is pretty straight forward, but I will outline the steps here and help you connect to SQL Server as well.