Red Gate forums :: View topic - SQL Prompt error connecting
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

SQL Prompt error connecting

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 25 Jul 2013
Posts: 1

PostPosted: Thu Jul 25, 2013 11:34 am    Post subject: SQL Prompt error connecting Reply with quote

I cant use sql promp as it keeps giving error "SQL Prompt cannot retrieve objects from master"
Back to top
View user's profile Send private message
Anu Deshpande

Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Fri Jul 26, 2013 2:49 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group