Error on QMM Startup "Error during check connect to database or update version database" (4264244)

QMM starts up and the error occurs "Error during check connect to database or update version database". After clicking OK, everything works fine. SQL Express has been installed on a remote machine and the accounts have necessary rights over SQL database.

This can be caused by SQL Express not allowing remote logins.

RESOLUTION 1

See http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277 on how to enable remote logins for SQL Express. SQL Server Browser service should be running.

RESOLUTION 2

If not using SQL Express and the above resolution does not apply, then it's possible to upgrade the SQL database manually. This error will usually occur after installing an update to QMM and opening the QMM console the first time afterwards. After installing an update, the backend SQL database gets updated after opening the QMM console. This is why it may take longer to launch console the first time after any update is installed.

During this DB updating process, if there is an issue connecting to SQL to update the database then it's possible to update the database manually by performing the following:

1. Open \Program Files (x86)\Quest Software\Migration Manager\Exchange Data\DB\ folder on the console machine.

2. Open UpdateDB.sql file with a text editor, copy its contents into the clipboard

3. Run the above copied query in SQL Studio as a query over the MMEX SQL database. Running the query may take awhile.

4. Then open the QMM console to ensure the errors don't reoccur. 

This is for the startup error where clicking OK allows to continue working. The error with the same text during Open Project Wizard could also mean lack of rights on the SQL server or databases.