Post reply

insufficient access rights

  • 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....

  • 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.

  • November 28, 2007 at 1:57 pm

    #755130

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


    * Noel

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply