Return
-
Title
RESTORE: error "failed to login to sql server" -
Description
When attempting to access a database in the Enterprise Console to restore a database, the following message appears:
"failed to login to sql server" -
Cause
login permissions or password may have been changed.
-
Resolution
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.