SQL prompt disabled for normal user (for admin user working fine)

• 
  Hello,
  
  Is this happening with SSMS or Visual Studio?

  Jessica R May 19, 2017 00:19

  - 0 +
• 
  It is in SSMS

  Leader_SDC May 22, 2017 06:38

  - 0 +
• 
  Thanks for confirming that @Leader_SDC!
  
  Can I please check--what version of SSMS are you using?
  
  When non-admins run SSMS, is the SQL Prompt menu there but grayed out, or is the menu completely missing?

  Jessica R May 23, 2017 21:42

  - 0 +
• 
  SSMS version - 2012
  Menu is there but grayed out. Please find the attachment

  Leader_SDC May 24, 2017 07:19

  - 0 +
• 
  Ah it looks like SQL Prompt may not be activated - if the user goes to SQL Prompt 5>Serial Number and activates, does that enable the menu?

  Jessica R May 24, 2017 16:45

  - 0 +
• 
  For normal user there is a restriction for activating the license and which gives access denied message. So installed using admin user. When run SSMS as administrator sql prompt works fine. Is there any way i can give permission for the normal user to sql prompt.

  Leader_SDC May 25, 2017 05:24

  - 0 +
• 
  Thanks for those details!
  
  I can't guarantee this as it may be complicated, but if giving them admin access is not possible, you may be able to get past this by granting them access to the individual registry keys and folders they need to query--would that be possible to give a try?

  Jessica R May 26, 2017 00:35

  - 0 +

Add comment

Please sign in to leave a comment.