Error when restoring object in Online Restore Wizard: "Failed to initialize reporter: Cannot open database <DBName> requested by the login. Login Failed" (4299172)

 When generating the comparison report during the online restore wizard the following error may occur:

"Failed to initialize reporter: Cannot open database "DB_NAME" requested by the login. The login failed." 

This error is caused by the user account that is running the Online Restore Wizard not having sufficient rights to the comparison SQL database.

Grant the user account that is running the Online Restore Wizard (typically the account logged into the server) db_owner rights to the RMAD comparison database.

1. Open SQL Server Management Studio and connect to the SQL server where the RMAD database is hosted
2. Expand Security
3. Right click Logins and select New Login
4. Click Search
5. Click Locations and change to your domain
6. If adding a group click Object Types and check Groups
7. Enter the name of the user or group and click Check Names
8. Click OK
9. Click User Mapping
10. Check the RMAD database (RecoveryManager-Reporting-<RMADServerName>)
11. Check db_owner in the bottom window and click OK