pymssql: How to use windows authentication when running on a non-windows box

python sql-server pymssql
Dan picture Dan · Jan 23, 2014 · Viewed 9.2k times · Source

Is there a way for python to connect to MS SQL Server using Windows Authentication, even when not running the python app on a windows box?

I'm trying to do this with pymssql, but the examples mostly seem to assume that you're running on windows.

If there is a way to make this connection using some other library, please feel free to suggest, but I do like how pymssql is simple to install and deploy via pip.

I want to connect to 2005/2008 databases, and I'm running Ubuntu 13.04 (but I can upgrade to a later Ubuntu if it makes a difference)

SOLUTION:

It turns out that pymssql can connect to my database via my windows username and password. But to do so, I need to pass the actual username/password like this:

pymssql.connect(host, 'THEDOMAIN\\theusername', 'thepassword', db)

The solution EkoostikMartin provided is still good though (if you do not want to store a password somewhere, which is probably the point to windows auth anyway)

Answer

EkoostikMartin picture EkoostikMartin · Jan 23, 2014

You can use the SQL Server ODBC driver for linux, and set up Kerberos.

See this article - http://technet.microsoft.com/en-us/library/hh568450.aspx

Related questions

MSSQL in python 2.7

Is there a module available for connection of MSSQL and python 2.7? I downloaded pymssql but it is for python 2.6. Is there any equivalent module for python 2.7? I am not aware of it if anyone can provide links. Important note: in …

Read More
python and pymssql

I'm new to python. I'm trying to query a MSSQL database. import pymssql conn = pymssql.connect(host='hostname', user='username', password='password', database='dbname') cursor = conn.cursor() sql = "select count(*) from T_Email with (nolock) where Transmit is null" cursor.…

Read More
Using pymssql to insert datetime object into SQL Server

How do I insert a datatime object using pymssql? I know that the SQL Server table is expecting a datetime object, let's say in position 3. I've tried all three of these: cursor.execute("INSERT INTO MyTable VALUES(1, 'Having Trouble', datetime.…

Read More