Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
What SQL Version to buy?

Respondida What SQL Version to buy?

  • Tuesday, October 09, 2012 12:54 PM
     
     
    Sign In to Vote
    0

    Hi there. Sorry but most of the posts I've read regarding buying a version of SQL are over 5 years old!

    So... here's my question(s). I've developed a Windows (Access ADP) application for a customer of mine and now they need to purchase a version of SQL that I can install it on. I've been thinking that SQL Server 2008 R2 Standard Edition woulld work best for them. They are a small-medium company with 15+ users, 3 remote connections to Head Office. They will have a Windows 2003 Server with some power to HOST the SQL server. So here are my questions.

    1) Should I have them purchase SQL Server 2008 R2 Standard Edition or SQL 2012? (I've developed on SQL 2008 R2)

    2) What does this mean:It will be priced at $7,499 per processor or $1,849 per server with five CALs?

    3) Why is it that I can find "Microsoft SQL Server 2008 Standard Full Version Retail DVD & Key (Promotional)" for $699? Is that a good price and is that a full upgradable version of SQL 2008 R2? Other sites to purchase SQL 2008 Standard have it listed at somewhere around $4000?????

    I don't think my customer is willing to shell out thousand of dollars for SQL but $699 to $1000 they will. So what direct should I go?

    Thanks Dweezil

    Dweezil

     

All Replies

  • Tuesday, October 09, 2012 1:09 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    1. Windows Server 2003 is not supported by SQL Server 2012. Please buy SQL Server 2008 R2.

    2. Not sure you still can buy SQL Server 2008. Please contact Microsoft Licensing at 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. You can also visit the following site for more information and support on licensing issues:

    http://www.microsoft.com/licensing/mla/default.aspx

    3. Please contact Microsoft Licensing about pricing. Consider Workgroup Edition also.

    http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com

     
  • Tuesday, October 09, 2012 1:38 PM
     
     
    Sign In to Vote
    0

    Thanks Alberto. Still have questions. Ok, if using Windows Server 2003 do not get SQL Server 2012. Good to know.

    As for buying SQL 2008 R2 Standard Edition, there are tons of sites that are selling it?? That's why I'm asking what a typical price is. Are you saying all these software retail selling sites are selling SQL versions that are not usable (Licenseable)? Sorry but the Microsoft License advisory does not list SQL 2008? Will the SQL 2008 R2 Workgroup edition allow the number of remote connects my customer requires? Will my customer be looking at $7500 for a per processor license?

    Again, lots of questions but no real answers to give my customer.

    Dweezil

    Dweezil

     
  • Tuesday, October 09, 2012 2:21 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    Workgroup Edition can handle a maximum of 32, 767 user connections.

    It seems the price for Workgroup Edition (5 Client Access Licences included) is $800 more or less. You may need to add a few CAL licenses to that price.

    http://www.microsoftstore.com/store/msstore/en_US/pd/SQL-Server-2008-R2-Workgroup-Edition-32bit-5-Client-Access-Licenses/productID.216598800

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com


     
  • Tuesday, October 09, 2012 4:21 PM
     
     
    Sign In to Vote
    0

    Thanks again Alberto.

    I have one more dum question. What does it mean when Workgroup Edition can handle 32767 connections but I can buy the software with 5 CALS. Does that mean I have to buy a CAL License for every user that will have a connection to my database? Do the 5 CALS refer to someone using SQL Server Management Studio to do design work? If I use SQL Server to hold a database that is used to collect information from a WEB FORM do I need a license for every possible user of the WEB FORM? Sorry but I'm a little unclear as to what a CAL license is?

    As for the link you sent me, it says Workgroup Edition but shows an image for the Enterprize Edition?? Also I can buy the Standard Edition with 5 CALS for $699. Is that what I should go for?

    Thanks

    Dweezil

     
  • Tuesday, October 09, 2012 4:43 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hello,

    I don’t know of any limitations on SQL Server about  user connections, and does not matter what edition. SQL Server does not keep track of licenses and CALs also.

    To my knowledge 1 user = 1 CAL, but is better you can confirm that with a Microsoft Licensing specialist since these forums are not intended to answer licensing questions. The following guide may help you understand the concept of CAL:

    http://blogs.msdn.com/b/mssmallbiz/archive/2007/11/06/5942350.aspx

    If you can buy a Standard Edition instead of the Workgroup Edition, better. Compare them by features supported using the following article:

    http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com


     
  • Tuesday, October 09, 2012 5:44 PM
     
     Answered
    Sign In to Vote
    0
    Thanks

    Dweezil

    • Marked As Answer by Programmer Guy Tuesday, October 09, 2012 5:44 PM
    •