Re: SQL 2005 Express-Database does not have a valid owner?

I digressed into a rant in my last reply to this post...so I thought I'd try
again - and this time try to stay on topic.

As I mentioned in my first post, I am the database owner and this most
recent test confirmed that. So, if I am the database owner, why can't I
create database diagrams? When I try, I get the error message I mentioned
in my first post.

Has anyone else encountered this problem and solved it. I have to admit I'm
at a loss and unable to continue until I figure this out.

Thanks!

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:%23b4CAivgGHA.3996@xxxxxxxxxxxxxxxxxxxxxxx
Are youe in as MYDOMAIN\MyUserName?

That means that the database's owner is MYDOMAIN\MyUserName

"news.sbcglobal.net" <groomeryNOSPAM@xxxxxxxxxxxxxxxxxxx> wrote in message
news:tOveg.97355$F_3.868@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
owner_sid=0x010500000000000515000000FD77B15607E9942DF89FB47458040000
[No Column Name]=MYDOMAIN\MyUserName

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:eIRrOwtgGHA.1320@xxxxxxxxxxxxxxxxxxxxxxx
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!













.

Relevant Pages

  • Re: Will anyone know this?
    ... You can determine if your login is the database owner with sp_helpdb. ... The only required user in a SQL Server database is dbo and this special ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 Express-Database does not have a valid owner?
    ... My design machine is running Windows XP Pro. ... database diagram. ... Database diagram support objects cannot be installed because this database ... set the database owner to a valid login, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 Express-Database does not have a valid owner?
    ... My design machine is running Windows XP Pro. ... database diagram. ... MYDOMAIN\MyUserAccount is the database owner. ... Database diagram support objects cannot be installed because this ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 Express-Database does not have a valid owner?
    ... database owner. ... My design machine is running Windows XP Pro. ... MYDOMAIN\MyUserAccount is the database owner. ... Database diagram support objects cannot be installed because this ...
    (microsoft.public.sqlserver.security)
  • SQL 2005 Express-Database does not have a valid owner?
    ... I am having some difficulty creating database diagrams in SQL Server Express ... My design machine is running Windows XP Pro. ... Database diagram support objects cannot be installed because this database ... the database owner to a valid login, then add the diagram support object. ...
    (microsoft.public.sqlserver.security)