Hello there,
I have sql 2005 server standard and a user database, I use mixed
windows and sql authentication.
Although I set the server\Administrator login as the owner/dbo of the
user database in SQL server management studio, I am still getting
errors while right clicking the database and accessing properties.
Error: Property owner is not available for database...This property
may not exist for this object, or may not be retrievable due to
insufficient access rights. What can I do? Thank you, T

Just for kicks, make sure your Management Studio and the SQL Server are at
the same service pack and CU level

--

Kevin3NF
SQL Server dude

You want fries with that?
http://kevin3nf.blogspot.com/

Blog posts for new DBAs:
http://kevin3nf.blogspot.com/search?q=sql+101

I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.

Twitter: Kevin3NF

"Tester" <calinguga (AT) netscape (DOT) net> wrote

"Tester" <calinguga (AT) netscape (DOT) net> wrote


If you do the same thing from another machine do you have the same issue?

John

Tester (calinguga (AT) netscape (DOT) net) writes:
And you are logged on to SQL Server with sysadmin permissions?

I would suggest that you do:

ALTER AUTHORIZATION ON DATABASE::userdb TO sa

and possibly back again.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hi there
Alter authorization on database::db to sa worked.
Thank you very much, T