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

From: Sherry (sherry.matthews_at_creo.com)
Date: 12/29/03 

Date: Mon, 29 Dec 2003 13:33:29 -0800

Thanks. That was just too simple. I was looking for a complicated fix.
Just goes to show, sometimes you can overthink things. Works now. Thanks
again!

Sherry

"HS" <anonymous@discussions.microsoft.com> wrote in message
news:084a01c3ce4f$1f3ee660$a001280a@phx.gbl...
> 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

  • Login exists in server and db, but doesnt exist???
    ... When trying to add DBO permission to the Login in the DB Users node I get ... User or role '%s' does not exist in this database. ... When trying to add DBO permission to the DB by selecting the Login through ... Microsoft KB and trying several different things I haven't been able to fix ...
    (microsoft.public.sqlserver.security)
  • Login exists in server and db, but doesnt exist???
    ... Try sp_dropuser or sp_droprole in that particular database ... >When trying to add DBO permission to the Login in the DB ... >that will allow me to fix this problem, ...
    (microsoft.public.sqlserver.security)
  • Re: can not open user default database?!
    ... Try specifying the desired default database for the login ... >> cause this and how do you fix it? ...
    (microsoft.public.sqlserver.programming)
  • Re: Renaming control breaks module ?
    ... This seems like the kind of problem that a decompile might fix. ... Office Button | Access Options | Current Database | Name AutoCorrect ... Compact the database to get rid of this junk: ... Uncheck any references you do not need. ...
    (microsoft.public.access.formscoding)
  • Re: Tale of debugging and programming logic in c#/sql
    ... > and I pushed it to production. ... I was anxious to find a fix, ... The login page does ... > user authenticates or creates a new login name -- it is based on an ID ...
    (microsoft.public.dotnet.languages.csharp)