Tuesday, November 3, 2020

SQL Server Services are not visible in the SQL Server configuration manager.

The Curious Case of missing SQL Server Services in the SQL Server Configuration Manager.

Issue: Services are not visible in SQL Server configuration manager.

 

We received a mail stating that the application is completely down and they are seeing SQL Server related errors in the logs. When I connected to the database server noticed services are not visible in the SQL Server configuration manager. Yes, there are no SQL Server services in the SQL Server configuration manager. My first impression, someone worked really hard!!

 

services missing

When I couldn’t see the SQL Server services in SQL Server Configuration manager the next place I verified is services.msc. When I opened services.msc, I can see SQL Server services there at least, but when I tried starting the services it failed with the below error:

 

Application popup: SQL Server: Your SQL Server installation is either corrupt or has been tampered with (Could not open default language SQLEVN70 resource file).   Please uninstall then re-run setup to correct this problem

 

As the error indicates the installation is either corrupt or there is a missing resource file. When I searched for the “SQLEVN70” resource file, I found it in the server. When I verified the event logs noticed messages related to windows updates failure. So next, I verified “View Installed Updates” under Control Panel -> Programs -> Programs and Features -> Installed Updates (sample screenshot of the location below)


check installed updates


and noticed 2 SQL Server updates that got installed recently. One is Hotfix 5830 and the other is SQL Server 2016 SP2 CU14. Looks like while these patches are getting installed the installation process got interrupted due to some reason and the installation failed. This has resulted in the issue.

 

Below are the troubleshooting steps I followed for fixing my issue:

 

1.    I have uninstalled the hotfix 5830 first.

2.    I have uninstalled the CU14 hotfix.

3.    Performed SQL Server Instance repair.

 

Below are the details on how I did each of the steps:

First uninstalling the hotfix 5830. To Uninstall, right-click on the already installed updates (which can be found here: Control Panel -> Programs -> Programs and Features -> Installed Updates) and click on ‘Uninstall’ and proceed.

uninstall windows updates


Select the components from which you want to uninstall the hotfix or CU. Please note here I am selecting on 'Shared Features' but in the actual production server, we need to select all the components that are applicable like Database Engine and so on.
 
remove features

Click on 'Remove'

uninstall sql server patch

















To Uninstall the CU14 from all the database components, follow the same above step i.e.., right-click on the CU14 update in ‘view installed updates’ and select uninstall. Once uninstallation completes restart the server again.

Now once the server comes up, copy the SQL Server 2016 setup files to any drive in the server and run the setup.exe. Once the window will open, select ‘Maintenance’ and select ‘Repair’, as shown below screenshot. Now select the instance that needs to be repaired and in my case, it is the default instance.

sql server instance repair

sql server instance repair





Press ‘Repair’ and the selected instance repair will start

 

sql server instance repair


Once the repair of the instance completed successfully I have refreshed the SQL Server Configuration Manager and I was able to see all the SQL services in the SQL Server configuration manager.

Now I have started the SQL Server services and everything started working as usual.

On searching online I found this issue of services disappearing from SQL Server configuration manager also happens if someone renames names in the registry if some dll or resource files are missing and so on.

 

If you have faced this issue share your experience on how you fixed it in the comments sections below.

 

Thanks VV!!

 

 

“The best friend you will ever find is you. Love yourself with joy and fill your heart with bliss and happiness.”

― Debasish Mridha

 

#MSSQL #SQL #SQLServer #database

No comments:

Post a Comment