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