Login exists in server and db, but doesn't exist???

From: HS (anonymous_at_discussions.microsoft.com)
Date: 12/29/03 

Date: Mon, 29 Dec 2003 13:02:51 -0800

Try sp_dropuser or sp_droprole in that particular database
and readd it after dropping the user.
>-----Original Message-----
>I have restored a db onto a server, which has the same
Login account that
>exists in the db.
>
>When trying to add DBO permission to the Login in the DB
Users node I get
>this error.
>Error 15410: User or role '%s' does not exist in this
database.
>
>When trying to add DBO permission to the DB by selecting
the Login through
>security I get this error.
>Error 21002: The Distribution Agent for this subscription
already exists
>(%s).
>
>When I try to remove user from Database through the
User's node I get this
>error:
>Error 15008: User '%s' does not exist in the current
database.
>
>So now I can't add the dbo permission to the user as we
need and I can't
>remove the invalid User from the db and then add it back
in. I have tried
>installing the Sync SQL Logins.exe utility, but I can't
run it on my
>computer. It is looking for mscoree.dll, which does not
exist on my
>computer. I have run the windows update to make sure my
computer has the
>latest stuff on it, but it didn't help. I know there
must be some script
>that will allow me to fix this problem, but after
spending 4 hours searching
>Microsoft KB and trying several different things I
haven't been able to fix
>it yet. Is there anyone who can help me with this?
>
>Thanks,
>Sherry
>
>
>.
>

Relevant Pages

  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Enter user name, enter password, then press enter...
    ... What do you do when the customer asks that the database login in be the same ... username and password to use all of the stuff that she is permitted to use. ... I have implemented this type of security for Access, VB, and Web Based ASP ...
    (microsoft.public.access.forms)