Solved

SQL Server 2012 and how many licenses are needed with IIS

Posted on 2014-03-19
3
2,878 Views
Last Modified: 2014-03-19
Hi,

i am totally confused at the moment. We have a CRM-System that is web-based. So 15 USers open a Website, hosted on our local SBS2011 to access and use the crm-system.
This crm connects to local SQL-Server 2012 (express at the moment) with data stored in it.

Because of poor performance the programmer of the crm told us, that we should take the SQL Server 2012 and not the express-version.

So we have the same server machine with SQL, IIS and Server os on it. The only way the SQL is used and accessed is via the iis.

Question: How many SQL-CALs do i need ?

a) 1 Device-CAL for this Server
b) 1 User-CAL for the IIS-User
c) 15 User-CALs for the 15 users that are using the IIS (And SQL behind it ?

Thanks in advance

loosain
0
Comment
Question by:loosain
3 Comments
 
LVL 52

Assisted Solution

by:Carl Tawn
Carl Tawn earned 250 total points
ID: 39939488
You'll need one server licence (for the SQL Server itself) and 15 CAL licences - one for each of the users (i.e. physical people) who can access the database (albeit via a app).

You don't need a CAL for the IIS user as it is the means by which you access the SQL Server, rather than being a physical user itself.
0
 
LVL 29

Accepted Solution

by:
Feridun Kadir earned 250 total points
ID: 39939497
SQL Server can be licensed by user or processor. If you license per processor then you need not be concerned with the number of users. However you might find the processor pricing more expensive than per user pricing for 15users.

For per user pricing you must buy a CAL for each user that will access the SQL Server regardless of how that access occurs.

A user CAL covers a user regardless of the machine from which they access the SQL database
A device CAL covers a single machine (PC, laptop or tablet) regardless of the users that use that machine.

The fact that access is via IIS is I think irrelevant so you need 15 user CALs.

Generally user CALs are the way to go, unless you only have say 10 computers for the 15 users. In this case go for 10 device CALs.
0
 

Author Closing Comment

by:loosain
ID: 39939519
Thats exactly waht i thought it would be. But it is nice to know thar experts say it the same way, i guessed it.

Thanks (and very quick answers....).
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now