The Realm of the Verbal Processor

Jarvis's Ramblings

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:

image 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.

Advertisements

December 2, 2009 - Posted by | ConfigMgr

1 Comment »

  1. […] Setup cannot upgrade the ConfigMgr database « The Realm of the Verbal Processor Filed under: System Center, ConfigMgr 2007 […]

    Pingback by Setup cannot upgrade the ConfigMgr database « The Realm of the Verbal Processor - Rod Trent at myITforum.com | December 3, 2009


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s