?
Solved

SSRS, Visual Studio 2010 open/subscription web site

Posted on 2011-10-21
8
Medium Priority
?
322 Views
Last Modified: 2012-05-12
Hi experts,
I need to get an estimate of what are the licensing costs involved in building a website with Visual Studio 2010 that will be used to visualize SSRS 2008 reports using the Report Viewer element. This would be a website that would have some pages open to the public and some pages accesible via subscription.

Anyone knows what the licensing costs are for SSRS 2008? Are there any other licensing costs that I need to take into consideration?

Thanks in advance and regards.
0
Comment
Question by:robespierre_2010
  • 4
  • 4
8 Comments
 
LVL 21

Accepted Solution

by:
JestersGrind earned 1000 total points
ID: 37008795
The answer is: it depends.  Depends on how you plan on configuring SSRS, single server or multiple servers.  CALs or per processor.  Here are some documents that should help you out.

This is a good thread on different configurations and the licensing implications
http://social.technet.microsoft.com/Forums/en/sqlreportingservices/thread/b72a7de3-70ff-479f-a120-e72a803a344c

The official SQL Server licensing page
http://www.microsoft.com/sqlserver/en/us/get-sql-server.aspx

Greg

0
 

Author Comment

by:robespierre_2010
ID: 37008980
Hi,

Thanks for your quick response.

I will try to be more precise:
For instance, if I was to purchase one "SQL Server 2008 R2 Standard Edition 32-bit (10 Client Access Licenses)", would I be able to use it in the way that I have described in my original question? (i.e., create reports with a single, or up to ten users, and having public websites with server reports integrated in them)

Thanks again and regards.
0
 

Author Comment

by:robespierre_2010
ID: 37008992
By the way, this license "SQL Server 2008 R2 Standard Edition 32-bit (10 Client Access Licenses)" sells for $2,699.00 and my understanding is it includes 10 CALS.

Does that mean that 10 users can create and publish reports? Can a website freely access those reports created by those ten users?
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
LVL 21

Expert Comment

by:JestersGrind
ID: 37008995
Yes, my understanding is a valid SQL Server license gives you Reporting Services as well.  No additional licensing is required.

Greg

0
 
LVL 21

Expert Comment

by:JestersGrind
ID: 37009056
Licensing with CALs is per user that is accessing the data, so that means one for every user that uses your web application.  Per Processor is probably a better way to go if a lot of users are viewing the reports.

Greg

0
 

Author Comment

by:robespierre_2010
ID: 37009114
Well, that is my main doubt: From my brief experience building a website that has a reportviewer web part embedded, I tend to think that the website is considered as one single user, no matter who or from where is accessing the website...because the credentials are specified once, at the web.config, so they should be independent from who or from where accesses the website...but I am still not clear about it
0
 
LVL 21

Expert Comment

by:JestersGrind
ID: 37009129
I totally agree with you.  Unfortunately, Microsoft doesn't see it that way.

Greg

0
 

Author Closing Comment

by:robespierre_2010
ID: 37011144
Thanks for the links.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…
Suggested Courses
Course of the Month15 days, 17 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question