asked on

SQL server cannot be started by SQL service

My SQL server is 2016 SQL. The SQL server has replication service running. I installed below two KBs
SQLServer2016-KB4458871-x64
SQLServer2016-KB4464106-x64

Both KBs seem not installed successful because it doesn't show "successful" But, instead showing the image attached. But, after applying the KBs, the SQL service is not auto started. Even I manually started it, it failed with the image attached.

So, I have to use the following command to start it.

NET START MSSQL$INSTANCENAME /T902

I don't want to start SQL service every time I have to run this command, but instead using SQL service

Do you know why the SQL service is not started auto. How to fix this issue? I know uninstalled is very complicated even not possible because they have installed into the registry
CaptureSQLPatchingProvisioningdbissu.PNG
CaptureSQLPatchingProvisioningdbissu.PNG

Raja Jegan R

We can see whether uninstallation is really required or not but before that can you kindly share across the SQL Server Log file which will have the detailed reason for Failure so that we can fix the issue accordingly.
You can find the SQL Server latest log from the installation folder with file named as ERRORLOG..(default path below and the actual one might vary based upon your installed version and instance name)
C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Log

wasabi3689

ASKER

Hi

There are multiple SQL log, I don't know which one. But, I do see this issue from event logs. I am attaching here. Please point me how to fix it without rebuilding the server or uninstall the patches.
CaptureSQLPatchingProvisioningdbissu.PNG
CaptureSQLPatchingProvisioningdbissu.PNG
CaptureSQLPatchingProvisioningdbissu.PNG

Raja Jegan R

It appears like the Patch upgrade kind of corrupted your master database..
Kindly let us know whether you have master database backup available or not so that we can plan restore it otherwise you might need to rebuild your master database and other system databases.

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.