Post reply

Login Failed error (Linked server)

  • May 8, 2013 at 4:39 am

    #277242

    I am trying to access data through linked server by following query

    select * from [Servername].dbname.schema.view_name

    and my schema is not dbo.

    When I tried this with sa login it is giving me correct output,

    but when I tried to access data through login from which linked server is configured it is giving me login failed for user error.

    I have already maped database to login with it default schema.

    please help me out....

  • May 8, 2013 at 7:19 am

    #1613322

    SQL Addict (5/8/2013)

    but when I tried to access data through login from which linked server is configured it is giving me login failed for user error.

    This login has created in linked server or this login has been "impersonated" ?

  • May 9, 2013 at 6:32 am

    #1613757

    This is sql server login .

    I have used it for configuring linked server.

  • May 9, 2013 at 7:56 am

    #1613796

    Can you connect to the linked server using the userid and password.

    i hope that is password issue.

    Regards
    Durai Nagarajan

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

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