Solved

SQL Server 2005 Licencing Cal or Device?

Posted on 2007-03-29
9
868 Views
Last Modified: 2012-06-22
Hi Experts,

I wanted to get the difference between a 1 user cal and a 1 device cal for SQL Server 2005. in particular if we have 2 users connecting to a SQL Server each from there own Pc's, what licence do we buy. There is no web involved here. Also, If we get a third person in a years time how do we buy an additional licence? The reason I ask ths is because, I can buy for under AUD$300 a 1 user Cal or a 1 Device Cal, but then a 5 user licence jumps to over AUD$1,500 ???

many thanks
0
Comment
Question by:Manya70
  • 2
  • 2
  • 2
  • +2
9 Comments
 
LVL 13

Expert Comment

by:Atlanta_Mike
ID: 18821413
Ok, here's a crazy question. If you only have two users hitting it, why not use SQL Server 2005 Express?
0
 

Author Comment

by:Manya70
ID: 18821563

Hi Thanks for the quick reply.

We need to use the integration Services and reporting services thats why we thought maybe the standard edition.

thanks
0
 
LVL 5

Expert Comment

by:MrNetic
ID: 18822376
Manya70, why don't you use a SQL SERVER HOSTING SOLUTION with a light montly fee ?

Hope it helps.

Best Regards,

Paulo Condeça.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 21

Expert Comment

by:Kevin3NF
ID: 18822974
Are you sure you even CAN buy just 1 or 2 users?  If so, then whoever sold it to you can just sell you the additional CALs that you need down the road...
0
 
LVL 13

Expert Comment

by:Atlanta_Mike
ID: 18823083
Yes, you are right if you need integration services you need at least Standard. MrNetic, there is no hosting solution I know of that will allow use of Integration Services.

Search the internet, I saw one price around $700 for SQL Server Standard and 5 cals.
0
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 18823156
Only dedicated servers, like those from GoDaddy (about $500 for a dedicated SQL box) will allow you outside of your databases to use options like SSIS, replication, etc.  Just confirming Atlanta_Mike's comment
0
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18824676
To answer your question:

User CAL - Number of simultaneous users can connect from any device
Device CAL- CAL is assigned to a specific device and any user who uses that device is licensed

From this URL http://www.microsoft.com/sql/howtobuy/faq.mspx#EZB

Q. What is the difference between device client access licenses (CALs) and user CALs?

A. A device CAL allows any number of users to gain access to licensed server software from a particular device. A user CAL lets a particular user gain access to licensed server software from any number of devices. In other words, a user CAL covers a particular user's access to the server software from work computers and laptops, as well as from home computers, handheld computers, Internet kiosks, and other devices. A device CAL covers access by multiple users to server software from a single, shared device.
 
So if the users are always going to access SQL Server from their own machine a device CAL may be appropriate. However, if you have multiple users who might connect from multiple devices then user CALs may be more appropriate.
0
 

Author Comment

by:Manya70
ID: 18833969


thanks rboyd56. I'am lot clearer on what we need.
thanks
0
 
LVL 16

Expert Comment

by:rboyd56
ID: 18836595
You're welcome
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Edit image captured by printScreen 4 21
Find results from sql within a time span 11 33
Query group by data in SQL Server - cursor? 3 34
Moving files from folder to folder 8 30
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

831 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