-
Title
Can Toad display what NT User made the transaction in the Log Reader? -
Description
Can Toad display what NT User made the transaction in the Log Reader? It currently notes “sa” for every transaction.
Toad helps notes “The Log Reader can collect NT User, SQL Login, User Host, and Application information for transactions started only when it is connected to the server.”
What exactly does this means?
Can the NT User information be included in the Export option within the Log Reader?
-
Resolution
Log Reader is able only retrieve NT User name if Windows Authentication is using to connect Sql Server.
If “sa” is noted for every transaction, it may be that the users are using one “sa” account to login to the SQL Server. This may be the case when users are working through a Web App which connects to SQL Server by using one (“sa”) account.
In general, SQL does not collect the userID, only the SID (the transaction SID). To get a userID Toad Log Reader uses and queries Active Directory (AD) to map the SID and get username and other user info. If the SID is not local to the server you are running log reader on, or a SQL user account, then the mapping must be done via a request to a domain controller and an Active Directory lookup.
To verify this, use a network trace to troubleshoot this. Most likely the SID (which is what is stored by SQL) cannot be traced to a userID in AD. A network trace, taken while the operation is being performed should confirm that.Attached is a screenshot of the network trace and packets you may want to review.STATUS:Reporting/export options do not include the NT User information at this time.Enhancement request TSS-1004 for this has been submitted for review to be included in a future relase of Toad for SQL Server. -
Defect ID
TSS-1004 -
Attachments
