SQL Licensing question need answers

Posted on 2008-06-25
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
  • 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 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 500 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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

733 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