How to patch SSIS, SSRS and SSAS Shared and Instance features via WSUS?

Peeter Tiidemann 1 Reputation point

We patching our clients and servers with WSUS. There are no such products as Reporting Services or Integration services in WSUS console, but only specific SQL Server versions like Microsoft SQL server 2016 etc... I googled and found that some updates for SQL are standalone and not available via WSUS and this confuses me, as I need to ensure that our SQL Shared Features together with Instance Features are patched! Can someone clarify this topic to me, which product or classification should I enable in WSUS to get those updates or is it possible to find the list of all standalone updates for SQL SSIS, SSRS and SSAS Shared and Instance features?

Thanks in advance,

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,635 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,323 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,208 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,841 Reputation points

    Hi @Peeter Tiidemann ,

    Welcome to Microsoft Q&A!

    is it possible to find the list of all standalone updates for SQL SSIS, SSRS and SSAS Shared and Instance features?

    Which SQL Server version do you used? Since SQL Server 2017, the Reporting Services has been separated from SQL Server installer. If you would like to upgrade SSRS to latest version, you could download from here. For SSAS and SSIS, they are still included in SQL Server installer. For more information, please refer to SQL Server installation guide.

    Best regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments