locked
SSRS licensing + deployment RRS feed

  • Question

  • Hi,

    I am deploying SQL Server Reporting Services (SSRS) on Windows 2008 as a pre-requisite for installing MS CRM.
    The client has seperate MS CRM and SQL Servers.

    I would like to deploy the web portion of SSRS to the MS CRM Server while pointing the SSRS database to the SQL Server. Can anyone confirm (and preferably provide a link) that the client will not require multiple licenses for SSRS?

    Many thanks.
    Karlo
    Karlo Swart - http://www.ver206.com
    Monday, January 25, 2010 9:14 AM

Answers

All replies

  • Hi Karlo,
    You will need only license for CRM server and clients. You don't need any additional license for SSRS connector and Exchange Email Router part. In most of installations SQL server with CRM databases is located on separate server. If you are a Microsoft Partner you can find Dynamics CRM licensing in the Partner Site.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Monday, January 25, 2010 9:39 AM
  • Hi Kgorczewski,

    I'm not too concerned about the SSRS Connector, but rather licensing for SSRS itself. Perhaps this is a question specific to SQL forums, but I'm sure MS CRM implementors must have dealt with this issue.

    The client has one license for SQL 2008, however they want to split the web portion of SSRS from the database portion of SSRS by installing the web portion on a seperate server (in this case the MS CRM server).

    Thanks,
    Karlo
    Karlo Swart - http://www.ver206.com
    Monday, January 25, 2010 10:16 AM
  • Hi Karlo,
    Check for example this link: http://weblogs.sqlteam.com/joew/archive/2009/02/17/60844.aspx

    it looks that you will need 2 licenses but to make sure you may ask in SQL groups: http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver

    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    • Marked as answer by Karlo Swart Monday, January 25, 2010 2:01 PM
    Monday, January 25, 2010 10:24 AM
  • Hi Kgorczewski,

    Thanks for the links, it seems you are correct. I will do some more digging as I can't see whyMS would have any issues with a split deployment, so will update if I find any additional information.

    Thanks,
    Karlo
    Karlo Swart - http://www.ver206.com
    Monday, January 25, 2010 2:01 PM