Your full service technology partner! 
-Collapse +Expand
Search DBA Group:

-Collapse +Expand DBA Store

Prestwood eMagazine

October Edition
Subscribe now! It's Free!
Enter your email:

   ► KBSQL ServersMicrosoft 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
Posted 6 years ago on 1/16/2010 and updated 1/20/2011
 A documented error from our DBA Documented Errors Page


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.

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


Share a thought or comment...
First Comment
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.


Ronald Eyit
Posted 5 years ago

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!

Posted 5 years ago

Comment 3 of 7

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

Posted 55 months ago

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

purvang pandya
Posted 51 months ago

Comment 5 of 7

Thank u so much. it's working fine.

Posted 33 months ago

Comment 6 of 7

Thank you!

Posted 25 months ago

Latest Comment
Comment 7 of 7

Thanks For your support

Si Thu
Posted 6 months ago
Write a Comment...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1231A1
Enter key:
Error Contributed By Bryan Valencia:

Bryan Valencia is the author of millions of lines of code and writes for PrestwoodBoards and Visual Studio Journey on-line magazines.

Visit Profile

 KB Article #102093 Counter
Since 1/16/2010
   Share This Page!
Share on...

   Contact Us!
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675


   Follow Us!
Connect With Us...
Like our page!!!
Follow us!
Join Group
View channel.
Go ahead!   Use Us! Call: 916-726-5675 

©1995-2016 Prestwood IT Solutions.   [Security & Privacy]