SQL Server 2005 license


  • We are planing to deploy 3 SQL Server instances on 2 node cluster setup. All 3 instance will run one either one node 1 or node2 or some on node 1 & some on node2. We are having 8 physical processor servers

    1) Please help in understanding the requirement of licenses

    2) Is the license requirement same for enterprise & standard edition


    Rohit Garg

    Tuesday, July 12, 2011 4:05 AM


  • If you have an active/passive setup you can get away with licensing only the active node, as I recall you get 30 days or so post failover before you need a license on the passive node. In the case you describe above you will need to license both nodes since you have an "active/active" setup. You need to investigate the official licensing documentation to decide whether you use per processor or per user cal etc. You may also want to revisit your hardware selection regarding number of processors (8 in your case) since this can have a major effect on licensing cost.

    Regarding editions standard edition and enterprise edition are completely different licenses, you cannot purchase a standard edition license and run enterprise edition, you will want to get quotes and then decide whether the additional enterprise features exceed your cost/benefit threshold. There is a lot of info. on the web or you can talk to Microsoft/your licensing provider for more info. Assuming you are looking at SQL Server 2008 R2 have a look at the following for an idea of price and also see the other documents linked to at the bottom...



    /Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005/2008), MCAD, ITILv3, OCA 11g) Please click the Mark as Answer button if a post solves your problem
    • Marked as answer by RohitGarg Wednesday, September 05, 2012 2:54 PM
    Tuesday, July 12, 2011 4:24 AM