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