Hi,
First off, thanks for developing this code. It has made the fact that I've been forced to use M$ products much less painful. :)
Our SQL Server 2005 instance is setup to not support SQL authentication, only OS authentication. On OSX I have no problem making this work by using a username like: HOSTNAME\username in my connect call. Everything then works fine.
On windows however, I consistently get login failures. After looking at the network traffic with ethereal it appears that pymssql is trying to do SQL auth instead of OS auth.
How can I force pymssql on windows to us OS auth? Any suggestions would be greatly appreciated.
thx,
--keith
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
First off, thanks for developing this code. It has made the fact that I've been forced to use M$ products much less painful. :)
Our SQL Server 2005 instance is setup to not support SQL authentication, only OS authentication. On OSX I have no problem making this work by using a username like: HOSTNAME\username in my connect call. Everything then works fine.
On windows however, I consistently get login failures. After looking at the network traffic with ethereal it appears that pymssql is trying to do SQL auth instead of OS auth.
How can I force pymssql on windows to us OS auth? Any suggestions would be greatly appreciated.
thx,
--keith
I too am having this issue. Is there any resolution?
Please be sure to use ntwdblib.dll at its latest version, you can download it from the pymssql's CVS: http://pymssql.cvs.sourceforge.net/pymssql/pymssql/