You receive a "Service Pack 3 must be installed" error message when you use the Microsoft Office Project Server Sample Data Configuration Wizard in Project Server 2003 (897767)


The information in this article applies to:

  • Microsoft Office Project Server 2003

SYMPTOMS

You experience one of the following symptoms when you use the Microsoft Office Project Sample Data Configuration Wizard in Microsoft Office Project Server 2003:
  • When you try to install or to configure the sample database for a named instance of Microsoft SQL Server that is not the default instance, you receive the following error message:
    Microsoft SQL Server with Service Pack 3 must be installed before configuring the sample database
    Note You may receive this error message even if you have Microsoft SQL Server Service Pack 3 (SP3) or a later service pack installed on the computer.
  • The Project Sample Data Configuration Wizard installs the sample database to the default local MSSQL instance of SQL Server.

    For example, the Project Sample Data Configuration Wizard creates the sample database in the following folder:

    Program Files\Microsoft SQL Server\MSSLQ\Data\MSPSampleDatabase

    However, the default MSSQL named instance of SQL Server is not used. The Project Sample Data Configuration Wizard does not install the sample database in the named instance of SQL Server.

CAUSE

This behavior occurs because the Project Sample Data Configuration Wizard cannot restore the data to a named instance of SQL Server.

WORKAROUND

To work around this issue, run the Project Sample Data Configuration Wizard on a SQL Server that does not use named instances.

To use the sample database in a named instance of SQL Server, you must manually restore the database. The sample database is a file named SAMPPROJ.BAK. This sample database file is located on the Project Server 2003 installation CD, in the following folder:

\SUPPORT\SAMPLE\1033\SAMPPROJ.BAK

For more information about how to manually restore the database, click the following article number to view the article in the Microsoft Knowledge Base:

323330 How to back up, schedule, and restore a Microsoft Project Server database

After you manually restore the database, follow these steps to complete the process so that you can use the sample database in a named instance of SQL Server:
  1. Use the Site Editor tool (Editsite.exe) to configure a new Microsoft Internet Information Services virtual directory.

    For more information, click the following article number to view the article in the Microsoft Knowledge Base:

    823529 How to use the Site Editor tool to create multiple Microsoft Project Web Access Web sites for Project Server 2003

  2. Set up and configure Microsoft Windows SharePoint Services.

    For more information about how to set up and to configure Windows SharePoint Services, see chapter 6 of the Managing Windows SharePoint Services in the Project Server 2003 Administrator's Guide. To download the this guide, visit the following Microsoft Web site:

    http://www.microsoft.com/downloads/details.aspx?FamilyID=2f446940-147b-447a-b0d3-6088673a53a4&displaylang=en

Modification Type:MinorLast Reviewed:7/27/2006
Keywords:kbImport kbDatabase kberrmsg kbUser kbSecurity kbMiscTools kbprb kbtshoot KB897767 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.