Re: SQL 2005 Express-Database does not have a valid owner?
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Mon, 29 May 2006 11:19:38 +0300
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!
.
- 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?
- 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
- 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?
- From: news.sbcglobal.net
- SQL 2005 Express-Database does not have a valid owner?
- Prev by Date: Re: SQL 2005 Express-Database does not have a valid owner?
- Next by Date: SQL Server (2005 or other) - Permissions on Views Excel Connection
- Previous by thread: Re: 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
|
