SQL Licensing question need answers

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!@

Who is Participating?

Improve company productivity with a Business Account.Sign Up

rickchildConnect With a Mentor Commented:
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.
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.
samntlamAuthor Commented:
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.
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.
samntlamAuthor Commented:
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?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.