debugsqlModerate
Cannot start SqlLocalDB instance with my Windows account
Viewed 0 times
cannotwithaccountinstancesqllocaldbwindowsstart
Problem
I'm the administrator and simply run the command:
Result:
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?
sqllocaldb start v11.0Result:
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?
Solution
Check the error log which usually under the folder
Log back in as the administrator account (not an administrator), and start a command prompt with
You might want to explicitly add your Windows account as a sysadmin on this instance if that is a goal. So:
Then connect with SQLCMD, Management Studio, what have you, and run:
Now log back in as your Windows account, and you should be able to start this instance using:
(It may already be started depending on your O/S and how you switched accounts.)
Then
%localappdata%\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 MyInstanceYou might want to explicitly add your Windows account as a sysadmin on this instance if that is a goal. So:
sqllocaldb start MyInstanceThen 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.Code Snippets
sqllocaldb share v11.0 MyInstancesqllocaldb start MyInstanceCREATE LOGIN [Domain\Username] FROM WINDOWS;
EXEC sp_addsrvrolemember N'Domain\Username', N'sysadmin';sqllocaldb start MyInstanceContext
StackExchange Database Administrators Q#30383, answer score: 16
Revisions (0)
No revisions yet.