What are the challenges you face when working across database platforms? Take the survey
Options

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

Leader_SDCLeader_SDC Posts: 4
edited May 17, 2017 5:43AM in SQL Prompt
SQL prompt is disabled for normal user and working fine for admin user.
Tagged:

Comments

  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    Hello,

    Is this happening with SSMS or Visual Studio?

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • Options
    It is in SSMS
  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    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 Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • Options
    SSMS version - 2012
    Menu is there but grayed out. Please find the attachment
  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    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 Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


  • Options
    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.
  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    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 Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.