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.
Advertisement
Answer
When all else fails and you don’t care about data loss, delete and recreate your LocalDBv11.0 database! At the command prompt
sqllocaldb delete v11.0 sqllocaldb create v11.0
(Sqllocaldb is in your PATH right? It was for me.)