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

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,
SherryThanks. 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...[QUOTE]
> Try sp_dropuser or sp_droprole in that particular database
> and readd it after dropping the user.
> Login account that
> Users node I get
> database.
> the Login through
> already exists
> User's node I get this
> database.
> need and I can't
> in. I have tried
> run it on my
> exist on my
> computer has the
> must be some script
> spending 4 hours searching
> haven't been able to fix|||Gr8!!
I have issues with SQL Profiler.. its already in the News
Group titled "Failed to stat a new trace." If anybody can
help.

quote:

---

>--Original Message--
>Thanks. That was just too simple. I was looking for a

---

complicated fix.

quote:

---

>Just goes to show, sometimes you can overthink things.

---

Works now. Thanks

quote:

---

>again!
>Sherry
>"HS" <anonymous@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:084a01c3ce4f$1f3ee660$a001280a@.phx.gbl...
database[QUOTE]
DB[QUOTE]
selecting[QUOTE]
subscription[QUOTE]
back[QUOTE]
not[QUOTE]
my[QUOTE]
>
>.
>

---