August 27, 2014 at 8:01 am
Hello, our windows server had automatic updates set on. The last update did something and on a couple machines SQL Server will not start. When trying to start the service we receive the error:
Windows could not start SQL Server (ourSQL) 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 5023.
The event:
The SQL Server (ourSQL) service terminated with service-specific error 5023 (0x139F).
I have tried starting the service from service manager, SQL configuration tool, and command line.
Any suggestions?
Thank you.
[edit]SQL server 2008 standard, Windows 2008 standard
We have narrowed it down to Windows 2008 standard boxes. The Windows 2008R2 boxes are okay[/edit]
August 28, 2014 at 3:33 am
Perhaps this MS Connect issue will help.
Turn off automatic updates 😛
August 28, 2014 at 4:22 am
First thing the systems guy did.
September 2, 2014 at 2:33 am
Are you running the service with a useraccount, and if so, is it locked out?
September 2, 2014 at 5:04 am
We used user (with sys admin rights), the network sys admin and the system sys admin accounts. None worked.
Restored without updates finally worked. Bad thing is it was the computer controlling backups.:-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply