We have a software that comes with the WEB Portal and I am trying to capture who logins to the WEB site. Basically, we have created multiple logins in the appliacation for our different customers to login to our WEB site. The connectivity has to go through the OLEB or ODBC with SQL sa login to get to our SQL 2000 server. Is there a way to capture who login and with timestamp. Below is the small diagram of description. Thanks.
Multiple logins Connections DB Server
--------------- ----------- ---------
loginA ___
loginB ___ WEBSITE ----- ODBC or OLEB ---------- SQL2000
loginC ___ with sa login
Multiple logins Connections DB Server
--------------- ----------- ---------
loginA ___
loginB ___ WEBSITE ----- ODBC or OLEB ---------- SQL2000
loginC ___ with sa login