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

View products that this article applies to.

Expand all | Collapse all

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 Sitecode dialog box:

Collapse this tableExpand this table

Status	Test Name
Error	Site Database SQL version less than 7.0 SP3
Error	Collation of temp database and SMS database should be the same

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

Error information from one location in the file

<Rule>
   <RuleName>Site database SQL version less than 7.0 SP3</RuleName> 
   <RuleDescription>Verifies that the site database is running on SQL version 7.0 SP3 or higher.</RuleDescription> 
   <FailureDescription>Could not execute SQL query.</FailureDescription> 
   <Status>Failed</Status> 
</Rule>

Error information from another location in the file

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

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

Back to the top

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.

Back to the top

WORKAROUND

No action is needed to work around this problem. The error message that is mentioned in the "Symptoms" 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: