locked
error while making the linked server RRS feed

  • Question

  • Hello friends

    I am trying to make a linked server between the two sql servers and i am getting this error.

    error:

    Login failed: The login is from the untrusted domain and can not be used with windows authentication.

    Thanks


    dimrd_SQL
    Thursday, December 30, 2010 4:03 PM

Answers

  • Can you connect to the linked server destination server using the account you have specified in the linked server config.? Are you using a windows account and connecting to a SQL server instance in a different domain? Try connecting manually using the account configured for the linked server (with the same domain as well) and make sure that is working first.

    If the problem is that there is no trust between the domains you may need to either move the source server so they are in the same domain, setup trust between the domains or use SQL Server accounts.

     

    Thanks


    /Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005), MCAD, OCA 11g) Please click the Mark as Answer button if a post solves your problem
    Friday, December 31, 2010 6:47 AM
  • See if the below helps you

    http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, January 2, 2011 8:20 AM

All replies