Microsoft KB Archive/897767

= You receive a &quot;Service Pack 3 must be installed&quot; error message when you use the Microsoft Office Project Server Sample Data Configuration Wizard in Project Server 2003 =

Article ID: 897767

Article Last Modified on 7/27/2006

-

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:  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

 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



Keywords: kbimport kbdatabase kberrmsg kbuser kbsecurity kbmisctools kbprb kbtshoot KB897767

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.