insufficient access rights

• srimkumarp

  Old Hand

  Points: 359

  More actions

  November 28, 2007 at 3:18 am

  #153982

  hi ,

  whn i try access database properties in sql server 2005 through sa,admin. Only one database is shows like that remaining works fine .It displays follwoing errors:-

  Property Owner is not available for Database '[EDS_Automation]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

  any 1 pls help me....

• telam

  SSC Journeyman

  Points: 95

  More actions

  November 28, 2007 at 6:16 am

  #754939

  First off, where is the database located? Is it in the default location for SQL 2005 (program files\Microsoft SQL Server\MSSQL\Data)?

  Second, if you do a properties on the db files (.mdf and .ldf) are they flagged as read only?

  Third, how are you accessing the database? An application, attaching/detaching.

  Fourth, what user are you using to 'connect' or 'use' the database? Is this user sa/sa equivalent?

  With the above information we can give you more guidance.

• noeld

  SSC Guru

  Points: 96590

  More actions

  November 28, 2007 at 1:57 pm

  #755130

  you may want to run sp_changedbowner 'sa' on that database.

  
  * Noel