Re: linked server login problem... with a particular login... on a particular box
From: ChrisR (bla_at_noemail.com)
Date: 02/15/05
- Next message: Mike Epprecht \(SQL MVP\): "Re: Criteria has "/" embedded on the text"
- Previous message: Mike W: "Re: trigger to update count field - Request for criticism"
- In reply to: ChrisR: "linked server login problem... with a particular login... on a particular box"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 13:57:32 -0800
I think its related to this issue but Im not sure.
http://support.microsoft.com/default.aspx?scid=kb;en-us;238477
I don't really need a fix for this anyomore as I've found a workaround and
only needed this temporarily. More info: I had opened Query Analyzer under
the failing account on my local box... RClick/ Run as. But if I log directly
onto the box I was trying to run the query from it works fine. Which is why
Im thinking its related to the above article.
"ChrisR" <bla@noemail.com> wrote in message
news:#uUSqB4EFHA.2608@TK2MSFTNGP10.phx.gbl...
> Im having a problem with one particular Linked Server Login. I've created
> two of them. Neither of which has an existing Login on the Linked Server
and
> both of which are mapped to a member of SA. In the below examply, Login1
> will work, but Login2 will fail with:
>
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
>
> sp_addlinkedsrvlogin @rmtsrvname = 'server2'
> , @useself = 'false'
> , @locallogin = 'domain\Login1'
> , @rmtuser = 'RmtLogin1'
> , @rmtpassword = 'password'
>
> sp_addlinkedsrvlogin @rmtsrvname = 'server2'
> , @useself = 'false'
> , @locallogin = 'domain\Login2'
> , @rmtuser = 'RmtLogin1'
> , @rmtpassword = 'password'
>
> Again, please keep in mind that the Login on the Linked Server is in the
SA
> role, and that the top Login works. Another important tip, both of these
> work successfully on another box, just not the one that counts.
>
> All ideas are greatly appreciated as Im quite desperate.
>
> --
> SQL2K SP3
>
> TIA, ChrisR
>
>
- Next message: Mike Epprecht \(SQL MVP\): "Re: Criteria has "/" embedded on the text"
- Previous message: Mike W: "Re: trigger to update count field - Request for criticism"
- In reply to: ChrisR: "linked server login problem... with a particular login... on a particular box"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
