in our intranet we have an active-directory with two groups. one called
reading and the other one writing. we use windows-authentication to
know who is comming in. we get the REMOTE_USER-Name, lookup ads and get
the real name and the group the user is in.
up to now we choose which connection string and user to sql-server to
use (read or write) because of the group name from ads.
so far so good, but we want to know who is currently using the
database. we only get our two different read or write-connections but
no specific user.
how do ...