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]

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

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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