Sql Server Installation can't find files

Question

Okay, I wasn't sure whether to ask this here or on Server Fault, but the FAQ for DBA says it includes db configuration, so I'm going with here.

I'm installing Sql Server Express 2012 on a clean Windows Server 2012 box.

The install seems to go fine right up till the very end.

I left the program install directory at C:\Program Files....
I changed the instance root directory to D:\SQLE2012ROOT\.

Install chugs along happily, and when it ends, it says setup completed, but encountered the following error:

Feature:              Database Engine Services
Status:               Failed: see logs for details
Reason for failure:   An error occurred during the setup process of the feature.
Next Step:            Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name:       SQL Server Database Engine Services Instance Features
Component error code: 0x851A001A
Error description:    Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

(it also gives a URL to go to, but clicking it just takes you to a Microsoft home page that shows consumer products to buy, like Surface and XBox. Thanks MS!)

The SQL service in Service Manager is stopped, and if you try to start it, chokes with message about service-specific error code 945, which googling, says it means Sql Server cannot find the necessary files.

Looking in the Event Logs after trying to start the service shows these two errors (each shows twice, once for MSDBData.mdf and once for model.mdf):

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

and

FCB::Open failed: Could not open file e:\sql11_main_t.obj.x86release\sql\mkmastr\databases\objfre\i386\MSDBData.mdf for file number 1. OS error: 21 (The device is not ready.).

It would make sense that it cannot find those files, as the E: is an optical drive on the server, with no media mounted in it.

The million dollar question though is WHY it is looking for the files in that location? I've checked, and the setup DID actually create the files in the correct location under my specified instance root (D:\SQLE2012ROOT\MSSQL11.SQLE2012\MSSQL\DATA). But for some unknown reason, Sql Server is LOOKING for them under what looks like a development project build directory off the E: drive.

I looked in the registry and grepped on the C: to see if I could find where it was pointing to this wrong directory and simply re-point it, but I couldn't find anywhere where it pointed to that location.

I've already uninstalled once, and reinstalled from scratch again, and it did the same thing. The install file used was the 64 bit one that includes Management Studio, SQLEXPRWT_x64_ENU.

---

I've tried a number of things now, and could not get the 2012 to install. So I figured maybe just go to 2016 and see if that works. It installed but again had the same error as before, about Waiting on the Database Recovery handle. After setup concluded, I tried to start the service manually, and got the same errors in the event log about being unable to locate the MSDBDATA and MODEL files, though it has a different wrong path this time. Now it is attempting to look for those files in the directory D:\B\S2\Sources.obj.x86Release\sql\mkmastr\databases\mkmastr.proj\. I checked the startup parameters for the service in Sql Server Configuration Manager...

The file paths listed in the startup parameters ARE CORRECT.
I have no idea why it is looking for the files in this other wonky D:\B\S2... directory.

Answer 1

I think you are trying to start instance from a failed installation. Un installing and reinstalling SQL Server may clear this error.

Please look into below link which deals with similar issue.

https://connect.microsoft.com/SQLServer/feedback/details/684859/during-install-set-the-default-location-of-databases-problem

Answer 2

FINALLY tracked this thing down after digging through more logs and finding some other errors.

In order to get it running again, I had to follow these steps...

• launch Sql Server Configuration Manager
• Right click SQL Server (INSTANCE), click properties
• On the Log On tab, click Built-in Account
• Select Network Service
• Click OK to close and apply the changes.

After completing those steps, I was able to start the service. However, I still was not able to log in, it always told me 'invalid login'.

So I uninstalled and reinstalled once again, but this time I changed the service accounts during setup, all from the default NT Service\<something> to the built-in NTAUTHORITY\LOCAL SERVICE or NTAUTHORITY\NETWORK SERVICE. Having changed these during setup, everything then worked fine.

Answer 3

Strange how in 2021, I still get this error on SQL 2014 and no simple explanation where the setup is getting these paths and why it's using them.

I also changed the default location as in the question post, if that has anything to do with it. This is also a new clean install on a new VM. So technically no previous installs existed.

Windows: Windows Server 2019

MS SQL: MS SQL 2014 Express

I followed this article to solve my problem: https://social.technet.microsoft.com/wiki/contents/articles/31786.sql-server-not-starting-after-fresh-installation.aspx

The only difference, I could not get the login to work with SQLCMD, and MSSMS failed because the DB Engine still wanted to create a resources db in the wrong location.

I saw that looking at the logs here:

C:<instance root location>\MSSQL12.SQLEXPRESS\MSSQL\Log

My solution was to install a RamDisk tool, ImDisk, and create the path that it's trying to access, and copy the dbs to that location. Then only could I update the paths to the correct location.