2

Application server uses single login to connect to a database . There are multiple users connected to the database through the login in that case the information shows only the application login and the host name .

How do i track the individual user that is connected to database through the app server?

Since the dmv only shows the application login and the host name which is same for all the users that are connected.

  • What's the application? Do you control it? – Tom V Jul 28 '17 at 11:42
1

You cannot in this case. SQL has no way to know the windows login using the application account and workstation connecting via application server.

See this answer especially read second answer by Aaron Bertand which explains in details.

Who is the person using a SQL login?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.