Cannot start LocalDB

Question

Cannot start LocalDB instance, I have installed and re-installed over and over.

Keep getting this error :

Start of LocalDB instance "v11.0" failed because of the following error: Error occurred during LocalDB instance startup: SQL Server process failed to start.

Anyone any advice ? ?

Microsoft SQL Server 2012, i have ensured the FULL installation options, stopped all services SQL related and tried restarting .

sqllocaldb info  

gives me :

Projects v11.0

when i try

sqllocaldb start v11.0 

I get the above error.

Answer 1

When all else fails and you don't care about data loss, delete and recreate your LocalDB\v11.0 database! At the command prompt

sqllocaldb delete v11.0 sqllocaldb create v11.0 

(Sqllocaldb is in your PATH right? It was for me.)

Answer 2

I was getting a similar error, but when running

sqllocaldb start 

The local db started successfully. Also when checking the event log I saw an error along the lines of

Windows API call WaitForMultipleObjects returned error code: 575

What fixed it for me:

1. In IIS, configure the app pool to run under an account with permissions to the DB on the server (advanced options of the app pool)
2. In the advanced option of the app pool, set Load User Profile to true

Reference: http://blogs.msdn.com/b/sqlexpress/archive/2011/12/09/using-localdb-with-full-iis-part-1-user-profile.aspx