Re: SQL 2005 Express-Database does not have a valid owner?
- From: "news.sbcglobal.net" <groomeryNOSPAM@xxxxxxxxxxxxxxxxxxx>
- Date: Mon, 29 May 2006 17:00:18 GMT
Yes, I understand. This is what I wrote in my original post. Of course
I've replaced my actual domain name and user name for these posts but it is
coming up in all cases with my correct domain name and user name as the
database owner.
If you'll endulge a rant for a moment, I'm really disappointed in SQL Server
2005 Express so far. This is supposed to be a tool for novices to get their
feet wet with SQL Server and it is so bloody complex and counterintuitive
(at least when it comes to security) that I can't imagine anyone wanting to
use it after a few days of this. I've been working with Access since 1992
and I've never had as many problems as I've encountered with SS2K5E. From
this security issue to the complexity of moving design databases to a hosted
environment, this product has cost me more time than any I've used in my
whole career.
Having said that, it does have it's good qualities. It's just hard to
appreciate them when faced with problems like this every day that don't seem
to have a sensible solution.
"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!
.
- 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
- Re: SQL 2005 Express-Database does not have a valid owner?
- From: Uri Dimant
- SQL 2005 Express-Database does not have a valid owner?
- Prev by Date: SQL Server (2005 or other) - Permissions on Views Excel Connection
- Next by Date: Re: SQL 2005 Express-Database does not have a valid owner?
- 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
|
