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.).


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

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

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?
Azra LyndseyNerdAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sounds like E: might have been your CD drive, jump drive or virtual ISO drive during the install.
Azra LyndseyNerdAuthor Commented:
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.
Vitor MontalvãoMSSQL Senior EngineerCommented:
If it's a new installation you don't have nothing to lose so it's more easy to uninstall it and reinstall again. This time double check when it asks for the system databases path.
I agree that a reinstall would be easiest solution since new.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Azra LyndseyNerdAuthor Commented:
I will re-install, thanks guys
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.