Post reply

Linked server login error

  • June 6, 2003 at 10:08 am

    #63304

    Hi, I just added a linked server and get the following error when I try to access the tables:

    Error 18452: Login failed for user 'sa'. Reason: not associated with a trusted SQL Server connection.

    What should I do?

  • June 6, 2003 at 10:51 am

    #460228

    Check you linked server security is configured to allow both SQL and Windows.

    Select the server go properties and click on the security tab

    Shas3

  • June 6, 2003 at 12:21 pm

    #460247

    Thanks for your help Shas!

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

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