MS SQL Server: NT Authentication. Possible?

[Tim Golden]

[Dirk Hagemann]

| Hi!
| Is it somehow possible to access an MS SQL Server database from python
| by NT-Authentication or do I have only the possibility to use an
| SQL-Account with DB = odbc.odbc(myDB/myAccount/myPW) ?

(dsn examples from http://www.connectionstrings.com/)

+ Object Craft MSSQL module:
http://www.object-craft.com.au/projects/mssql/
can do by specifying blank username/pwd
<= Python 2.3 only

+ adodbapi: http://adodbapi.sourceforge.net 
can use Trusted Connection
eg "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated
Security=SSPI;"

+ pymssql: http://pymssql.sourceforge.net/
can only do named user

+ mx.ODBC: http://www.egenix.com/files/python/mxODBC.html
should be able to use Trusted Connection
eg  "Driver={SQL
Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;" 
Commercial License may be needed

TJG

________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________