I have done a couple of posts on licensing SQL Server before , but I just got off the phone from my good friend and MVP Simon Sabin and I realised I need to clear up the issues around Report Builder 2 licensing.
Simon has noticed that you can build reports (which are stored as .RDL) files and run these reports in Report Builder 2 on a standalone machine without any reference to a SQL Server:
However this doesn’t get around the fact that you have to be licensed to connect to SQL Server to use these tools , and this is made quite clear (well I understood it) in the licensing screen that comes up when you install Report Builder from the install file..
Microsoft SQL Server 2008 Report Builder 2.0 for SQL Server 2008 PLEASE NOTE: Microsoft Corporation (or based on where you live, one of its affiliates) licenses this supplement to you as part of and for use with your validly licensed copy of the Microsoft SQL Server 2008 software (for which this supplement is applicable) (the “software”). This supplement is part of the “additional software” and the license terms for the software apply to your use of this supplement. You may not use this supplement if you do not have a license for the software. The term “software” does not include Microsoft SQL Server 2008 Express or SQL Server 2008 Express Advanced Editions.
I have to say that even if this wasn’t a license violation it would be a messy implementation with users saving report definitions (the rdl files to a share) with each having it’s own connection string all of which would make for a lot of management, a few security headaches and a rather poor user experience all for the cost of copy of SQL Server standard.
For detailed queries on this or any licensing question please contact Emma Healey (aka “Lady Licensing”)
Hello, great article. So, if I have a license for SQL 2005 i can't use report builder 2.0 right??? :-(.
Report 1.0 sucks if you compare it with the 2.0 version...
Report Builder 2 will create rdl that SQ:L Sderver 2005 won't understand, because of the new charts, tablix data region and rendering chnages.
Report Builder 1 was perhaps too end user orientated at the expnse of functionality.
BTW Report Builder 3 only works with SQL Server 2008 R2 as ther are further chnages to the rdl schema again, e.g. maps and rpoert parts.
I can only politely suggest that it might be time to upgrade