change user's login for dbo user

From: molly (anonymous_at_discussions.microsoft.com)
Date: 11/20/03 

Date: Thu, 20 Nov 2003 12:40:21 -0800

Two of our SQL 2000 databases list the user dbo in the
Users container and have associated a Windows
authenticated account (\\domain\user) as the login for
dbo instead of a SQL server login. We have since renamed
this Windows account resulting in the dbo user having no
valid login. I am looking at the books online for
sp_change_users_login which I thought would fix issue,
but it indicates this sp cannot be used for dbo user. How
can I change the login for dbo without breaking the
database? Help!
thanks for your help!

Relevant Pages

  • 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)
  • Re: Cannot access table with windows authentication
    ... regarding windows aythentication, ... Firstly, it appears that one cannot login to pages on the web, via the login ... of the DBO. ... I created another account with the same rights and I secured ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot access table with windows authentication
    ... regarding windows aythentication, ... Firstly, it appears that one cannot login to pages on the web, via the login ... of the DBO. ... I created another account with the same rights and I secured ...
    (microsoft.public.sqlserver.security)
  • Re: Two DB Owners
    ... full permissions in all databases. ... Note that the user will still be known as the 'dbo' user as long as the ... I need to add the login 'BUILTIN\Administrators' ... > 'DYNGRP' and 'BFGROUP' roles of the Dynamics and DAVCatalog databases. ...
    (microsoft.public.sqlserver.security)
  • Re: How do I set the login name for a user?
    ... You are better to make a dbo roled account (database god?), although that is not my first recommendation for connections. ... name, key name, without login. ...
    (microsoft.public.dotnet.framework.adonet)