RE: Audit Table
From: Yuan Shao (v-yshao_at_online.microsoft.com)
Date: 12/30/03
- Next message: Len Kalman: "xp_sqlagent_proxy_account"
- Previous message: anonymous_at_discussions.microsoft.com: "RE: Failed to start a new trace - SQL PROFILER"
- In reply to: Michelle: "RE: Audit Table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 30 Dec 2003 07:47:26 GMT
Hi Michelle,
Thanks for your feedback. In this case, as IIS and SQL Server are on the
same machine, a user's credentials (username:password) will be used to
login to SQL Server after that user has logged into IIS using Basic
authentication.
We are able to record the login information (current login username and
timestamp) for SQL Server using the trigger and the related functions
(SUSER_SNAME, GETDATE() etc.). However, it seems impossible to monitor the
logins to IIS from the SQL Server side. SQL Server is unable to be used to
monitor the logins to IIS.
Please feel free to post in the group if this solves your problem or if you
would like further assistance.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
- Next message: Len Kalman: "xp_sqlagent_proxy_account"
- Previous message: anonymous_at_discussions.microsoft.com: "RE: Failed to start a new trace - SQL PROFILER"
- In reply to: Michelle: "RE: Audit Table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
