sqlsql-serversql-server-2012

Cannot start LocalDB


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.


Solution

  • 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.)