SQL Linked Server Query failed with “Login failed for user

  • Try to add the server in SQL client network utility. Keep an entry for the server in C:\WINNT\system32\drivers\etc\hosts

    Thanks

  • Are you using windows authentication?

    Then can you check for SPN/Delegation settings are done correctly?

  • yes, but still give me error

  • You may add your own login to map from A to B server in the linked server you created on A, when you login. In the linked server option, choose the server type - SQL Server.

  • MAK-1128556 (12/14/2009)


    SQL Linked Server Query failed with “Login failed for user , I try every thing, but still no luck.

    I try different user still logon failed.

    I can get the data from B to A server but not from A to B server

    Is linked server configured with Windows authentication or SQL Authentication?

Viewing 5 posts - 16 through 19 (of 19 total)

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