Project Server 2010 with Standard Version SQL Server 2008 R2 RRS feed

  • Question

  • Hi All,

    Can we do deployment of Project Server 2010 with MS SQL Server 2008 R2 Standard version for Production Environment? Is it recommedable or not?

    What all features we cannot leverage in MS EPM 2010 with Standard Version MS SQL Server 2008 R2 in comparison to SQL Server 2008 R2 Enterprise Version?

    Thanks in advance.

    Thanks. Warm Regards Badal Ratra
    Thursday, February 17, 2011 4:38 AM


All replies

  • Hi,

    SQL Server 2008 R2 Standard edition is supported for Project Server as outlined at http://technet.microsoft.com/en-us/library/ee683978.aspx#section8.

    Choosing the correct version however can be important from a scalability & availability perspective. Additionally some features such as PowerPivot are only available in Enterprise Edition. Microsoft publish a very useful white paper called SQL Server 2008 R2 and SharePoint 2010 Products: Better Together (white paper) (SharePoint Server 2010) http://go.microsoft.com/fwlink/?LinkID=187264 which discusses the different editions and their impact on SharePoint and ultimately Project Server.

    Hope this helps,

    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Thursday, February 17, 2011 5:19 AM
  • Hi Badal,


     I am also facing same issue, do you have any alternative solution for the same.



    Friday, March 4, 2011 10:35 AM
  • This is a toss up...

    While standard is cheaper obviously, your question should be how many users will be using the system? How many projects?

    Are you in a farm setup?  Here is the generic layout, that a consulting company will charge you alot to quote verbatim :)   


    Single server running everything?  3 server(web, app, db)?

    Do you want power pivot?   Do you have to run your sharepoint 2010 enterprise on the same DB server?

    Also don't forget about physical CPU count.  You can now get 12 core(single cpu from AMD) and you will only need one SQL licence.  You can save big bucks and afford the enterprise edition.

    Look hard at the editions because you don't want the boss later coming up going "HEY LETS GET Power Pivot!" and you are like WHOOPS!


    The big limitation with Standard is 64 gig, no power pivot, no partitioning, live indexing, compresssion and backup compression.  64 gig is a fair amount don't get me wrong...


    Monday, May 9, 2011 3:53 PM