Microsoft Knowledge Base Email Alertz

SharePoint users are incorrectly offered a SQL Server 2000 Desktop Engine (Windows) update when they try to install the security update in Microsoft Knowledge Base article 960082

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]

Search KbAlertz

Advanced Search

Webmasters
Put kbAlertz on your website.
[ Click Here for more! ]





ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
KBAlertz referrals get
** SIX MONTHS FREE **


Community Site



We Send hundreds of thousands of emails using ASP.NET Email


ASP.NET 3.5 Web Hosting with Windows 2008 and SQL 2008: Click Here!
Discount ASP.NET Hosting
ASP.NET 2.0 and 3.5
Windows2008 and SQL2008
US and UK Hosting
KBAlertz referrals get
** SIX MONTHS FREE **




Mentioned In








Microsoft Knowledge Base Article

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




Article ID: 967096 - Last Review: February 10, 2009 - Revision: 1.2

SharePoint users are incorrectly offered a SQL Server 2000 Desktop Engine (Windows) update when they try to install the security update in Microsoft Knowledge Base article 960082

System TipThis article applies to a different version of Windows than the one you are using. Content in this article may not be relevant to you.Visit the Windows Vista Solution Center

SYMPTOMS

In a Microsoft Office SharePoint Server or Windows SharePoint Server environment, you try to install the security update for Microsoft SQL Server 2000 and SQL Server 2000 Desktop Engine (also known as MSDE 2000) that is described in the following Microsoft Knowledge Base article:
960082  (http://kbalertz.com/Feedback.aspx?kbNumber=960082/ ) MS09-004: Description of the security update for SQL Server 2000 GDR and MSDE 2000: February 10, 2009
By default, this update is recommended. However, SharePoint users who upgraded from SQL Server 2000 Desktop Engine (Windows) to any other edition of SQL Server 2000 may incorrectly be offered a SQL Server 2000 Desktop Engine (Windows) update for the security release in Microsoft Knowledge Base article 960082. For example, users who upgraded to SQL Server 2000 Standard Edition may be offered a SQL Server 2000 Desktop Engine (Windows) update.

CAUSE

This problem can occur if the following conditions are true:
  • The server was upgraded from MSDE 2000 to SQL Server 2000.
  • SQL Server 2000 Service Pack 4 (SP4) was incorrectly installed on the server.
  • The SQL Server 2000 Desktop Engine (Windows) update in Microsoft Knowledge Base article 960082 was then installed.
When these conditions are true, SharePoint Server may stop working.

RESOLUTION

To resolve this problem and restore SharePoint functionality, follow these steps:
  1. Perform the upgrade to SQL Server 2000 again.

    Note You must use the same media that was previously used to perform the upgrade to SQL Server 2000.
  2. Restart the server instance. The server instance should start as the upgraded version.
  3. Apply SQL Server 2000 SP4.

    Note Make sure that you apply the SQL Server 2000 SP4 and not the MSDE SP4 or SQL Server 2000 Desktop Engine (Windows) SP4 updates.

    For more information about how to obtain SQL Server 2000 SP4, visit the following Microsoft Web page:
    http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5 (http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5)
  4. Manually apply the Sp4_serv_uni.sql from the Install folder. To do this, enter the following command at a command prompt:
    osql -n -b -d master -Slpc:%computername%\SHAREPOINT -i "%programfiles%\Microsoft SQL Server\MSSQL$SHAREPOINT\Install\sp4_serv_uni.sql" -o "%programfiles%\Microsoft SQL Server\MSSQL$SHAREPOINT\Install\sp4_serv_uni.out" -E
    Note These steps assume that the SQL Server 2000 Desktop Engine (Windows) installation folder is in the default location. If you are using a custom installation, you must adjust the path accordingly in the command.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

APPLIES TO
  • Microsoft SQL Server 2000 Service Pack 4
  • Microsoft Windows Server 2003 Service Pack 2, when used with:
    • Microsoft Windows Server 2003, Datacenter Edition for Itanium-Based Systems
    • Microsoft Windows Server 2003, Enterprise Edition for Itanium-based Systems
    • Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
    • Microsoft Windows Server 2003, Web Edition
    • Microsoft Windows Server 2003, Datacenter Edition (32-bit x86)
    • Microsoft Windows Server 2003, Datacenter x64 Edition
    • Microsoft Windows Server 2003, Enterprise x64 Edition
    • Microsoft Windows Server 2003, Standard x64 Edition
  • Microsoft Windows Server 2003 Service Pack 1, when used with:
    • Microsoft Windows Server 2003, Datacenter Edition for Itanium-Based Systems
    • Microsoft Windows Server 2003, Enterprise Edition for Itanium-based Systems
    • Microsoft Windows Server 2003, Datacenter Edition (32-bit x86)
    • Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
    • Microsoft Windows Server 2003, Web Edition
Keywords: 
kbinstallation kbexpertiseinter kbtshoot kbsurveynew kbprb KB967096
       

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