azuredatastudio icon indicating copy to clipboard operation
azuredatastudio copied to clipboard
verified publisher icon microsoft

Profiler States User Does Not Have Permission But Same Login Works in SSMS Profiler

Open CheetahChrome opened this issue 3 years ago • 3 comments

  • Azure Data Studio Version: 1.36.2
  • OS Version: W10 20H2

Steps to Reproduce:

  1. Connections - Servers Select Server to profile and get the green dot.
  2. Right click that server and select Launch Profiler

Toast message comes up stating

The user does not have permission to perform this action.

Go to OS and run SQL Profiler and profile the same Server. It works.

Message in Render.Log

An Unknown error occurred. Please consult log for more details.

Other logs don't have any relevant information.

Does this issue occur when all extensions are disabled?: Yes/No N/A

N/A

CheetahChrome avatar May 24 '22 14:05 CheetahChrome

@CheetahChrome the SQL Profiler installed with SSMS uses the older TRACE technology, whereas ADS Profiler uses XEvents. It's possible that permissions can be configured to allow one or other independently. Can you confirm whether the "XEvent Profiler" available in the SSMS Object Explorer tree works for you, since that should require the same permissions as the ADS Profiler. Thanks!

kburtram avatar Jun 06 '22 22:06 kburtram

Yes, with Standard and TSQL

XEvent

CheetahChrome avatar Jun 07 '22 00:06 CheetahChrome

I have encountered this same issue and have also confirmed the XEvent Profiler is accessible for Standard & TSQL, any news here?

bigdawgmj avatar Mar 21 '24 17:03 bigdawgmj