When attempting to access a database in the Enterprise Console to restore a database, the following message appears:
"failed to login to sql server"
login permissions or password may have been changed.
Right-click on the instance name in the Enterprise Console and select Edit Server Properties.
Enter the current Login Name: and Password: and click OK.
Then try to access the instance in the Enterprise Console.
If this does not work, please try removing the instance from the Enterprise Console and then add it back in.