HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlModerate

Cannot start SqlLocalDB instance with my Windows account

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
cannotwithaccountinstancesqllocaldbwindowsstart

Problem

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?

Solution

Check the error log which usually under the folder %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 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.

Code Snippets

sqllocaldb share v11.0 MyInstance
sqllocaldb start MyInstance
CREATE LOGIN [Domain\Username] FROM WINDOWS;
EXEC sp_addsrvrolemember N'Domain\Username', N'sysadmin';
sqllocaldb start MyInstance

Context

StackExchange Database Administrators Q#30383, answer score: 16

Revisions (0)

No revisions yet.