Microsoft KB Archive/939305

= Error result when you run the Systems Management Server 2003 Service Pack 3 Deployment Readiness Wizard: &quot;Site Database SQL version less than 7.0 SP3&quot; =

Article ID: 939305

Article Last Modified on 11/30/2007

-

APPLIES TO


 * Microsoft Systems Management Server 2003

-



SYMPTOMS
You decide to upgrade a Microsoft Systems Management Server (SMS) 2003 site server to SMS 2003 Service Pack 3 (SP3). You run the SMS 2003 SP3 Deployment Readiness Wizard to determine whether SMS 2003 SP3 can be installed successfully. In this scenario, the following test results appear in the Test Result for  dialog box:

Additionally, if you click View Report in this dialog box, the _Report.xml file appears. The following error information is logged in this file:

Error information from one location in the file

 Site database SQL version less than 7.0 SP3 Verifies that the site database is running on SQL version 7.0 SP3 or higher. Could not execute SQL query. Failed 

Error information from another location in the file

 Collation of temp database and SMS database should be the same Verifies collation of temp database and SMS database are the same.</RuleDescription> Could not execute SQL query.</FailureDescription> Failed</Status> </Rule>

You experience this problem if the SMS 2003 site server database is hosted in Microsoft SQL Server 2005.

<div class="cause_section">

CAUSE
This problem occurs because the SMS 2003 Deployment Readiness Wizard queries the SQL Server 2005 master database for the spt_server_info attribute. However, this attribute is not contained in the SQL Server 2005 master database. Therefore, the query is unsuccessful. Therefore, the SMS 2003 Deployment Readiness Wizard incorrectly determines that the database is earlier than SQL Server 7.0 SP3.

<div class="workaround_section">

WORKAROUND
No action is needed to work around this problem. The error message that is mentioned in the &quot;Symptoms&quot; section does not prevent the installation of SMS 2003 SP3. The following SQL Server installations are supported for use with SMS 2003 Service Pack 2 (SP2) and with SMS 2003 SP3:
 * The release version of SQL Server 2005
 * SQL Server 2005 Service Pack 1 (SP1)
 * SQL Server 2005 Service Pack 2 (SP2)

For more information about the supported configurations for SMS 2003 SP3, visit the following Microsoft Web site:

http://download.microsoft.com/download/5/c/a/5cab7c25-9dba-4462-a887-1977337e369e/SMS2003SP3SupportedConfigurations.htm

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
For more information about SMS 2003 SP3, visit the following Microsoft Web site:

http://technet.microsoft.com/en-us/sms/bb676774.aspx

Keywords: kbtshoot kbprb KB939305

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.