Post reply

Linked servers

  • March 1, 2007 at 2:38 pm

    #67995

    Hi,

    I'm trying to setup Linked Servers as follows:

    Local Server:

    SQL Server Standard Edition, SP3

    Linked Server:

    SQL Server Standard Edition, SP1

    I receive "Error 18452: Login failed for user '(null)'. Not trusted .." error with the following:

    1. Logged in as sa within Local Login, Remote User under Security tab.

    2. Created 2 local accounts with same name and opted for "Impersonate".

    For both the servers

    1. Mixed Mode Security is enabled.

    2. Server Network Utility has Named Pipes and TCP/IP selected.

    Local Server has TCP/IP set under Client Network Utility.

    Linked Server has Named Pipes and TCP/IP set under Client Network Utility.

    Appreciate any help and thanks in advance.

  • March 1, 2007 at 4:16 pm

    #692732

    Right now, apply SP3a to the linked server. Now. There are lots of security issues with SP1 & 2 for SQL Server 2000. That might also solve your linked server issue.

    -SQLBill

  • March 2, 2007 at 9:28 am

    #692881

    Appreciate your help, will do so.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply