SQL Express fails to start: The specified resource name cannot be found in the image file

Created:

2016-11-16 12:56:43 UTC

Modified:

2017-08-16 18:28:20 UTC

0

Was this article helpful?


Have more questions?

Submit a request

SQL Express fails to start: The specified resource name cannot be found in the image file

Applicable to:

  • Plesk 11.x for Windows

Symptoms

Microsoft SQL Express server fails to start with error:

The specified resource name cannot be found in the image file. (Error code 1814) at Start service MSSQL$SQLEXPRESS
at (service::startStopService line 994)
at execute console command --service-control(vconsoleapp::start line 97)
at execute "C:\\Program Files (x86)\\Parallels\\Plesk\\/admin/bin/defpackagemng" --service-control "--service=MSSQL$SQLEXPRESS" "--action=start"(vconsoleapp::run line 107)
Execute file name: C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\defpackagemng.exe

At the same time the following error appears in the Event Viewer:

FCB::Open failed: Could not open file D:\\Program Files (x86)\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\model.mdf for file number 1.  OS error: 3(The system cannot find the path specified.).

Cause

Database files cannot be found in the configured location. For example drive was removed from the server.

Resolution

Restore database files in the configured location and then change their location through SQL Management Studio or configure new location through SQL Installation Center.

Have more questions? Submit a request
Please sign in to leave a comment.