Sql – Moving SQL Server 2008 R2 Logs Causing Access Denied Error

Firstly, it seems someone is changing options on your database using sp_configure, do you know who this is? looks like this has occurred with a script (times are close together) They may also have changed the location of your model database using a procedure similar to this After the change the sql server service has been shutdown, which is why you see the default trace & service broker stopping (normal). If it was changed to an incorrect location, then this would explain why sql server wont start

A database id of 3 is the model database, so you've either moved a bad copy of model, or its corrupt. You have 2 options depending on which is easier for you depending on your setup.

1. Start the database in single user mode and restore model from a backup.
2. (Sledgehammer approach) Rebuild the master databases Then re-attach user databases & re-created your SQL Agent jobs

All SQL Server database files, including tempdb, must reside on uncompressed folders. The problem you mention usually occurs when the server cannot create tempdb at startup because the files are compressed. The file name you see (e:\sql10_main_t.x86fre...) has nothing to do with your deployment, it is the path used during build time when the master database that ends up on the CD/download media is created. This path is the changed during installation by the SQL Server setup. In your case, the change did not occur because the setup could not startup the database to make the change (this is part speculation on my part, since such problems are hard to investigate without proper setup/startup logs).

I'd recommend you uninstall this instance, then attempt a new installation making sure the database data folders you chose at install are not compressed (note that by default they inherit the parent folder compression settings).