+ 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,414
    Thank Post
    360
    Thanked 256 Times in 187 Posts
    Rep Power
    75

    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
    18

    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,359
    Thank Post
    54
    Thanked 308 Times in 240 Posts
    Blog Entries
    6
    Rep Power
    119

    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,725
    Thank Post
    909
    Thanked 1,328 Times in 808 Posts
    Blog Entries
    1
    Rep Power
    446

    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
    20

    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,725
    Thank Post
    909
    Thanked 1,328 Times in 808 Posts
    Blog Entries
    1
    Rep Power
    446

    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
    London
    Posts
    7,596
    Thank Post
    109
    Thanked 764 Times in 595 Posts
    Rep Power
    181

    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,043
    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
    London
    Posts
    7,596
    Thank Post
    109
    Thanked 764 Times in 595 Posts
    Rep Power
    181

    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
    17,792
    Thank Post
    517
    Thanked 2,468 Times in 1,912 Posts
    Blog Entries
    24
    Rep Power
    835

    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
    London
    Posts
    7,596
    Thank Post
    109
    Thanked 764 Times in 595 Posts
    Rep Power
    181

    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, 10:08 AM
  2. Windows Server Licencing
    By Newton in forum Windows
    Replies: 2
    Last Post: 27th November 2007, 11:39 AM
  3. Licencing
    By witch in forum General Chat
    Replies: 15
    Last Post: 13th March 2007, 10:19 PM
  4. Ghost licencing
    By ranj in forum Windows
    Replies: 8
    Last Post: 16th October 2006, 06:07 AM
  5. Windows XP Pro Licencing
    By Preston in forum Windows
    Replies: 11
    Last Post: 28th April 2006, 02: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
  •