Re: Cannot view DB properties
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 15 Jan 2007 23:15:45 +0000 (UTC)
IT (IT@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin
rights to view the DB properties and its failing with "Property Owner is
not available for Database '[DB_name]'. This property may not exist for
this object, or may not be retrievable due to insufficient access
rights. (Microsoft.SqlServer.Smo)"
I was able to view the properties of the same database using same domain
user when we were in SQL 2000.
How to solve this issue? Any input is appreciated..
How did you upgrade? Did you upgrade the server in place, to did you
reattach the database?
It sounds as the latter. The SID for the database user, does not seem to
match any login on the server. Use
ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
and if necessary, create a login for the domain user first.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: Two certificates sharing the same symmetric key
- Next by Date: Re: How do I script out all the permmisions granted to a database role
- Previous by thread: Re: Two certificates sharing the same symmetric key
- Next by thread: Re: Cannot view DB properties
- Index(es):
Relevant Pages
|
