Re: Security in Linked Servers
From: Terry (trohrer@autocontroltech.com)
Date: 10/16/02
- Next message: Nick P: "Trusted Connections - can someone quickly explain?"
- Previous message: DC: "SQL Server DTS permissions problem"
- In reply to: Russell Fields: "Re: Security in Linked Servers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Terry" <trohrer@autocontroltech.com> Date: Wed, 16 Oct 2002 08:00:59 -0700
I did both and nothing seems to work...Terry
>-----Original Message-----
>Terry,
>
>Have you followed the step in this topic in BOL:
>
>How to add a linked server login (Enterprise Manager)
>
>If so, did you enter a remote user and password or did
you turn on the
>impersonate check box?
>
>Russell Fields
>"Terry" <trohrer@autocontroltech.com> wrote in message
>news:307601c2747d$a1d59ba0$36ef2ecf@tkmsftngxa12...
>I consistantly get the Error 18456: Login Failed message
>when trying to link servers. I've tried it in different
>scenerios, including linking 2 servers on the same machine
>running under the same login with identical SQL security
>accounts/settings and still I get this message. I've
>tried setting up the security mapping in several different
>ways. I get the Error 18456 in the Enterprise Manager
>when I try to refresh the tables under the security then
>the linked sub-tree and when I try to SELECT from a table
>in the Linked Server. Any ideas.
>
>Thanks,
>Terry
>
>
>.
>
- Next message: Nick P: "Trusted Connections - can someone quickly explain?"
- Previous message: DC: "SQL Server DTS permissions problem"
- In reply to: Russell Fields: "Re: Security in Linked Servers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
