The Realm of the Verbal Processor

Setup cannot upgrade the ConfigMgr database

Was recently working on upgrading SMS 2003 to ConfigMgr SP2 and ran into a problem upgrading the database. All pertinent prereqs passed, but when it started the actual installation, it errored out with the following popup:

When I checked the ConfigMgrSetup.log file, I saw the following messages:

Upgrade database…
The database compatibility level for SMS_CC1 is 90
***SqlError: [08S01][11][Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.
READ_COMMITTED_SNAPSHOT enabled.
***SqlError: [42000][5808][Microsoft][ODBC SQL Server Driver][SQL Server]Ad hoc update to system catalogs is not supported.
SqlExecute <if NOT EXISTS(select * from sys.configurations where name=’clr enabled’ and value_in_use=1) begin    exec sp_configure ‘clr enabled’, 1   RECONFIGURE end >
FinalSqlOperations::Could not enable SQL CLR.
Setup cannot upgrade the ConfigMgr database.  Contact your SQL administrator.

So…I searched on everything in those log entries and came up blank. Ad-hoc updates are enabled. Setup was successfully enabling SQL CLR. Something was still failing.

I finally came across this forum thread where a user stated that the problem in their environment was the SQL authentication mode. Now…I’ve always seen that message during the prereq check, but since it is a warning instead of an error, I have always ignored it…and have never had a problem until now. After changing the SQL authentication mode to be only “Windows Authentication”, the setup went through without a problem.

December 2, 2009 - Posted by Jarvis | ConfigMgr