Bobspadger / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

Cannot Connect As Domain User #64

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
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.

Original issue reported on code.google.com by bryan.ko...@gmail.com on 25 Jul 2009 at 2:00

GoogleCodeExporter commented 9 years ago
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.

Original comment by mkleehammer on 8 Aug 2009 at 1:56

GoogleCodeExporter commented 9 years ago
No more information since August, so closing.

Original comment by mkleehammer on 1 Jan 2010 at 6:25

GoogleCodeExporter commented 9 years ago

Original comment by mkleehammer on 21 Nov 2010 at 4:43