SQL Licensing question need answers

Posted on 2008-06-25
Medium Priority
Last Modified: 2010-03-19
this is a licensing question on SQL Workgroup & Standard edition
Company currently using SQL EXPRESS 2005 EDITION & doesn't require user CAL (database below 4GB space)

I was so confused after reviewing / reading document download from microsoft website
Beside, worry about buying the wrong type of software & licenses.
Company running SBS2003 - 1 processor, 4Gram & raid-10. in our database department, 5 employees and will hire 2 more in 3 to 6 months

we want to buy a SQL License that don't have to worry about upgrades in the future except to add CAL

it would be ideal if the SQL software / licenses (CAL) can also be relocate to another server in the future for better / greater security, performances (2 processors)

there are SQL / processor license / workgroup license / standard license
Level A, B, C & D licenses / per device - cal licenses / open license / select license I.e
(and more...)

sorry i didn't mean to confuses all your reader who try to help! my advance apology.


please point me to the right direction so i don't have to go beg for more budget from accounting coworker

thanks in advance!@

Question by:samntlam
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 13

Expert Comment

ID: 21874646
If you upgrade to SBS2003 R2 Premium edition this will come with SQL2005 Workgroup edition built in, and will have the same number of CAL as your Windows Server.

Author Comment

ID: 21879269
yes it's true.
but if already using sbs2003 standard - to buy sbs2003 premium ($999) & upgrade by running only the SQL Workgroup edition module in the DVD instead of buy workgroup edition for $699?

thanks for your comment - suggestion.
LVL 13

Expert Comment

ID: 21881792
You can get upgrades from SBS2003 Standard to SBS2003 Premium, but you also mentioned that the software may be moved later to another machine, so in this case you are probably best buying the standalone.  You are not really at the number of users where you need a processor licence, unless of course you are writing some web apps will may be hit by many users.

I think when you buy SQL2005 Standard it will usually come with 5 CAL's, so then you just need to pick up another 5 pack to allow for your expansion.  One consideration here is do you want User or Device CALs.  Device CALs will allow the 5 machines to connect to SQL, User CALs will allow 5 Users to connect to SQL from any machine.  So it just depends on if your users will be using the same machines, or working from Laptops/Home etc.

If you are looking to save money there is plenty of genuine software on eBay if you look at sellers with a good record. I have bought genuine Windows Server and SQL2005 from eBay before.

PS. You will gain more performance by adding RAM, rather than going for a dual CPU as SQL just loves RAM.  If you could go straight to the second server now then you would be able to go for 64-bit, which has much better memory usage when you have 4gb+.  If I were setting up new servers now I would always go wth the 64bit.

Author Comment

ID: 21888366
that's a very detail comment-suggestion. I really appreciated!
we are no where near writing any web apps! only to use for database / production usages (not for web - online)

you're absolutely right (about SQL standard w/5 CAL scenario)
the hesitation to buy standard is maintenance! we have no budget hiring one! so, if workgroup make it simple and easy for this manufacture... that's the way to go. Since we have a very simple database (ERP) just want to grow & increase in spaces (LOL)

is there going to more work - time to spend on the SQL standard instead of workgroup?

Of course, I will have to drop that "moving" SQL software - license fantasy from one server to another!

but Rick, I am still confused on device vs. user CAL! I can't figure out how device CALs works but I think the 2nd one should do the trick!

I just need one more piece of information from you... if you don't mind.
the SQL Workgroup w/5 users CAL and any more adding on... it (they) will not be able to transfer - moving to another server if we plan to buy a HP / DELL server???

I don't think I have the Guts & courage to buy from ebay.com. Hmm... I am not sure...
your last comment - suggestion really help me allot! (RAM & more RAM)

will you give me some more advice / answer in my question?

LVL 13

Accepted Solution

rickchild earned 2000 total points
ID: 21897850
There is no additional work in using SQL Standard, Workgroup just supports fewer features and only uses 2 Processor / 3GB RAM.  Standard version uses 4 CPU and unlimited RAM.  I would go for Standard Edition.

I guess you are unable to go 64Bit as your SBS2003 is already in use, it would still be nice if you could set up a new server with Windows 2003 Server 64bit, and SQL2005 Standard 64bit.

You will be able to move the Licence to a new server with the Standard Edition, not sure about workgroup but I don't see why not if you have bought it standalone.

Device CAL means that the SQL will allow any 5 computers to access the database concurrently, User CAL means that any 5 Users can access concurrently.  So if you are always running from dev machines in the office, I would get the device CAL.  If people are accessing from Laptops or from home, I would get the User CAL.  When you buy a new copy you can choose here if you want User or Device CAL anway, but when you buy the additional CAL you must specify.  I think you can also mix anyway.

Yes you will be able to transfer SQL to a new server later, but if that is the plan I woudl push to do it now.  It will save you hassle transferring later, and also allow you to get 64bit.

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

765 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