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

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

July 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

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.

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
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 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!

---
Nicole
Posted 59 months ago

Comment 3 of 7

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

---
Severin
Posted 52 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 48 months ago

Comment 5 of 7

Thank u so much. it's working fine.

---
Anbu
Posted 30 months ago

Comment 6 of 7

Thank you!

---
Melissa
Posted 22 months ago

Latest Comment
Comment 7 of 7

Thanks For your support

---
Si Thu
Posted 67 days 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 = P116A1
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
25760
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

email: info@prestwood.com


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


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