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

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► KBSQL ServersMicrosoft SQ...     Print This   
Go To Random Article
  From the July 2014 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 58 months 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

Anonymous
Comment 1 of 6

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 46 months ago


Anonymous
Comment 2 of 6

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 39 months ago


Anonymous
Comment 3 of 6

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

---
Severin
Posted 32 months ago


Anonymous
Comment 4 of 6

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

---
purvang pandya
Posted 28 months ago


Anonymous
Comment 5 of 6

Thank u so much. it's working fine.

---
Anbu
Posted 10 months ago

Latest Comment

Anonymous
Comment 6 of 6

Thank you!

---
Melissa
Posted 66 days ago
 
Write a Comment...
Full Editor
Sign in...

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


Anonymous Post:

Enter your name and security key.

Your Name:
Today's security key = P275A
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.


 KB Article #102093 Counter
16343
Since 1/16/2010
-
  Load Time=less than 1 second.
 
Print This

KB Post Options:
You do NOT have KB edit
rights to this post.
-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


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


©1995-2014 Prestwood IT Solutions.   [Security & Privacy]   Made in the U.S.A..   No H1-B.   No offshoring.