“Operating System error system may not find the file specified e:\sql10_main_t….” when attempting to start the SQL Server service

A new installation of SQL Server 2014 express may present problems when starting the service at the end of the installation. You can attempt to start the instance by hand using “Service.msc”, browsing down to SQL SERVER (ACCTIVATE), right clicking the instance and clicking start, however you may get the error message below.

Unable to open the physical file “e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\model.mdf”. Operating system error 3: “3(file not found.)”.

Although you can attempt to reinstall the instance, however the installation will still attempt to open the master database in a location that may not exist. To correct this, follow the steps below…

  1. Follow this article to correct the incorrect master files location and reset SA: https://social.technet.microsoft.com/wiki/contents/articles/31786.sql-server-not-starting-after-fresh-installation.aspx
  2. Once the master files are pointed to the right directory, open SQL Server Managment Studio, login as user SA
  3. click on the NEW QUERY button on the top left
  4.  Run the query below.

                use master
                go
                select @@SERVERNAME
                go

If the result of the query returns a null value, run the following script below. Where SERVERNAME and INSTANCENAME are replace with their respective values.

                sp_addserver ‘SERVERNAME\INSTANCENAME’, local

 

After that’s set restart the SQL Server instance and attempt to start Acctivate.

Tagged with: , , , ,
Posted in Database, Other Applications, Technology - Last modified on June 8, 2017daniel.stenbro
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.