Profiler

• luda

  SSC Veteran

  Points: 249

  More actions

  March 9, 2004 at 10:09 am

  #86251

  Is it possible to give the right to run Profiler for developers without giving them sysadmin fixed server role?

  I found on Microsoft site that the user account that is used to run SQL server profiler must be granted permission to connect to SQL server. The login account must also be granted permissions to execute sql server Profiler extended stored procedures. There are only 5 SP’s. I granted the rights to execute these procedures to the user but when he try to open the profiler the error is generated: the user must be sysadmin fixed server role.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737424

  More actions

  March 9, 2004 at 10:21 am

  #498012

  No, because of the security implications, only sysadmins can run profiler.