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

Leader_SDC

SQL prompt is disabled for normal user and working fine for admin user.

Jessica R

Hello,

Is this happening with SSMS or Visual Studio?

Leader_SDC

It is in SSMS

Jessica R

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?

Leader_SDC

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

Jessica R

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?

Leader_SDC

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.

Jessica R

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?