Post reply

Linked Server: Trusted SQL server Error

  • March 6, 2014 at 5:56 am

    #290559

    I have two database one is SQL2008 (on Windows 2003 server) and SQL2000 (on Windows 2000 Server). I want to link SQL2000 in SQL2008. Both the servers are in Mixed Security Mode.

    But when i Create a Linked Server it always show me an error

    "Login Failed for User 'sa'. Reason:Not associated with a trusted SQL server Connection.

    Microsoft Sql server Error: 18452"

    I created the linked server with server type: SQL Server and the Security is "Be made using with this security context" and pass my login ID and Password.

    Please help me out

    Thanks

  • March 6, 2014 at 6:39 am

    #1694687

    did you check status of SA user on linked server?

  • March 6, 2014 at 6:57 am

    #1694698

    I use linked servers a lot and I would generally advise against using an SA account for a linked server. Just a little too dangerous in my opinion. Have you tried creating a special sql account for the linked server and then giving it the rights it needs? Also, I have seen this error sometimes on machines that are not on the same network or that you're putting in the wrong password for the account. Sometimes the errors aren't exactly what they say they are for. 🙂 Hope that helps.

  • March 7, 2014 at 12:01 am

    #1694979

    What status should i check of SA at linked server. Please let me know Thanks..

  • March 7, 2014 at 4:31 am

    #1695055

    If its enabled...verify you have the right password...still strongly recommend against using the sa account. 🙂

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

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