Debug sql server queries without any windows user

• ebrahim_520

  Grasshopper

  Points: 13

  More actions

  February 20, 2016 at 11:09 pm

  #305010

  I need your help for debugging.

  I Want to allow my SQL Server logins to debug while windows login is disable or haven't SysAdmin Role.

  When I disable Windows Login, I get this error:

  http://i.stack.imgur.com/XY1FZ.png

  When I revoke sysAdmin role form it, I get this error:

  http://i.stack.imgur.com/EpLsJ.png

  What special solution do you have for allow some logins to have debug permission????

• Jeff Moden

  SSC Guru

  Points: 1004696

  More actions

  February 20, 2016 at 11:22 pm

  #1859978

  ebrahim_520 (2/20/2016)

  ---

  I need your help for debugging.

  I Want to allow my SQL Server logins to debug while windows login is disable or haven't SysAdmin Role.

  When I disable Windows Login, I get this error:

  http://i.stack.imgur.com/XY1FZ.png

  When I revoke sysAdmin role form it, I get this error:

  http://i.stack.imgur.com/EpLsJ.png

  What special solution do you have for allow some logins to have debug permission????

  Here's an article on the subject. https://msdn.microsoft.com/en-us/library/cc646024(v=sql.120).aspx The key is in the following statement from that article (emphasis is mine)...

  •The Database Engine Query Editor window must be connected by using either a Windows Authentication or SQL Server Authentication login that is a member of the [font="Arial Black"]sysadmin [/font]fixed server role.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)