Post reply

Licensing standalone SSRS (2008 R2 or 20012)

  • June 24, 2013 at 4:16 pm

    #294979

    Hi Guys

    We currently run 2008 R2 and SSRS (not sharepoint) on a 4 core VM, so license is around $8K. We have more and more needs for data driven subscriptions, but can't justify upgrading to enterprise version on 4 core machine ($28k). I was thinking that spinning up a dedicated VM for SSRS with a single core and running enterprise version of SQL Server would get us what we need fro about $8K (SQL and WIn licenses) -- we have enough RAM

    I've read that having SSRS on a dedicated box improves performance too.

    So would this work if we offloaded all of our SSRS to a new single core VM? Can you buy just an Enterprise SSRS licenses or must you always buy it with SQL server?

    I've scoured the web, but couldn't find an answer

    BTW, we own SQL2012 licenses, can't use it yet because of 3rd part app compatibility, but I figured if we went this route we could use some of the new features of SSRS 2012 with 2008 R2 data sources

    Thanks

    Mark

  • June 24, 2013 at 7:29 pm

    #1626965

    You have to buy SQL Server. SSRS is not sold as a separate product.

  • June 25, 2013 at 4:19 am

    #1627048

    http://msdn.microsoft.com/en-us/library/ms143703(v=sql.90).aspx

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • June 26, 2013 at 6:18 am

    #1627513

    If your licences are under Software Assurance then you are bound by the SQL 2012 licensing rules even if you are running an older version of SQL Server.

    You have to license at least 4 cores, even on a server that only has 1 core, so there are NO license cost savings from reducing the core count below 4.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply