Issue 64: Cannot Connect As Domain User
Status:  NoFix
Owner: ----
Closed:  Dec 2009
Reported by bryan.ko...@gmail.com, Jul 24, 2009
What steps will reproduce the problem?
1. conn = pyodbc.connect("...UID=DOMAIN\\user...")

What is the expected output? What do you see instead?
Expected a valid connection object. Received this instead:

ProgrammingError: ('42000', "[42000] [FreeTDS][SQL Server]Login failed for user ''. The user is 
not associated with a trusted SQL Server connection. (18452) (SQLDriverConnectW)")


What version of the product are you using? On what operating system?
2.1.6, OS X 10.5 Server

Please provide any additional information below.
This is a 64-bit build of pyodbc running against a 64-bit build of FreeTDS. I can log in as a 
domain user with tsql, pyodbc appears to be throwing the user name away if it contains a slash.


Aug 7, 2009
Project Member #1 mkleehammer
I'm not sure if tsql actually goes through the ODBC layer or not.  The documentation 
seems to indicate it makes a direct connection using the TDS protocol.

Can you generate an ODBC trace of both the tsql connection and the pyodbc connection 
attempt?  pyodbc doesn't modify the connection string, so I really suspect we can 
reformat the connection string.
Status: Accepted
Dec 31, 2009
Project Member #2 mkleehammer
No more information since August, so closing.
Status: Invalid
Nov 21, 2010
Project Member #3 mkleehammer
(No comment was entered for this change.)
Status: NoFix