SQL Server Requirements (Standare or Enterprise)

Question

We are unable to install Project Server 2010 on our Server due to we are using the Standard version of SQL Server 2012 instead of the Enterprise version. The error relates to database partitioning of the Web Analytics Service Application is not supported on the SQL Server Standard Edition which we are using. My question is, is it true then that we need to use SQL Server 2012 Enterprise Edition to load Project Server 2010?

Thanks for your reply.

Rick

Answer 1

Rick,

Project Server 2010 Service Pack 1 updates must be installed to your Project Server 2010 installations in your farm in order to use SQL Server 2012 to host your farm databases.

Ref : http://technet.microsoft.com/en-us/library/ee683978(v=office.14).aspx#section8

---

Hrishi Deshpande Senior Consultant

Answer 2

Hrishi,

Thanks for your reply.  We are unable to install Project Server 2010 on the Server.  Will the Project Server 2010 Service Pack 1 install without installing Project Server 2010 Server first?

Answer 3

Yes, you need to use Project server installable with Sp1 or you can slipstream SP1 update with RTM version of Project Server installable.

Are you planning to install Standalone or Complete install of SharePoint farm to support Project Server?

---

Hrishi Deshpande Senior Consultant

Answer 4

We have Complete install of SharePoint farm already installed

Answer 5

Well in that case, install SP1 for SharePoint, Cancel SharePoint Configuration wizard and then install Project Server with SP1. Run SharePoint Configuration Wizard

In your first post you have mentioned about Web Analytics Service Application  error, are you seeing this error while installing Project Server?

---

Hrishi Deshpande Senior Consultant

Answer 6

No not specifically. The install for Project server failed and informed us to check the logs.  But since there was an error on Web Analytics Service Application, we wanted to address that problem first which might fix the problem of loading Project.  We did not write the name of the log file when Project gave us the error.  So wright now we are also unable to go back to the error log.