Re: [Pymssql-users] OS Authentication

[Brad A. <bra...@gm...>]

On Jun 21, 2006, at 7:11 PM, Keith Jackson wrote:

> 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

This was posted over six months ago. I am also curious about the
answer, though I would normally want to use SQL Auth.  Did anyone
answer it off-list?