SQL 2005 Express-Database does not have a valid owner?
- From: "news.sbcglobal.net" <groomeryNOSPAM@xxxxxxxxxxxxxxxxxxx>
- Date: Sun, 28 May 2006 22:00:59 GMT
I am having some difficulty creating database diagrams in SQL Server Express
2005.
My design machine is running Windows XP Pro. This machine is a member of a
Windows 2000 domain that I will call MYDOMAIN. I am logged on the design
machine as MYDOMAIN\MyUserAccount. This account has local administrator
rights on the design machine.
Having said all that, here's a description of my problem:
I have created a database (MyDatabase) and I would like to create a database
diagram. I have checked to make sure that MYDOMAIN\MyUserAccount is the
database owner. However, when I click on MyDatabase/Database Diagrams in
SQL Server Management Studio Express, I receive the following error message
(following a fairly lengthy wait):
---------------------------------
Database diagram support objects cannot be installed because this database
does not have a valid owner. To continue, first user the Files page of the
Database Properties dialog box or the ALTER AUTHORIZATION statement to set
the database owner to a valid login, then add the diagram support object.
---------------------------------
As I said, I have ensured that my user account is the database owner. I
have not run the ALTER AUTHORIZATION statement (because I don't yet know
what, if anything, this will do considering the fact that I am already
designated as database owner). Going further through the database
properties (under Permissions/View Server Permissions), I receive the
following error message:
---------------------------------
Cannot show requested dialog.
Additional Information:
Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\SQLManagerUi.dll' or one of its
dependencies. The system cannot find the file specified. (mscorlib)
---------------------------------
I don't know whether this error is related to the first, however it seemed
relevant to me in that it pertains to permissions.
Hopefully this is enough information to work with. I'd appreciate any help
you can offer to resolve this problem.
Thanks!
.
- Follow-Ups:
- Re: SQL 2005 Express-Database does not have a valid owner?
- From: Remus Rusanu [MSFT]
- Re: SQL 2005 Express-Database does not have a valid owner?
- From: Uri Dimant
- Re: SQL 2005 Express-Database does not have a valid owner?
- Prev by Date: Re: Need permission to use bulk load statement in SQL 2005?
- Next by Date: Re: SQL 2005 Express-Database does not have a valid owner?
- Previous by thread: Re: Need permission to use bulk load statement in SQL 2005?
- Next by thread: Re: SQL 2005 Express-Database does not have a valid owner?
- Index(es):
Relevant Pages
|
