SQL Prompt error connecting

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

SQL Prompt error connecting

Postby Henny » Thu Jul 25, 2013 11:34 am

I cant use sql promp as it keeps giving error "SQL Prompt cannot retrieve objects from master"
Henny
 
Posts: 1
Joined: Thu Jul 25, 2013 11:28 am

Postby Anu Deshpande » Fri Jul 26, 2013 2:49 pm

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests