Solved

SQL liscences for applications

Posted on 2014-03-18
12
222 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
 
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
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 Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

760 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

17 Experts available now in Live!

Get 1:1 Help Now