Re: Login exists in server and db, but doesn't exist???
From: Hradesh \(HS\) (hsharma_at_seanix.com)
Date: 12/29/03
- Previous message: Sherry: "Re: Login exists in server and db, but doesn't exist???"
- In reply to: Sherry: "Re: Login exists in server and db, but doesn't exist???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 29 Dec 2003 14:51:06 -0800
Gr8!!
I have issues with SQL Profiler.. its already in the News
Group titled "Failed to stat a new trace." If anybody can
help.
>-----Original Message-----
>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
>> >
>> >
>> >.
>> >
>
>
>.
>
- Previous message: Sherry: "Re: Login exists in server and db, but doesn't exist???"
- In reply to: Sherry: "Re: Login exists in server and db, but doesn't exist???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
