Linked server access error RRS feed

  • Question

  • Hi everyone,

    I got a problem in terms of Linked server access. I have 2 SQL 2k5 instance: A and B. On instance B, i created a linked server to instance A. and for security config, I used "be made using this security context" with "sa" account and its password. However, today I mistakenly changed the password of 'sa', and the linked server no longer worked(cannot access instance A). I tried change the password in security panel in the linked server property with the new password, but got an error as below:

    "The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?"

    Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it.  (Microsoft SQL Server, Error: 18486)

    Can someone give some advice? Thank you very much.



    Friday, September 13, 2013 10:36 AM


All replies