Happy New Year.
Yesterday, I get a call from the project team. Apparently, they found a bug that needs an emergency fix. This was a project that I haven't looked at in over a month. Starting my VM, I found out that my SQL Server Instance was crashing. The message that I kept getting was:
FCB::Open failed: C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\mssqlsystemresource.mdf
1
2(The system cannot find the file specified.)
My initial check indicated that that was a security issue that my logon user for my SQL Instance needed to granted access to the relevant directories. However, my user was Network Service, so it should have full permissions for everything on the VM.
Further checking indicated that a security patch from MS was to blame. Apparently, the files (both mdf and ldf) were moved to different location: C:\Program Files\Microsoft SQL Server\130\LocalDB\Binn. Copying and pasting the files to the correct location solved the problem.
http://strictlysql.blogspot.ca/2016/11/sql-server-2016-sql-service-doesnt.html
No comments:
Post a Comment