1

Can anyone point me a direction to solve this issue?

Error: 18456, Severity: 14, State: 5.

Login failed for user 'Domain\Administrator'. Reason: Could not find a login matching the name provided. [CLIENT: ] Error: 18456, Severity: 14, State: 5. Login failed for user 'Domain\Administrator'. Reason: Could not find a login matching the name provided. [CLIENT: 10.0.0.244] Error: 18456, Severity: 14, State: 5. Login failed for user 'Domain\Administrator'. Reason: Could not find a login matching the name provided. [CLIENT: 10.0.0.244]

Improve this question

2 Answers 2

Reset to default
1

This could be because you were using the Domain\Administrator for the local domain and that account is not valid for the domain you are restoring to. you can either drop the user from the actual domain and backup the database or create user account in the environment where the database is restored to. Refer to the following post for more information

Login Failed for user

Restoring SCCM Site cannot connect to SQL database

Improve this answer
2

Try running SSMS on the server with 'Run As Admin' to check if you added builtin\administrators during install. If you cant find any user with enough rights then you have to add a login to the server and give it sysadmin rights.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.