SQL Prompt - Unable to show database objects

• 
  Thanks for your post.
  
  
  I guess it is a permissions issue.
  
  Can you kindly try following permissions for that database from this knowledgebase here ?
  
  
  Please let us know if this fixes the issue.

  Anu D September 03, 2009 10:57

  - 0 +
• 
  That support article says grant view server state as the only possible suggestion pertaining to SS2008, which is the system I'm getting this error on.
  
  But the error description is not the one I am encountering so I doubt it will work, but I'm willing to try it - one issue; I'm logging in as 'sa' - doesn't 'sa' have this permission by default?
  
  Just makes no sense.

  randyv September 03, 2009 11:10

  - 0 +
• 
  Thanks for your reply.
  
  I think you should try granting following rights:
  
  1. GRANT VIEW DEFINITION TO [{username}]
  
  2. GRANT VIEW SERVER STATE TO [{username}]
  
  Please let us know if that helped.

  Anu D September 03, 2009 11:19

  - 0 +
• 
  If the above solution doesn't work and still you are getting error than your SQL Server needs to be set accordingly.
  
  Can you try executing below query in context of MASTER database:
  
  exec sp_serveroption 'SERVER NAME', 'data access', 'true'
  
  Kindly let us know if this fixes the issue.

  Anu D September 03, 2009 11:37

  - 0 +
• 
  The sproc worked.

  randyv September 03, 2009 11:57

  - 0 +
• 
  Brilliant!!
  
  Thanks for the update.
  
  Can you kindly let us know which of the solution provided by us solved the issue?

  Anu D September 04, 2009 03:28

  - 0 +
• 
  I have had the same issue and this forum topic was of great help to me also - thanks guys!

  dsheerin June 11, 2010 07:42

  - 0 +
• 

  EXEC sp_ServerOption 'SERVER NAME', 'data access', 'true'
  

  This worked for me, thanks Anu!

  AndrewJacksonZA October 03, 2012 10:43

  - 0 +

Add comment

Please sign in to leave a comment.