Avatar of Azra Lyndsey
Azra Lyndsey
Flag for United States of America asked on

Error: Could not open file with Microsoft SQL Server Express, file exists but path is wrong.

I just installed Microsoft SQL server Express on a Server 2012 box.  

The installation went OK as far as I could tell, I don't recall ever seeing any errors.  But when I try to start the SQL instances, I get a failure notice. In the Event Viewer I see the following two errors:

FCB::Open failed: Could not open file E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\model.mdf for file number 1.  OS error: 3(The system cannot find the path specified.).

and

FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'E:\sql12_main_t.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.

The paths cited, don't exist.  Never has.  E isn't even a drive on the box.  So I'm not sure how the installer managed to figure out that this is where these files ought to be.

So I need to change the path of these files, and I'm not sure how to do that.  I'm very noob at SQL.

I believe that the model file that I'm looking for can be found here:
Z:\Program Files\ESET Microsoft SQL Server\MSSQL12.ESETERASQLSER\MSSQL\Binn\Templates

Open in new window

or here:
Z:\Program Files\ESET Microsoft SQL Server\MSSQL12.ESETERASQLSER\MSSQL\Template Data[/quote]

I'm not entirely sure, but I think it's one of these two because they match the date of when I was working on this project last.

For the modellog.ldf file, I think one of these is the correct location:

[code]Z:\Program Files\ESET Microsoft SQL Server\MSSQL12.ESETERASQLSER\MSSQL\Binn\Templates 

Open in new window

or
Z:\FileServerStorage\Installers\SQL Server Express\SQLEXPRWT_x64_ENU\x64\Setup\sql_engine_core_inst_msi\PFiles\SqlServr\MSSQL.X\MSSQL\Binn\Template 

Open in new window

or
Z:\Program Files\ESET Microsoft SQL Server\MSSQL12.ESETERASQLSER\MSSQL\Template Data 

Open in new window


So I think this should be as simple as letting SQL know where the files it wants are.  But I'm not quite sure how to change that.  Would someone here hold my and and let me know what I ought to do here?
Microsoft SQL ServerDatabases

Avatar of undefined
Last Comment
Azra Lyndsey

8/22/2022 - Mon
SStory

Sounds like E: might have been your CD drive, jump drive or virtual ISO drive during the install.
Azra Lyndsey

ASKER
I don't think so, the installer was run from the installers folder from the Z drive.  I didn't use a jump drive or CD for this.  The CD drive is D on this system.
SOLUTION
Vitor Montalvão

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
SStory

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Azra Lyndsey

ASKER
I will re-install, thanks guys
Your help has saved me hundreds of hours of internet surfing.
fblack61