During installation you see the following error on screen:
"Failed to connect to SQL database (-2147467259 BackupCatalog-<Server_Name>)"
When you click OK the installation rolls back.
The user is unable to reach the database due to corruption or permission in SQL Express 2008
By Default, the installer installs SQL Express 2008 and creates a new instance named QUESTRMEX. If the instance and databases already exist it will attempt to use them, however if the currently logged in account does not have permission to the databases the install will fail.
RESOLUTION 1
1. Grant db_owner and public to the three databases:
- BackupCatalog-<RME_Servername>
- RME-EdbInformation-<RME_Servername>
- RME-Storages-<RME_Servername>
RESOLUTION 2
1. Install SQL 2008 Management Studio Express (or later version) and connect to the QUESTRMEX (or DELLRME if it was installed more recently) instance and delete the databases and allow the installer to create new ones
RESOLUTION 3
If unable to delete, modify the security or the SQL instance there may be an issue with the owner of the system databases or corruption.
1. Download SQL Express 2008 and create a new instance with a different name.
E.g QUESTRMEX2
2. During the installation of Recovery Manager for Exchange choose Custom install and specify the QUESTRMEX2 instance so that the Recovery Manager for Exchange installer will create the databases on the new instance and grant the required permissions.
