Article ID: 321336 - View products that this article applies to.
This article was previously published under Q321336
Microsoft Project Server supports Microsoft SQL Server 2000 and Microsoft Database Engine (MSDE) 2000 or later. To use the enterprise features of Microsoft Project Professional and Microsoft Project Server, you must use SQL Server 2000.
SQL Server 2000 is available in several different editions, including the following:
If you want to view Portfolio Analyzer reports from the extranet, the advanced analysis features of SQL Server 2000 Enterprise Edition are required.
Microsoft Project Server does not support Oracle as a database. Microsoft Project Server requires SQL Server to use the Online Analytical Processing (OLAP) Analysis feature and stored procedures.
However, you can use Oracle databases with Microsoft Project Server if WorkGroup is defined as Microsoft Project 2000 and Microsoft Project Server, or Microsoft Project Standard and Microsoft Project Server together. Users of Microsoft Project 2000 and Microsoft Project Standard can publish projects to Microsoft Project Server.
Note that the Microsoft Project Server database requires Microsoft SQL Server; however, users can also save their original projects to an Oracle database server.
In Enterprise Mode (Microsoft Project Professional and Microsoft Project Server), Microsoft Project Professional users typically save their projects to the Microsoft Project Server database, so that their projects are saved in Microsoft SQL Server 2000.
For more information about Microsoft Project Server database architecture and extensibility, visit the following Microsoft Web site:
Microsoft Project Server 2002 Architecture and ExtensibilityFor additional information about the minimum system requirements for Microsoft Project Server, click the article number below to view the article in the Microsoft Knowledge Base:
321392For more information about SQL Server 2000, visit the following Microsoft Web site:
(http://support.microsoft.com/kb/321392/EN-US/ )PRJ2002: Minimum System Requirements for Microsoft Project Server and Microsoft Project Web Access
Microsoft SQL Server Home PageFor more information about the differences between the editions of SQL Server 2000, visit the following Microsoft Web site:
Features Supported by the Editions of SQL Server 2000
Contact us for more help
Connect with Answer Desk for expert help.