search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 899 forks source link

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

Open CheetahChrome opened 2 years ago

CheetahChrome commented 2 years ago

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

kburtram commented 2 years ago

@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!

CheetahChrome commented 2 years ago

Yes, with Standard and TSQL

XEvent
bigdawgmj commented 6 months ago

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