Database Creation failed: "Error Directory lookup for the file" (4300292)

While attempting to deploy Change Auditor Coordinator to create the database, the following error is displayed in the Coordinator logs:

Error Directory lookup for the file "F:\data\ChangeAuditor_20200731030504.mdf" failed with the operating system error 3(The system cannot find the path specified.).

CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

Creating the ChangeAuditor database...

Data File = "F:\data\ChangeAuditor_20200731030504.mdf"

Log File = "F:\log\ChangeAuditor_20200731030504_log.ldf"

Command = "CREATE DATABASE [ChangeAuditor] ON PRIMARY ( NAME = N'ChangeAuditor', FILENAME = 'F:\data\ChangeAuditor_20200731030504.mdf', MAXSIZE = UNLIMITED, FILEGROWTH = 10% ) LOG ON ( NAME = N'ChangeAuditor_log', FILENAME = 'F:\log\ChangeAuditor_20200731030504_log.ldf', MAXSIZE = UNLIMITED, FILEGROWTH = 10% )" on line 137 executing SQL: 

• This is due to a bad configuration in SQL Server itself
• The drive to which the database was assigned was incorrect

Solution

• Check with your SQL Team to make sure that the SQL Server drive configuration is accurate then reattempt the installation