Passthrough authentication for MSSQL

[Former user]

MSSQL servers allow for authentication to be supplied by the OS. This is done different ways on different interface drivers. Of the three which SA supports, adodbapi and pyodbc support it; pymssql doesn't. The patch attached supports passthrough by not specifying a username-parameter (mssql://server/dbname). I wasn't sure what to do re testing so I attach a standalone test module which takes 4 params: server dbname username password. This will then run through the different module combinations reporting success or failure.

Ummm... how do I attach patches etc?

[Former user]

Patch against r2356 of sqlalchemy\lib\sqlalchemy\databases\mssql.py

[Former user]

Python file to support test of new MSSQL passthrough authentication

[Former user]

Batch file to support testing of new MSSQL passthrough authentication

[paj]

This patch looks basically good, but the posted version re-introduces a bug fixed in #371. I'll post an alternative patch.

[paj]

Suggested patch

[Former user]

Good point; I was so busy rewriting, I didn't look to see what I was rewriting. Thanks for catching it!

[Former user]

(original author: ram) Comittted in rev 2412 and after hitting the Trac login button like 26 times. Thanks, guys.

[Mike Bayer]

Removing milestone: 0.3.6 (automated comment)