SQL 2000 / IIS Authentication
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24177
Printed Date: 28 March 2026 at 4:56pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL 2000 / IIS Authentication
Posted By: Gary
Subject: SQL 2000 / IIS Authentication
Date Posted: 15 August 2007 at 11:56am
|
Hi,
I have an asp based app running on Server A which connects via ODBC to SQL 2000 on Server B. The connection uses a generic SQL account (eg aspUser) and IIS is configured to Windows Authentication.
What I need to do is create an audit trail for all data changes in SQL. It seems the preferred approach would be to use SQL Triggers. The problem here is that the Trigger does not have the IIS Authentication data (username) available.
My question therefore is:
Is it possible for SQL to somehow pull the IIS Authentication details from Server A despite the fact that the ODBC connection uses a SQL account?
Many Thanks
Gary
|
Replies:
Posted By: michael
Date Posted: 20 August 2007 at 3:28pm
The disadvantage of using SQL Authentication is that it is very hard to audit. If all queries are procedure driven you can add a user name variable to every proc and have a manual audit table. Triggers are very expensive so this might be a better approach anyway or update to SQL 2005 which has better auditing.
 ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |