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

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