Re: SQL 2005 Express-Database does not have a valid owner?
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Mon, 29 May 2006 07:56:02 +0300
What does it return?
select owner_sid,SYSTEM_USER from sys.databases
where owner_sid=SUSER_SID ()
"news.sbcglobal.net" <groomeryNOSPAM@xxxxxxxxxxxxxxxxxxx> wrote in message
news:v4peg.35775$4L1.22992@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: news.sbcglobal.net
- Re: SQL 2005 Express-Database does not have a valid owner?
- References:
- SQL 2005 Express-Database does not have a valid owner?
- From: news.sbcglobal.net
- SQL 2005 Express-Database does not have a valid owner?
- Prev by Date: SQL 2005 Express-Database does not have a valid owner?
- Next by Date: Re: SQL 2005 Express-Database does not have a valid owner?
- Previous by thread: SQL 2005 Express-Database does not have a valid owner?
- Next by thread: Re: SQL 2005 Express-Database does not have a valid owner?
- Index(es):
Relevant Pages
|
