C:\Program Files\Microsoft SQL Server\Mssql$JDELocal\DataMSSQL$JDELOCAL\LOG contains a file called “errorlog”, which contains MSDE error messages. That is pretty handy… I was getting:
5788/3884 MAIN_THREAD Wed Jan 27 16:02:29.590001 Odbc_u1.c901
ODB0000164 - STMT:00  [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'SPEC_PY812BF' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
I stopped and started the JDELOCAL MSDE service and everything came up like a peach – but good to have a look through those logs.
I was getting this in the errorlog file:
2010-01-27 14:54:54.83 spid52 Starting up database 'SPEC_PY812BF'.
2010-01-27 14:54:54.83 spid52 udopen: Operating system error 2(error not found) during the creation/opening of physical device d:\e812\PY812\Spec\SPEC_PY812BF.mdf.
2010-01-27 14:54:54.83 spid52 FCB::Open failed: Could not open device d:\e812\PY812\Spec\SPEC_PY812BF.mdf for virtual device number (VDN) 1.