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

SQL Prompt error connecting

HennyHenny Posts: 2
edited July 26, 2013 9:49AM in SQL Prompt Previous Versions
I cant use sql promp as it keeps giving error "SQL Prompt cannot retrieve objects from master"


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post and apologies for error you got.

    This looks like a permission issue to me.

    The following account permissions are required by SQL Prompt:
    For SQL Server 7 or SQL Server 2000, SQL Prompt requires administrative or dbo or Sys Admin permissions.
    For SQL Server 2005 you can use the same permissions as for SQL Server 7/2000 or alternatively you can use the GRANT VIEW DEFINITION TO [{username}] which provides SQL Prompt with permission to retrieve the metadata without giving dbo access.
    For SQL Server 2008 and SQL Server 2012, it may be necessary to grant VIEW SERVER STATE to access information about encryption keys otherwise a 'User does not have permission to perform this action' message may prevent the display of candidates.

    Can you make sure you have the required permission?

    Please let me know if the error persists.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.