Re: New DBs DBO does not have an associated login name

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: KJ (armchairqb2000!_at_hotmail.com)
Date: 02/09/04 

Date: Mon, 9 Feb 2004 08:06:11 -0600

When I run the stored proceedure I get the NT username that I was logged in
to when I created the DB. But under Enterprise Manager when I drill down to
the DB and select users the DBO has no associated logon. Under SQL 7 when I
created a new DB it would show the DBO in that location.

"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:##xb8Bf7DHA.3880@tk2msftngp13.phx.gbl...
> Hi KJ
>
> How are you determining that there is no associated login name? What do
you
> get when you run
>
> exec sp_helpdb <name of database>
>
> --
> HTH
> ----------------
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
>
> "KJ" <armchairqb2000!@hotmail.com> wrote in message
> news:#V3Y2fb7DHA.2480@TK2MSFTNGP12.phx.gbl...
> > When I create a new DB on a new SQL 2000 server I have it adds the DBO
but
> > does not have an associated login name. How do I fix this?
> >
> > Thanks,
> >
> > KJ
> >
> >
>
>

Relevant Pages

  • Re: Cannot delete SQL user (dbowner)
    ... Or are you trying to delete a login. ... Every database has a user named dbo and that can never change. ... SQL Server MVP ... "Carlton Whitmore" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: default dbo to object names instead of user name
    ... Only one login can be the dbo user. ... there's no GUI support for this. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • dropped users still show up in public role
    ... development, not production). ... Using the Enterprise Manager I deleted ... all logins and users (except dbo and sa, of course), but they still ... Now if I try to create a new login with the same ...
    (microsoft.public.sqlserver.security)
  • Error 21776: after transferring databases
    ... I transferred databases from SSSrvr to FRXSrvr. ... I now want to link the 'DBO' in the databases to the login ... DBO by correcting the SID. ... listed in the Users folder in Enterprise Manager. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... Try not to say "If sa is THE dbo", it's like saying "If I am the joe". ... might help to either say "If sa is the database owner" or, ... The login 'sa' could be listed in sysdatabases as the database ... FULL permission to do anything and everything. ...
    (microsoft.public.sqlserver.programming)