Results 1 to 2 of 2

Thread: linked servers

  1. #1
    janet Guest

    linked servers


    I am wanting to set up linked servers between servers that have NT only security but when I try and run an RPC or Query I get the following error

    Login failed for user ''.

    I am using named pipes, tcpip, and multiprotocol librarys on both servers
    I have been able to get this working when using standard security but not for NT only.

    Thanks
    janet

  2. #2
    Ray Miao Guest

    linked servers (reply)

    You have to map nt id to remote sql id.

    ------------
    janet at 4/18/00 11:33:59 PM


    I am wanting to set up linked servers between servers that have NT only security but when I try and run an RPC or Query I get the following error

    Login failed for user ''.

    I am using named pipes, tcpip, and multiprotocol librarys on both servers
    I have been able to get this working when using standard security but not for NT only.

    Thanks
    janet

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •