Error Update SQL Sever version

The error indicates that Setup cannot stop the SSIS service NT Service\MsDtsServer150 while applying the SQL Server 2019 update. This prevents the update from proceeding.

Use the following steps to resolve it:

1. Before running the update, manually stop the SSIS service:
   • Open Services.msc.
   • Locate SQL Server Integration Services 15.0 (service name MsDtsServer150).
   • Stop the service.
   • Ensure no SSIS packages or tools are currently using the service.
2. Run the SQL Server 2019 update again as an administrator.
3. If the service cannot be stopped from Services:
   • Check for any SSIS-related processes or scheduled tasks using the service and stop them.
   • Use SQL Server Configuration Manager to stop the SSIS service.
   • If still blocked, restart the server to clear any hung handles, then stop the service immediately after reboot and rerun the update.
4. After the update completes successfully, verify:
   • SQL Server and SSIS versions are updated.
   • All required SQL Server services start normally.

If the update still fails, review the setup logs under C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log (summary.txt and details.txt) for additional blocking errors and address those before retrying.

References:

• KB4517790 - Servicing Update for SQL Server 2019 RTM
• How do fix Microsoft SQL server installation issue. - Microsoft Q&A