SQL Server Reporting Services for embedded reports for Oracle without SQL Server License

  • I have a WCF4/MVC3 product, and I need a reporting solution for it. I'm considering using SQL Server Reporting Services for this purpose. My product is compatible with both SQL Server and Oracle, and I would like to know if I have a customer that does not own a single SQL Server license, and uses only Oracle, can this customer legally use my embedded reports?

    I know I can run Reporting Services against an Oracle data source, and I know that I can embed Reports into my web product. My questions is really about the legal implications of a customer without a SQL Server license to use Reporting Services against an Oracle database

  • No, if you want to use SSRS you need to have the correct SQL license, there is no way around it.

    Your looking at around a minimum license cost of $7200 for 4 SQL 2012 Standard Edition Core licenses.

  • Isn't the Reporting Services Runtime free to use and distribute? I won't use the Reporting Services portal that comes with SQL Server, nor will the customer develop reports. I would ship the report, and use it as an embedded report.

  • If your not installing SSRS anywhere then you dont need licenses, if your using the reportviewer controlls within VS and providing a rdlc file and not using the portal or letting the users develop then you should be ok. It will have to all be configured in local processing mode

    http://msdn.microsoft.com/en-us/library/ms251704%28v=vs.80%29.aspx

    But as with all things licensing, speak to MS, dont take what we say as gold, best get it from the horses mouth.

  • Yes, that's my idea. 95% of my customers are SQL Server, but I can't ignore the 5% that uses only Oracle, because they are important customers, and they do not own SQL Server Licenses, and use my product as-is. Normally, if my customer needs a new report, they hire as to do so, since they do not know all the database layout, etc..

    This would work for a web-based reports as well, correct? I'm using WCF4 as the back-end, and MVC3 for the front-end.

    Thanks for the info.

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

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