Forum Discussion

Brass Contributor

Jul 10, 2018

Solved

How do I know which user is hitting a particular SQL Server on my SharePoint Server?

Hello, I need to understand which user is hitting a particular SQL Server on my SharePoint Server? Also which web service is being hit? Also which app service is being hit? I checked the C...

spucelik
Jul 10, 2018
No...even though SharePoint is very "user" aware and contextual to that user with regards to security, version control etc, when SharePoint communicates with SQL it uses the app pool account. Getting traffic for a particular user from SQL traffic isn't possible. You'll need to rely on the SharePoint audit/reporting logs for that.

HTH.

Steve

spucelik

Microsoft

Jul 10, 2018

The accounts that hit SQL from SharePoint are the app pool accounts in IIS for the respective web applications. You can start a SQL Trace and monitor traffic/accounts coming in and view activity.

Test SharePoint
Brass Contributor
Jul 10, 2018
Thank you for the answer Steve.
But will this be applicable for a particular user?

Because I couldnt find anything handy.

Regards
- spucelik
  Microsoft
  Jul 10, 2018
  No...even though SharePoint is very "user" aware and contextual to that user with regards to security, version control etc, when SharePoint communicates with SQL it uses the app pool account. Getting traffic for a particular user from SQL traffic isn't possible. You'll need to rely on the SharePoint audit/reporting logs for that.
  
  HTH.
  
  Steve
  - Test SharePoint
    Brass Contributor
    Jul 19, 2018
    Hey Steve,
    
    Thanks for the above answer. I had another query: If I pull out the audit/reporting logs, I can only view Usage Details: Views for visitors. Also, I can see the number of views and updates made to a particular document location. Is there anything else from the SQL point of view?
    
    regards