Why use SQL Server 2005 over SQL Server 2000 with Project Server 2007?

A

anovak

Any reason to use SQL Server 2005 over SQL Server 2000 for Project
Server 2007?

Functional advantages?

Technical Advantages?

Thanks
Andy
 
S

Scott Wagner [MCP, MVP]

anovak,

Farm installation requires SQL Server 2000 SP3a or higher.
MS Quote:

"SQL 2005 SP1 or later and SQL 2005 Analysis Services SP1 or later required
for some advanced features."

The OLAP Cube from Analysis services and enhancements from Reporting
Services under 2005 are significant not to mention many other features in
the base SQL 2005 server product. I would go with 2005 if at all possible.

Thanks,

--
Scott M. Wagner [MVP]
Vice President of Professional Services
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We write the books on Project Server"
 
Top