Post reply

SQL Linked Server Query failed with “Login failed for user

  • December 16, 2009 at 12:05 am

    #1092827

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

    Thanks

  • December 16, 2009 at 1:30 am

    #1092847

    Are you using windows authentication?

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

    Regards,
    Raj

    http://Strictlysql.blogspot.com

  • December 16, 2009 at 10:02 am

    #1093168

    yes, but still give me error

  • December 18, 2009 at 7:37 am

    #1094018

    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.

  • December 18, 2009 at 7:56 am

    #1094038

    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