Solved

SQL liscences for applications

Posted on 2014-03-18
12
225 Views
Last Modified: 2014-03-25
*as a general rule* do applications with a backed SQL Server require a CAL for every user using the SQL database, regardless of whether each user has an account in the database or not? Some apps may just have a shared account that accessed the database from the appliation, and therefore no user is directly logging in/accessing the database, but they are still using it via the application. What are the rules? Does it depend on how the application and database interact?
0
Comment
Question by:pma111
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 250 total points
ID: 39936718
It depends on your usage. You can licence the SQL Server either on a User CAL basis, which  requires one licence per user who will access the server, or you licence the server (based on processing cores nowadays). The latter is more appropriate if you have, say, a web application that will be accessed by a large, or possibly unknown, number of users.
0
 

Expert Comment

by:desperadomar
ID: 39936772
I hope the user here furnished is the login right?
0
 
LVL 3

Author Comment

by:pma111
ID: 39936799
Not too sure what you mean by furnished?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 3

Author Comment

by:pma111
ID: 39936800
>which  requires one licence per user who will access the server

How about if you access the application, which accesses the application, via a common account, is that then 1 CAL required, or if you have 200 users using the application, is that 200 CAL's required?
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39936862
That would still be 200 CALs - it is still 200 physical users accessing the SQL Server. But if you have that many users then a server licence will probably be cheaper than CAL licences anyway.
0
 

Expert Comment

by:desperadomar
ID: 39936870
I  believe each CAL means a login in sql server not user in database
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 39938564
I  believe each CAL means a Login in Sql Server not user in database
No.  It has nothing to do with SQL Server Logins.  It has to do with client users (not database users) connecting to the server.  In other words, supposing you have a web app with 1000 users, but only 2 SQL Server Logins in SQL Server (one admin account and one SQL Server Login for the web app).  Then you would have to be licensed for 1000 users not 2, whether that is with CALs or per CPU is up to you.
0
 
LVL 3

Author Comment

by:pma111
ID: 39939285
could you give rought prices for single CAL and single core liscences? I see you hinted at processor liscences making more sense given the user base, can you elaborate slightly why CAL's may be more cost effective in some cases, and processor liscences more cost effective in other cases?
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39939294
Ballpark prices are:

Core license: $1793 per core (4 core minimum)

Server+CAL: $898 for the server + $209 per CAL

But, as always with these things, you'd be best to talk to Microsoft direct and they can suggest the most cost-effective licencing model for your specific usage requirements.
0
 
LVL 3

Author Comment

by:pma111
ID: 39942238
So with the core liscence, you dont have to worry about CAL's?

I cant see much of a case for not using the core liscence then given the cost of CAL's? Or where CAL's would ever be more cost effective given that anything more than a few users will cost more than a core liscence?
0
 
LVL 3

Author Comment

by:pma111
ID: 39942241
Ah that was per core not per server..
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39942330
It basically comes down to your usage. Core licences are roughly $1793 each (so minimum $7200-ish given that you have to buy them in packs of 4), or $898 for a server plus CALs.

So basically once you get to about 30 users you start to get in to the territory where Core licencing  is more cost effective. If you are hosting a website or something the Core licensing is a no brainer; whereas if you think your user base may grow in the future then Core licenses from the outset may prove cheaper in the long run than buying additional CALs as and when needed.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

839 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