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
Topic Options
Post Options
Thanks(0)
