I set up a linked server and had a user account that could log into both databases. It was all working perfectly until I changed the password of both user accounts to a new password.
I am still able to log into each database with Management Studio using this login, but when I try to access one from the other using a statement like this:
SELECT * FROM LinkedServer.DatabaseName.dbo.[TableName]
I get:
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'xxx'.
I have tried deleting and recreating the login but this didn't help.