+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
Windows Thread, MS SQL Licencing in Technical; I think I have this right but just want confirmation. We going to install a new server to host SIMS.net ...
  1. #1
    alan-d's Avatar
    Join Date
    Aug 2005
    Location
    Sutton Coldfield
    Posts
    2,421
    Thank Post
    360
    Thanked 258 Times in 189 Posts
    Rep Power
    76

    MS SQL Licencing

    I think I have this right but just want confirmation.

    We going to install a new server to host SIMS.net as the old one may struggle a bit with the SIMS upgrade later in the year.

    Anyway - Apart from installing and licencing Server 2003, am I right in saying that for MS SQL 2005 we need 1 x Processor licence and CALs for each client that accesses SIMS at any one time?

    or

    Can we just have 1 x processor licence as the clients don't actually access the MS SQL database directly but via SIMS.

    I believe the first option is correct but I can't understand MS licensing at the best of times and today is not a good day

  2. #2

    Join Date
    May 2006
    Posts
    159
    Thank Post
    5
    Thanked 10 Times in 5 Posts
    Rep Power
    19

    Re: MS SQL Licencing

    Sounds right - thats how we were advised and how we do it.

    Unless your server is dual processor, then you need 2 processor licenses, natch.

  3. #3

    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,554
    Thank Post
    59
    Thanked 359 Times in 279 Posts
    Blog Entries
    7
    Rep Power
    132

    Re: MS SQL Licencing

    There are two licensing models for SQL: Per CPU or CAL. If you buy CPU licences, you don't need CALs. The alternative is to buy the CAL licence (which is significantly less than the CPU one) plus buy the appropriate amount of CALs to go with it.

    Work out how many users are likely to be using the SQL Server and choose the one that is better value for you .

  4. #4

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: MS SQL Licencing

    if you're already on a volume licesing program like school agreement or select wouldn't it be cheaper to license by CAL as the ones for SQL are aleady included in the bundle.

  5. #5

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,779
    Thank Post
    960
    Thanked 1,378 Times in 842 Posts
    Blog Entries
    1
    Rep Power
    456

    Re: MS SQL Licencing

    How does the web serving figure into this?
    I have a site that has content in a MSSQL 2005 server. Only the iis account access that mssql. Assume I have 1 cal and nothing else accesses the sql.
    Does that mean I have to licence per web user that ever hits my site or license per user concurrently connected or do I just need the 1 cal as only 1 account is actually directly linking to the data?

  6. #6
    Midget's Avatar
    Join Date
    Oct 2006
    Location
    In a Server Room cutting through a forest of Cat5e
    Posts
    1,298
    Thank Post
    5
    Thanked 59 Times in 49 Posts
    Rep Power
    40

    Re: MS SQL Licencing

    SQLServer 2005 can have a CPU Licence without the need for CALs. We've just been looking into this and we got quoted ~£900.

  7. #7
    petectid's Avatar
    Join Date
    Jun 2005
    Posts
    298
    Thank Post
    2
    Thanked 15 Times in 13 Posts
    Rep Power
    21

    Re: MS SQL Licencing

    Quote Originally Posted by ZeroHour
    How does the web serving figure into this?
    I have a site that has content in a MSSQL 2005 server. Only the iis account access that mssql. Assume I have 1 cal and nothing else accesses the sql.
    Does that mean I have to licence per web user that ever hits my site or license per user concurrently connected or do I just need the 1 cal as only 1 account is actually directly linking to the data?
    This is why Microsoft has the CPU licence.

  8. #8

    ZeroHour's Avatar
    Join Date
    Dec 2005
    Location
    Edinburgh, Scotland
    Posts
    5,779
    Thank Post
    960
    Thanked 1,378 Times in 842 Posts
    Blog Entries
    1
    Rep Power
    456

    Re: MS SQL Licencing

    Yeh thought it may.
    What do they count as per cpu?
    I heard ms dont care about cores just physical cpu's?
    Does this policy apply for sql?

    Cheers for info btw

  9. #9

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,597
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183

    Re: MS SQL Licencing

    @ZeroHour: IIRC per 'CPU' is per 'physical CPU'. This counts for SQL too. If you have a single processor Quad Core then you need 1 license. If you have a 4-way single-processor box you get stung for 4 licenses. A bit tight if you ask me!

  10. #10
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,044
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52

    Re: MS SQL Licencing

    Per CPU is per physical CPU not per core.

    Prices I have (Pugh Nov 06):

    £114.4 for Standard SQL, plus £16 per CAL
    £740.8 for Standard SQL (1 CPU)

    So for a single CPU, if 40 or more CALs - licence per processor
    For 2 CPUs, if 85 or more CALs - licence per processor

    SQL CALs are extra under the schools agreement, not included in core CALs.

    For sims we are going the per processor route - 2 quad core, licence per processor for 150 users.

  11. #11

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,597
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183

    Re: MS SQL Licencing

    @steve: Dual-quad-core.... oooh! That will indeed fly.

  12. #12

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,381
    Thank Post
    525
    Thanked 2,615 Times in 2,021 Posts
    Blog Entries
    24
    Rep Power
    891

    Re: MS SQL Licencing

    Quote Originally Posted by steve
    SQL CALs are extra under the schools agreement, not included in core CALs.
    I was checking this today and they are included in the 'Core CALS' pack which is included in the Desktop suite. http://www.microsoft.com/Education/SA3Overview.mspx

  13. #13

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,597
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183

    Re: MS SQL Licencing

    Something else worth noting is the 'free' version of SQL.... SQL Express. This does have limitations (such as 4GB database size, single CPU limit and 1GB memory limit) but may be sufficient for tiny schools or for use with web apps. Check out http://www.microsoft.com/sql/prodinf...-features.mspx for a comparison table.

  14. #14
    tosca925's Avatar
    Join Date
    Aug 2005
    Location
    Midlands
    Posts
    1,547
    Thank Post
    4
    Thanked 4 Times in 4 Posts
    Rep Power
    22

    Re: MS SQL Licencing

    We been quoted £750 per CPU and we have a dual CPU server..................£1500 to find.

  15. #15

    Join Date
    Feb 2006
    Posts
    1,187
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: MS SQL Licencing

    @tosca who with?



SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Symantec Ghost Licencing
    By ranj in forum Windows
    Replies: 18
    Last Post: 5th November 2008, 11:08 AM
  2. Windows Server Licencing
    By Newton in forum Windows
    Replies: 2
    Last Post: 27th November 2007, 12:39 PM
  3. Licencing
    By witch in forum General Chat
    Replies: 15
    Last Post: 13th March 2007, 11:19 PM
  4. Ghost licencing
    By ranj in forum Windows
    Replies: 8
    Last Post: 16th October 2006, 07:07 AM
  5. Windows XP Pro Licencing
    By Preston in forum Windows
    Replies: 11
    Last Post: 28th April 2006, 03:50 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •