samntlam
asked on
SQL Licensing question need answers
Hi:
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
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
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.
http://www.cdw.com/shop/search/results.aspx?key=SQL+standard&platform=All&sr=1&Find+it.x=0&Find+it.y=0
please point me to the right direction so i don't have to go beg for more budget from accounting coworker
thanks in advance!@
Sam
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
http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx
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.
http://www.cdw.com/shop/search/results.aspx?key=SQL+standard&platform=All&sr=1&Find+it.x=0&Find+it.y=0
please point me to the right direction so i don't have to go beg for more budget from accounting coworker
thanks in advance!@
Sam
rickchild
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.
ASKER
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.
sam
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.
sam
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.
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.
ASKER
Rickchild:
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?
please....
thanks!
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?
please....
thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.