PrestwoodBoards: Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. ... service-specific error code -2146885628 (DBA, Databases, & Data)

DBA

	DBA Group Home
Get Started Page eMag: DBA Edition Highlights WEEKLYLESSON Week 27 Lesson MYGROUPSETTINGS My Group Settings

	Message Board
-New Activity -Unanswered Threads -Most Active Threads -Most Read Threads

	DBA KB
-New & Updated -Most Read -10 Min Quickstarts -Recent Comments Tech Articles DBA News Errors Library File Library Resource Links DBATIDBITS: All as FlashCards Code Snippets FAQs Tips Terms & Definitions

	DBA Store
PRESTWOODSTORE Store Home Buy DBA Items

	Members Only
MEMBERSONLY DBA Member List Member Only KB Posts DBA Content Stats Random Article Random MB Thread Random Tidbit

Prestwood eMagazine

July Edition

Subscribe now! It's Free!

► KB ► SQL Servers ► Microsoft SQ...

Print This

From the January 2016 Issue of Prestwood eMag

DBA Microsoft SQL Server:

Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. ... service-specific error code -2146885628

By Bryan Valencia

Posted 10 years ago on 1/16/2010 and updated 1/20/2011

A documented error from our DBA Documented Errors Page

KB102093

Documented Error:

Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code -2146885628.

When I opened services I noticed that SQL Server (SQLEXPRESS) was set to Automatic, and not running.

Clicking start yielded a 3 minute delay and an error message.

The Solution:

Opened the "properties" dialog for the service, and on the Log On tab, changed the user from "This Account" to "Local System Account". Started the service, and bingo.

Correct Settings for SQLExpress

Note: According to my sources, this error can also happen if you allowed Disk Cleanup to compress your data folders.


Comments 1 Comments. Share a thought or comment...

First Comment

Anonymous

Comment 1 of 7

Thank you so much - l have been trying to search for solutions to this error for a long time - it was such a simple solution.

Regards

---

Ronald Eyit

Posted 9 years ago

Anonymous

Comment 2 of 7

Thank you so very much. I ran a clone/back-up program the other day and ever since I've not been able to access my databases. I appreciate this so very much!

---

Nicole

Posted 9 years ago

Anonymous

Comment 3 of 7

Thanks for this workaround. Now I need to fix this service account issue.

---

Severin

Posted 8 years ago

Anonymous

Comment 4 of 7

i have all this thing u have mention but still i cant star the services so please give me the solution