These errors are logged for every startup of Vista Ultimate x32 SP2:
The SQL Server (SQLEXPRESS) service terminated with service-specific error
1814 (0x716).
FileMgr::StartLogFiles: Operating system error 2(The system cannot find the
file specified.) occurred while creating or opening file
'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386 \MSDBLog.ldf'. Diagnose and
correct the operating system error, and retry the operation.
FCB::Open failed: Could not open file
e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\ model.mdf for file number
1. OS error: 21(The device is not ready.).
The "e:\" drive on my system is a Virtual Clone Drive ISO reader that I used
to install SQL Server 2008, VS 2008 SP1 V3.5, VS 2010 Beta 1, VS 2010 Beta 2,
and other ISO downloads. So far I haven't been able to find an ISO with a
"sql10_main_t" directory. I can't connect to SQL Server Compact 3.5 SP2
Beta to change the MSDBLog.ldf directory because the SQLEXPRESS service can't
load. SQL Server Compact 3.5 SP2 Beta Repair runs but doesn't have any
apparent impact. The only MSDBLog.ldf file anywhere on my PC is owned by SQL
Server 2008. As far as I know I am not using SQL Server Compact - is it
safe to delete it? Is there any way to get SQL Server Compact setup
correctly? Should I ignore these errors?


--
Mark

Mark (Mark (AT) discussions (DOT) microsoft.com) writes:
I'm not really sure where Compact comes in here. But apparently you
have a broken instance of the Express Edition of SQL Server. You be
able to uninstall it. Or you can just use SQL Server Condiguration Manager
to set the SQLEXPRESS instance not to auto-start.

Then again, it seems that you have an instance of SQL Server on the
machine you are actually using. It's not clear if this is the Express
instance or another instance. I'm assuming here that they are two different
instances, one working and one broken.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

--
Mark


"Erland Sommarskog" wrote:

an instance of SQL Express that fails to load and generates the errors above
in the event log. Sorry, I don't know sql server and didn't realize that
SQL Express and SQL Compact are 2 difference programs. SQL Compact is in
Control Panel\Programs and Features, SQL Express isn't.

Here are the startup parameters of SQL Express
-dc:\Program Files\Microsoft SQL
Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\master.mdf;-ec:\Program Files\Microsoft
SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG;-lc:\Program Files\Microsoft
SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\mastlog.ld
All these parameters reference valid directories and files on the C:\ drive.

Where does the "e:\sql10_main_t\sql\mkmastr\databases\objfre\i386 " directory
error come from?

Mark (Mark (AT) discussions (DOT) microsoft.com) writes:
Probably the master database. But the next question is how it wound up
there, and to that I have no idea.

Normally, you should see an entry per instance of SQL Server in
Add/Remove programs, but this instance is clearly not normal.

The eaiest way is probably to go to the startup tab and select Disabled
to be spared from the error messages.






--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx