http://msdn.microsoft.com/msdnmag/issues/05/09/SecurityBriefs/
http://msdn2.microsoft.com/en-us/library/bsz5788z.aspx
Thanks for the links Tim! This really seems to go in the right
direction. Tomorrow I will talk to my colleague who takes care of the
webserver.
Dirk
--
I already mentioned, that it the following works when it's NOT executed
by the webserver:
code
import adodbapi
db = adodbapi.connect (Provider=sqloledb;Data Source=VODEV1;Initial
Catalog=EVOBACK;Integrated Security=SSPI;)
q = db.cursor ()
q.execute (SELECT SYSTEM_USER)
print q.fetchone ()
[Dirk Hagemann]
| Now I found this work-around: [... snip opening restricted file ...]
| And this works! [...] So on the one hand the IIS works fine with the
| fileserver, but the IIS does not work with the SQL-Server. And it
seems
| not to be the fault of the code, because it works when it's
You have a user named null?
Off-hand, it looks very much like the CGI script is still running
with the privileges of the web-server, and /that/ is set up in a locked
down account that doesn't have connection rights.
I also thought this might be the reason, but when I include
code
import adodbapi
db = adodbapi.connect (Provider=sqloledb;Data Source=VODEV1;Initial
Catalog=EVOBACK;Integrated Security=SSPI;)
q = db.cursor ()
q.execute (SELECT SYSTEM_USER)
print q.fetchone ()
q.close ()
/code
Cool! That works :-)
Thanks a lot (again) Tim!
Have a great week
Very strange. It works when I directly run the script, but when I use
this script as a CGI-script on a webserver, I get this error:
File D:\Web\test\adodbapi.py, line 224, in connect raise
DatabaseError(e) adodbapi.DatabaseError: (-2147352567, 'Exception
occurred.', (0, 'Microsoft OLE DB Provider
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) ?
Kind regards
Dirk
--
http://mail.python.org/mailman/listinfo/python-list
[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
[Dirk Hagemann]
| I think the adodbapi module is interesting. I just tried it
| out but got this error:
| 'Exception occurred.', (0, 'Microsoft OLE DB Provider for ODBC
| Drivers', [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
| for user '(null)'. Reason: Not associated with a
Hi Tim!
I think the adodbapi module is interesting. I just tried it out but got
this error:
'Exception occurred.', (0, 'Microsoft OLE DB Provider for ODBC
Drivers', [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
for user '(null)'. Reason: Not associated with a trusted SQL Server
My windows-user has already access-permission to the database.
Thanks for the exmaple - I will try it out on monday! :-)
Enjoy your weekend!
Dirk
--
http://mail.python.org/mailman/listinfo/python-list
Dirk Hagemann napisał(a):
'Exception occurred.', (0, 'Microsoft OLE DB Provider for ODBC
Drivers', [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
for user '(null)'. Reason: Not associated with a trusted SQL Server
connection., None, 0, -2147217843), None)
This indicates, that
Tim Golden napisał(a):
import adodbapi
db = adodbapi.connect (Provider=sqloledb;Data Source=VODEV1;Initial
Catalog=EVOBACK;Integrated Security=SSPI;)
This kind of connection doesn't work for me. I think it's some
misconfiguration on AD side, but I still get not associated with
trusted
13 matches
Mail list logo