大网数据广告活动
启动与系统组件

Error 0x80131604 installing an OpsMgr management server

· 52CE 我爱测

Fixes an issue in which you receive an exception error code 0x80131604 during the installation of a System Center 2012 Operations Manager server.

This article provides a solution to solve the Ad hoc update to system catalogs is not supported error that occurs when you install a System Center 2012 Operations Manager management server.

Original product version:   System Center 2012 Operations Manager
Original KB number:   2713047

Symptoms

Installing a System Center 2012 Operations Manager management server fails with the following error:

Error: :Exception running sql string
sp_configure 'show advanced options', 1
RECONFIGURE
: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code: 0x80131904, Exception.Message: Ad hoc update to system catalogs is not supported.
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
[DateTime]: Error: :StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

Error: :RunAdminScripts failed with the following exception: : Threw Exception.Type: System.Reflection.TargetInvocationException, Exception Error Code: 0x80131604, Exception.Message: Exception has been thrown by the target of an invocation.

Note: Operations Manager log files are located at %LocalAppData%\SCOM\Logs.

Cause

An Ad hoc update to system catalogs is not supported error is encountered during the Intelligent Queue installation. This error means that SQL Server would not allow a change to its catalogs. This can occur if the setting for allow updates has been changed and set to 1. Starting with SQL Server 2005, direct updates to the system tables are not supported so we need to turn this setting off to make any further changes in the catalog and tables.

The SQL Server allow updates option is present in the sp_configure stored procedure.

To test if this is the cause of your issue, manually run the following query against the master database:

sp_configure 'show advanced options', 1

Then run,

RECONFIGURE

If you're experiencing the issue described in this article, the command will fail with the following message.

Exception.Message: Ad hoc update to system catalogs is not supported.

Resolution

To work around this issue, change the value to 0 with the following query. This setting allows the SQL Server database to receive any changes or updates to its catalog.

EXEC sp_configure 'allow updates', 0

Then run,

RECONFIGURE

This will run successfully.

Once completed, restart the installation of the management server.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 04/15/2024
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。