[python-sybase] python-sybase + FreeTDS + MS SQL Server

[Charles Bearden]

> > >My question is how to supply authentication credentials to the MS
SQL
> > >Server.  I have to use a domain login userid like DOMAIN\username.
> When
> > >I create a Python script like this:
> > >
> > >------------------------------------------------------------
> > >import Sybase
> > >
> > >dsn =3D 'theDb'
> > >uid =3D 'MYDOMAIN\jrandomuser'
> > >pwd =3D 'h4x0r'
> > >cx =3D Sybase.connect(dsn, uid, pwd)
> > >
> > >cx.close()
> > >------------------------------------------------------------
> > >
> > >
> > >
> > Try: uid =3D 'MYDOMAIN\\jrandomuser'
> >
> > Don't forget Python's string quoting rules!  ;)
>=20
>=20
> Thanks for your response.  I should have mentioned that I had already
> tried several permutations of quoting, including raw strings and the
> escaped backslash you recommended.  Still no joy: the "Login failed
for
> user '(null)'" exception is still thrown.  And when I catch that
> exception to print 'uid' before re-raising the exception, it prints
the
> UID correctly, with the single backslash between domain and username
> (and it does so whether or not I've escaped the backslash).
>=20
> The UID and password I am actually using are my personal domain
> credentials that I type in every day to log on.  I'm puzzled by the
> '(null)' user thing.  Does that mean that the string I am passing as
UID
> is not getting through, or that it is not recognized?
>=20
>=20
> Are your user accounts on the SQL Server using the integrated NT login
for
> authentication, or are they using a separate password?  I don't know
for
> sure, but I'd wonder if FreeTDS supported the integrated login scheme.

Yes, FreeTDS does handle domain logins correctly.  In fact, I've now
gotten it to work with the libiodbc driver manager and mx.ODBC.  Also,
the FreeTDS 'tsql' utility can connect with a domain login:

$ ./tsql -S servername -U 'DOMAIN\uname'
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:=20
Msg 5703, Level 0, State 1, Server UT160617, Line 0
Changed language setting to us_english.
1>

The only trick is not to supply the password on the command line, but at
the prompt after executing the tsql command.  But basically, FreeTDS as
used by other interfaces is able to talk to the server in question,
whatever the authentication method.

For now I will probably just go with the mx.ODBC.iODBC interface, since
it works.  For security reasons, it would probably be good to get
db-specific uids and passwords, rather than using my own credentials
(I'm not the sysadmin or DBA here, so I don't make the policies).

If the python-sybase developers think it would be useful, I would be
willing a little later to send TDS dumps for successful logins via iODBC
and for unsuccessful attempts via python-sybase.  I don't know if it is
a high priority for this project to make domain logins work with
FreeTDS.

Thanks for the responses,
Chuck