Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    192

    Unanswered: Tracing SQL user to an NT user

    User connects via SQL Server authentication.

    Is there anyway to trace an SQL Server user back to an NT accont from which they connect via?

    or put another way how do you find out which NT user is using the SA account?

  2. #2
    Join Date
    Feb 2004
    Posts
    78
    Not sure you can do that - if you are using SQL auth then the Sql Server doen't care what windows user you are.

    Try running
    Code:
    sp_who
    in Query Analyzer and you can see the MACHINE that is currently using the sa/other logon along with the database.

    Or, in Enterprise Manager, go to Management->Current Activity->Process Info for more information.

    Hope this helps,
    Eric

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •