Missing mssqlsystemresource files – SQL Server 2014

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.

 

Problems with installing SQL Server 2016, 2nd instance

Today I had a request to install two instances of SQL Server 2016 on a VM.  I have done this many times with other versions of SQL Servers and it is a very routine thing.  The First instance installed without a hitch and was successful.  So I started to install the second instance and it came up and said that I had to reboot.  While it is did not say to reboot after the install, this is not unusual.  So I rebooted the server and started my install again.  I got this error:

image1

C:\program Files\Microsoft SQL Server\130\Setup Bootstrap\SQLServer2016\resources\1033\setup.rll is either not designed to run on Windows or it contains an error.  Try installing the program again using the original installation media or contact your system administrator or the software vendor for support.  Error status 0xc000012f.

What the heck, I just installed SQL Server from this same media.  After doing some searches on the web I tried to replace the setup.rll but without success.  So I decided to remove the setup.rll file with the idea that the install should replace that file.  I got this error:

image2

The English-language version of SQL Server is not supported by this SQL Server media.  Use the matching language-specific SQL Server media; or install the language specific MUI, and change the format and system locales through the regional settings in the control panel. 

Once again, I just installed with this media.  I checked my region and language settings and they looked right so I decided to apply SQL Server 2016 SP1 to the instance that I had already installed.  That went without any issue.  Once that completed, I started the install for the 2nd instance and it worked flawlessly.  Just thought I would post what worked for me, YMMV.  Good luck, be safe out there.