I recently did 4 installs of SQL Server 2014 on two different servers. When I checked the services I saw that on SQL Server did not start. This is the error in the log:
2017-02-14 14:30:00.11 spid12s FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL12.ABC\MSSQL\Binn\mssqlsystemresource.mdf for file number 1. OS error: 2(The system cannot find the file specified.).
2017-02-14 14:30:00.11 spid12s Error: 5120, Severity: 16, State: 101.
2017-02-14 14:30:00.11 spid12s Unable to open the physical file “C:\Program Files\Microsoft SQL Server\MSSQL12.ABC\MSSQL\Binn\mssqlsystemresource.mdf”. Operating system error 2: “2(The system cannot find the file specified.)”.
2017-02-14 14:30:00.11 spid12s Error: 17207, Severity: 16, State: 1.
The fix was simple, I copied the files from the other instance on the system and everything started up. I have run into this before with other versions of SQL Server. I have access to a lot of other systems so I can find them on other computers and copy them over.
MySQLJourney 