SQL Prompt error connecting

Provides intelligent code completion for SQL Server editors.

SQL Prompt error connecting

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

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

Postby Anu Deshpande » Fri Jul 26, 2013 1: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: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests