No SQL Instances or Shared Services on WSUS server

Question

I have a server running WSUS, we realised that we hadn't been updating SQL and I got as installing KB5046063 to bring it up to 13.0.6450.1 and it will go no further. When installing any further updates I get an error "Error: There are no SQL Server instances or shared features that can be updated on this computer"

I have tried reinstalled the last SP (SP3) but get the same message, uninstalling the last update worked but would not reinstall after that.

SQL Server 2016

Windows Server 2019 Standard

Thanks in advance

Paul

Answer 1

It seems that you are encountering an issue with SQL Server updates on your WSUS server. The error message "Error: There are no SQL Server instances or shared features that can be updated on this computer" typically indicates that the SQL Server instance is not recognized by the update installer. Here are a few steps you can take to troubleshoot this issue:

1. Verify SQL Server Instance: Ensure that the SQL Server instance you are trying to update is indeed installed and running. You can check this by going to the SQL Server Configuration Manager and confirming that your instance is listed and operational.
2. Check for Multiple Instances: If you have multiple SQL Server instances, make sure you are targeting the correct one during the update process. The update installer may not recognize instances that are not properly configured or running.
3. Repair SQL Server Installation: Consider running a repair on your SQL Server installation. This can help fix any issues with the current installation that might prevent updates from being applied.
4. Review Update Logs: Check the SQL Server update logs for any specific error messages that might give you more insight into why the update is failing. This can often provide clues on how to resolve the issue.
5. Uninstall and Reinstall: If all else fails, you might need to uninstall SQL Server completely and then reinstall it. Make sure to back up your databases before doing this to avoid data loss.
6. Consult Microsoft Documentation: For specific guidance on troubleshooting SQL Server update issues, refer to Microsoft's documentation on SQL Server cumulative updates and installation issues.

If you continue to experience problems, it may be beneficial to reach out to Microsoft support for further assistance.

---

References:

• Troubleshoot common SQL Server Cumulative Update installation issues
• Non-applicable SQL Server CUs are listed in WSUS, MU, or ConfMgr