Microsoft SQL Server database support for Symantec IT Analytics

Products

• IT Analytics

Issue/Introduction

The IT Analytics (ITA) Server Admin Guide (version 2.9.1) states that Microsoft SQL Server 2012 SP1 or later is a prerequisite for ITA. As Microsoft releases new service packs (SP) and cumulative updates (CU), is ITA tested and certified on these SPs and CUs?

Environment

Release : 2.9.1

Component : Microsoft SQL Server

Resolution

ITA is not tested against every service pack and update issued by Microsoft, except as needed. Each new release of ITA will be tested on the latest publicly available build of SQL Server at that time. Broadcom will support ITA installed on the prerequisite major version of SQL Server and all subsequent minor versions, service packs, and cumulative updates.

Although Microsoft SQL Server is a prerequisite for ITA, Microsoft is responsible for supporting any issues with the SQL Server relational database management system (RDBMS), including SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). Broadcom only supports the ITAnalytics database and cube schemas. We test and certify these schemas at the time of their release on the publicly available build of each major SQL Server release available at that time (e.g., SQL Server 2019), and subsequent updates as needed. For any issues that arise after installing a later SQL Server version (including SPs and CUs), Broadcom will assist with determining the cause and resolving the issue as it relates to the ITAnalytics database and cube schemas.