Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 939305 - Last Review: November 30, 2007 - Revision: 1.2
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"
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>
<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.
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.
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:
- 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:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about SMS 2003 SP3, visit the following Microsoft Web site:
APPLIES TO
- Microsoft Systems Management Server 2003
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate