[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

656 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