Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article describes the SQL Server requirements for System Center - Service Manager, including supported SQL Server versions and configuration settings. Microsoft SQL Server hosts the databases that Service Manager creates. In addition, Service Manager requires SQL Server Analysis Services (SSAS) to work with Microsoft Online Analytical Processing (OLAP) cubes, and SQL Server Reporting Services (SSRS) to support reporting.
Use this information to evaluate if your SQL Server environment is ready to support the installation of or upgrade to System Center. Use this information whether you're deploying one or multiple components of System Center.
SQL Server version support
| System Center 2016 component | SQL Server 2008 R2 SP1 Standard, Datacenter | SQL Server 2008 R2 SP2 Standard, Datacenter | SQL Server 2012 Enterprise, Standard (64-bit) | SQL Server 2012 SP1 Enterprise, Standard (64-bit) | SQL Server 2012 SP2 Enterprise, Standard (64 bit) | SQL Server 2014 Enterprise, Standard (64-bit) | SQL Server 2014 SP1 Enterprise, Standard (64-bit) | SQL Server 2014 SP2 Enterprise, Standard (64-bit) | SQL Server 2016, Enterprise, Standard (64-bit) |
|---|---|---|---|---|---|---|---|---|---|
| Service Manager Database or Data Warehouse Database | • | • | • | • | |||||
| Service Management Automation Web Service | • | • | • | • |
Note
System Center 2016 - Service Manager requires SQL Server 2014 or later.
System Center 2016 - Service Manager doesn't support setting the MultiSubnetFailover parameter. This parameter isn't used in System Center 2016 - Service Manager connection strings.
For detailed information about the requirements for Service Manager components, see Software Requirements.
| System Center 2019 component | Service Manager Database or Data Warehouse Database |
|---|---|
| SQL Server 2014 Enterprise, Standard (64-bit) | Yes |
| SQL Server 2014 SP1 Enterprise, Standard (64-bit) | Yes |
| SQL Server 2014 SP2 Enterprise, Standard (64-bit) | Yes |
| SQL Server 2016, Enterprise, Standard (64-bit) | Yes |
| SQL Server 2017 and Cumulative Updates | Yes |
| SQL Server 2019 with Cumulative Update 8 (CU8) or later | Yes |
Note
- Service Manager 2019 supports SQL 2019 with CU8 or later; however, it doesn't support SQL 2019 RTM.
- Use ODBC 17.3 to 17.10.4.1, and MSOLEDBSQL 18.2 to 18.6.6.
For detailed information about the requirements for Service Manager components, see Software Requirements.
| System Center 2022 component | Service Manager Database or Data Warehouse Database |
|---|---|
| SQL Server 2017 and Cumulative Updates | Yes |
| SQL Server 2019 with Cumulative Update 8 (CU8) or later | Yes |
| SQL Server 2022 | Yes |
Note
- Use ODBC 17.3 to 17.10.4.1, and MSOLEDBSQL 18.2 to 18.6.6.
- Service Manager 2022 UR4 supports MSOLEDBSQL 19.4.1 and earlier supported versions.
For detailed information about the requirements for Service Manager components, see Software Requirements.
| System Center 2025 component | Service Manager Database or Data Warehouse Database |
|---|---|
| SQL Server 2017 and Cumulative Updates | Yes |
| SQL Server 2019 with Cumulative Update 8 (CU8) or later | Yes |
| SQL Server 2022 | Yes |
| SQL Server 2025 (supported from Service Manager 2025 UR1) | Yes |
Note
- Use ODBC 17.3 to 18.5.2.1, and MSOLEDBSQL 18.2 to 19.4.1.
- System Center Service Manager 2025 UR1 supports ODBC 18.5.2.1 and MSOLEDBSQL 19.4.1, including earlier supported versions.
For detailed information about the requirements for Service Manager components, see Software Requirements.
Configure SQL Server to allow updates
To install or upgrade System Center - Service Manager, you must configure computers running SQL Server that host databases to allow updates. If you don't allow updates, System Center - Service Manager Setup doesn't complete and you see the following error message at the Create database stage of the installation:
An error occurred while executing a customer action: _ExecuteSqlScripts. This upgrade attempt failed before permanent modifications were made. Upgrade successfully rolled back to the original state of the system. Once the corrections are made, retry upgrade for this role.
Check the status of allow updates on SQL Server by running the following stored procedure from within SQL Server Management Studio:
sp_configure 'allow updates'
In the results table, check the value for run_value. If the value of run value is 1, set it back to 0 by running the following stored procedure, and then run Setup again.
sp_configure 'allow updates',0 reconfigure with override
AlwaysOn Availability Groups considerations for Service Manager databases
System Center - Service Manager supports SQL Server AlwaysOn Availability Groups functionality.
For more information about installing Service Manager with AlwaysOn availability groups, see Installing Service Manager with AlwaysOn availability groups.
Next steps
To learn about the retail and select editions of Service Manager and how the 180-day evaluation installation affects these two editions, see Service Manager editions.