Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm the administrator and simply run the command:

 sqllocaldb start v11.0

Result:

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

Event viewer log Event ID: 528

Windows API call WaitForMultipleObjects returned error code: 575. Windows system error message is: {Application Error} The application was unable to start correctly (0x%lx). Click OK to close the application. Reported at line: 3621.

I tried another (user and administrator) accounts, there were no problems with them.

I uninstalled & reinstalled 2012 version of SQLLocalDB.msi but I had no luck. Do you have any idea & fix?

share|improve this question
    
Visual Studio had trouble starting my project and I saw the same error in the event log. Fixed it by running sqllocaldb start v11.0. –  Andre Luus Apr 9 '13 at 6:51

5 Answers 5

Check the error log which usually under the folder C:\Users\\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0 will give you big hints.

Log back in as the administrator account (not an administrator), and start a command prompt with Run As Administrator. Then run this:

sqllocaldb share v11.0 MyInstance

You might want to explicitly add your Windows account as a sysadmin on this instance if that is a goal. So:

sqllocaldb start MyInstance

Then connect with SQLCMD, Management Studio, what have you, and run:

CREATE LOGIN [Domain\Username] FROM WINDOWS;
EXEC sp_addsrvrolemember N'Domain\Username', N'sysadmin';

Now log back in as your Windows account, and you should be able to start this instance using:

sqllocaldb start MyInstance

(It may already be started depending on your O/S and how you switched accounts.)

Then Domain\Username should be able to connect using SQLCMD, SSMS etc. using (localdb)\.\MyInstance.

share|improve this answer
    
This is a good workaround but it can't explain & solve the problem. –  Nime Cloud Dec 17 '12 at 12:50
1  
@NimeCloud um, ok, maybe someone else will come along with a better "fix." <shrug> –  Aaron Bertrand Dec 17 '12 at 14:27
up vote 2 down vote accepted

I logged off and then logged in as another administrator and renamed my user profile folder's name. I switched into my account in Windows 7. There is a newly created TEMP folder as my user profile folder. I compared before & after folder structure as in picture. Plus; LocalDB instance started successfully.

localdb2.png

I logged off and renamed my username to original. Logged again & jumped into that folder:

C:\Users\MYUSERNAME\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0

And saw the error logs; Access denied!

http://pastebin.com/ASeJGqpw

Solution: Simply delete all files in v11.0 folder. Give write permision to v11.0 folder. If you can't create another instance give write permission to Instances folder.

share|improve this answer

I had this once and a simple reboot solved it. Seems to have solved it for other people too. Maybe worth attempting before doing Nime & Aarons answers

share|improve this answer

I used to have this problem when my localdb and sql instance was installed with a different user than the current (domain user), so I fixed this by clearing the V11.0 folder and pasting the mdf and ldf files from the old path :

C:\Users\{inseryouroldusernamehere}\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0

Hope it helps.

share|improve this answer

I opened services.msc and restarted the following services:

  • Sql Server Browser
  • Sql Server VSS Writer

Hope it helps

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.