During the MDB installation, the following error is encountered during the setup. This error message could have multiple possible causes; this document will define one of the causes (NOTE: This is a fairly generic error and can have many causes. This doc outlines one such cause. It should not be considered the only possible one):
Inside the setup log tab, the following text is observed:
Upon further analysis, the %temp%\ITRM\database\mdb_install\install_mdb.log reveals the following error.
The text of the error reads:
Msg 5170, Level 16, State 1, Server FONBR01-U116380, Line 1Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mdb.mdf' because it already exists. Change the file path or the file name, and retry the operation.Msg 1802, Level 16, State 4, Server FONBR01-U116380, Line 1CREATE DATABASE failed. Some file names listed could not be created. Check related errors.05-08,12:21:50 Failed to create the database (errorlevel=1) 05-08,12:21:50 Setupmdb_pre exit /B return code=400 05-08,12:21:52 Pre-process failed (errorlevel=400) 05-08,12:21:52 Setupmdb exit return code=110
No 'mdb' database is seen in SQL Management Studio, but the DATA folder inside the database instance for the SQL server shows a prior MDB that exists, but is detached from the database server: