SCCM Prerequisite check error when upgradeing – SQL Server Configuration for site upgrade failed

I had a opportunity to upgrade SCCM to new version from 2006 ver. As some of you may know that before SCCM upgrade there is a process to check whether current environment meet per-requisites. I new that my SQL environment and server environment meet standard after reviewing Microsoft documents. But my environment was keep failing per-requisites no matter which new version I choose. After several ours of browsing and reading through logs was able to locate the issue on SQL and pass through the obstacle and successfully upgrade the environment.

All I had to do is connect with SQL server and run two command. I’m no expert on SQL so I’m going simply put here two command that you need to run in your SQL server environment. I’ll also will put link here for great post related to SCCM upgrade.

ALTER DATABASE SCCM_DB_NAME SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE SCCM_DB_NAME SET HONOR_BROKER_PRIORITY ON

https://blog.ctglobalservices.com/uncategorized/mas/configmgr-prerequisite-check-error-when-upgradeing-to-1810-sql-server-configuration-for-site-upgrade-failed/

https://systemcenterdudes.com/step-by-step-sccm-2103-upgrade-guide/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s