Re: Who is Who ??

serge,

Look at database security and see who is mapped to the dbo internally to the
database. It may be that the internal dbo login is not "sa" but something
else. This is common in restores from other installations.

If that is the case, master database believes that "sa" is the owner and the
database believes that "somebodyelse" is the owner. Use sp_changedbowner to
set the database owner. (If you are on an older release, you might have to
set the owner to "another" account, then back to "sa".)

RLF
"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF72A3E2-BFE7-4CED-A71C-ECC64881EB06@xxxxxxxxxxxxxxxx

Thnaks for your reply russel,

I run the system store procedure sys.help_db and the owner for the
database
I am interresting on is set to "sa".

Yes I have restore that database from a previous customer as I am going to
use exactly teh same for an other.

Do I have to change anything in order to get something clean ?

thnaks for help
regards
serge

"Russell Fields" wrote:

Serge,

If you run sp_helpdb, who does it say owns the database? Is it an
unexpected owner, such as can happen when a different account restores a
database?

RLF

"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8DBC4605-D2A2-4B00-9DE9-5C56BC229473@xxxxxxxxxxxxxxxx
Dear all,

I have setup database on my SQL server 2005.
I am accessing to that database with a connection string using a single
account named rptUser with SQL authentication.

My SQL server has been configured for mix mode.
Once my databse has been created I ma able to remotely access it and
store
data without any trouble.

It means that I have define a login user rpUser for my server and then
defined proper rights on tables.

Then I am lgged in on my OS server as administrator user.
I have noticed that if I try to enter the Design diagram I get a
messaying
saying that I am not able to perform this opetration becasue teh
database
has
an invalid owner ??

Then if I check about the effective permission of my rptUSer, it has
the
ownser flag ??

What to chek then or what to do to be able to enter this design
diagram.
I have only this rptUser define for my database and SQL login in
addintion
to the "sa"

thnaks for help
regards
serge





.

Relevant Pages

  • Re: Accidentally dropped DBO from database
    ... That error is due to having databases where the owner (dbo) ... is mapped to a login that doesn't exist on the server. ... a user in the database" when using sp_changedbowner, ...
    (microsoft.public.sqlserver.security)
  • Re: Confused about dbo
    ... Make sure you understand the difference between login names and user names. ... database within a SQL Server instance. ... There are several ways you could have the username dbo. ... the true owner of the database. ...
    (microsoft.public.sqlserver.security)
  • Re: not creating tables as dbo anymore ?
    ... Database Owner (dbo) ... existing user ID in the database specified by database_name. ... with the login of the current connection. ...
    (microsoft.public.sqlserver.security)
  • Re: dbo with user name in "users"
    ... be that one of them owned the database and because the login/user has been ... has something to do with not being able to validate the login. ... changing the owner to sa is usually a great ... for dbo, I get an error: "cannot insert the value NULL into column '', ...
    (microsoft.public.sqlserver.security)
  • Re: properties owner and users owner.
    ... 'dbo' is a special database user and must exist in every database. ... normally be the same login but can get out-of-sync in some situations, ... owner entries are synchronized: ...
    (microsoft.public.sqlserver.server)