locked
SQL 2008 Standard Licence for Sharepoint 2010 foundation RRS feed

  • Question

  • Hello!

    We want setup sharepoint 2010 foundation with an SQL 2008 Standard.
    The expected amount of data are about 40 GB or more. This the reason why we can't use SQL Express 2008 R2.

    What Licencemodel is necessary ?
    - Do we need an Processorlicence, is concurrent ok or need only the Sharpoint Server a Licence for access the database.

    thank's in advance

    Christian

     

    Tuesday, August 31, 2010 11:10 AM

Answers

  • Hi Chris,
     
    the best place to go is http://microsoft.com/licensing/mla, MLA will let you choose the scenarios of product mixees and CALs to see what work best for you.... However, if you split the site into multiple site collections you can then use multiple content Dbs..
     
    You will nee at least the following:
     
    Windows Server License for SharePoint and SQL, plus user CALs for the users or devices connecting to Windows server, SQL Allows you to purchase processor Licenses and this is usually less expensive..
     
     
    -Ivan
     

    Hello!

    We want setup sharepoint 2010 foundation with an SQL 2008 Standard.
    The expected amount of data are about 40 GB or more. This the reason why we can't use SQL Express 2008 R2.

    What Licencemodel is necessary ?
    - Do we need an Processorlicence, is concurrent ok or need only the Sharpoint Server a Licence for access the database.

    thank's in advance

    Christian

     


    Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.
    Tuesday, August 31, 2010 11:34 AM

All replies

  • Hi Chris,
     
    the best place to go is http://microsoft.com/licensing/mla, MLA will let you choose the scenarios of product mixees and CALs to see what work best for you.... However, if you split the site into multiple site collections you can then use multiple content Dbs..
     
    You will nee at least the following:
     
    Windows Server License for SharePoint and SQL, plus user CALs for the users or devices connecting to Windows server, SQL Allows you to purchase processor Licenses and this is usually less expensive..
     
     
    -Ivan
     

    Hello!

    We want setup sharepoint 2010 foundation with an SQL 2008 Standard.
    The expected amount of data are about 40 GB or more. This the reason why we can't use SQL Express 2008 R2.

    What Licencemodel is necessary ?
    - Do we need an Processorlicence, is concurrent ok or need only the Sharpoint Server a Licence for access the database.

    thank's in advance

    Christian

     


    Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.
    Tuesday, August 31, 2010 11:34 AM
  • Aother way of looking at it is that as far as SQL Server usage is concerned, the fact that it is SharePoint that is using the SQL Server copy is totally irrelevant.

    You need to license SQL Server in one of the normal ways. So for instance corporate licensing is one and CALs *for all users* who can access the SharePoint site and thus access the SQL Server database is another.

    Just put the possibility out of your mind that SQL Server has only one user (the SharePoint system) and thus you only need a version of licensing with a minimal number of CALs. That isn't how licensing works at all!  (It's usually the reason why people ask, though ...). You need to be licensed for all users of the SP site.

    But the main thing is that to be one hundred percent correct on SharePoint licensing, always ask a Microsoft licensing specialist and get his reply in writing. Then you can proceed with a solid basis. Ivan's link is OK but it's not as clear (and safe) as an answer you might get from a MS licensing specialist.

     

    (Note that the above was only about the SQL Server part of the equation. As Ivan also says there is also the need to license the server)


    2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc.
    2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow
    Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
    Tuesday, August 31, 2010 6:08 PM
  • Hello Ivan, Hello Mike!

    Thanks for Answers!

    I think we will buy a Processorlicence or we try it with the New RBS Feature in SQL R2 and Sharepoint 2010

    Greetings

    Christian

    Wednesday, September 1, 2010 12:43 PM
  • Christian,

    I agree with both Mike's and Ivan's answers. One think to remember on the RBS. If you are considering using RBS on remote server you will need Enterprise version of MSSQL2008. See attached link. http://technet.microsoft.com/en-us/library/ee748607.aspx

     

    Regards


    Ivan Bondy - MCPD, MCDBA, MCSA, MCTS - Sharepoint consultant
    Wednesday, September 1, 2010 7:18 PM