Error message when deploying the Management Reporter services: "The Database to be configured is NOT a valid MS Dynamics SL Application Database"

While configuring the Management Reporter services you receive the follow message: Dynamics SL system Database connection information: The Database to be configured is NOT a valid MS Dynamics SL Application Database

This message is generated when a record exists the domain table in the SL system database for a database that is no longer on the SQL server.

To correct this error, execute the following SQL query against the SL System database:

Select Distinct Databasename from domain where databasename > '' and RecordType = 1

In the results, check the database names listed and compare them against the databases in SQL Management Studio.  If an application database name is listed in the domain table that does not exist in SQL, you will receive this error message.  You can remove the application database name from the domain table by executing a SQL statement like this:

delete domain where DatabaseName = 'ABC'

Note: Replace ‘ABC’ with the name of the missing application database.