Microsoft Knowledge Base Email Alertz

The UnsupportedSQLServerVersion rule in Pre-Upgrade Checker for Windows SharePoint Services 3.0 warns you about SQL Server versions that are running with incompatible architecture or about unresponsive databases

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 976215 - Last Review: May 13, 2010 - Revision: 4.0

The UnsupportedSQLServerVersion rule in Pre-Upgrade Checker for Windows SharePoint Services 3.0 warns you about SQL Server versions that are running with incompatible architecture or about unresponsive databases

SUMMARY

The UnsupportedSQLServerVersion rule in Pre-Upgrade Checker for Windows SharePoint Services 3.0 warns you about SQL Server versions that are running with incompatible architecture. This rule also warns you about SQL Server versions that are running at an earlier update state than is required to upgrade to the next version release that supersedes Windows SharePoint Services and Microsoft Office SharePoint Server 2007. Additionally, this rule lists unresponsive databases.

Note The UnsupportedSQLServerVersion rule ships in the Windows SharePoint Services 3.0 cumulative update package that was released in October 2009. It is not part of the original release of Pre-Upgrade Checker. The original release of Pre-Upgrade Checker ships in Windows SharePoint Services 3.0 Service Pack 2 (SP2).

MORE INFORMATION

When you run Pre-Upgrade Checker, the UnsupportedSQLServerVersion rule reports information about computers that are running versions of SQL Server that do not meet the minimum version requirements. The rule reports this information in the following format:

DataSource = data source name, Version = SQL version number, 64-bit Edition = Yes/No


This rule reports information about unresponsive databases in the following format:

DataSource = data source name, Name = [database name]


SharePoint Server 2010 requires a 64-bit edition of SQL Server. The minimum required SQL Server versions are as follows:
  • SQL Server 2008 Express Edition Service Pack 1, version number 10.0.2531
    For more information, visit the following Microsoft Web site:
    http://www.microsoft.com/downloads/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff (http://www.microsoft.com/downloads/details.aspx?FamilyID=01af61e6-2f63-4291-bcad-fd500f6027ff)
  • SQL Server 2005 Service Pack 3 cumulative update package 3, version number 9.00.4220.00
    For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    967909  (http://kbalertz.com/Feedback.aspx?kbNumber=967909/ ) Cumulative update package 3 for SQL Server 2005 Service Pack 3
  • SQL Server 2008 Service Pack 1 cumulative update package 2, version number 10.00.2714.00
    For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    970315  (http://kbalertz.com/Feedback.aspx?kbNumber=970315/ ) Cumulative update package 2 for SQL Server 2008 Service Pack 1
Note Pre-Upgrade Checker ships in Windows SharePoint Services 3.0 SP2. It is used to assess the server for potential upgrade issues when you try to upgrade to the next version release that supersedes Windows SharePoint Services and SharePoint Server 2007.

REFERENCES

For more information about the Windows SharePoint Services 3.0 October 2009 Cumulative Update, click the following article number to view the article in the Microsoft Knowledge Base:
974989  (http://kbalertz.com/Feedback.aspx?kbNumber=974989/ ) Description of the Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (WSS server-package): October 27, 2009

APPLIES TO
  • Microsoft Windows SharePoint Services 3.0
Keywords: 
kbhowto kbexpertiseinter kbsurveynew KB976215
       

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