Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Possible Duplicate:
Can you help me with my software licensing question?

How is Sql Server 2008 Web licensed? When clicking on how to buy on the Microsoft pages it shows only SPLA pricing of $15 per processor per month. Does that mean it's only available from resellers that host it for you?

Since the pricing of it is based per processor does that mean that there is no limitations on the number of users allowed to access the database ie there are no CAL licenses?

Finally, is there any key functionality that is missing from the web edition for a database that all it really does is act as a simple data store for a website? I would at some point like to take advantage of the FileStream functionality that was added to 2008 is that available on the web edition?

share|improve this question

marked as duplicate by Mark Henderson Jan 13 '12 at 4:48

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

2 Answers 2

up vote 2 down vote accepted

Are you referring to this page:
http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx

It does seem that it's only available through volume licensing or SPLA. If you're an established organization, then you should be using volume licensing anyways. You have to have an agreement setup, but it's not difficult to do, get in contact with a reseller.

  1. SQL Web Edition is available to through Volume Licensing, & also available for free through Microsoft's BizSpark program, if you’re a small business.

  2. Per processor licenses mean there is no need for CAL's so this is perfect for licensing for a web application.

Apart from the 4CPU limitation, there are also a few 2008 features that are not available. MSDN has a full list of features that 2008 web edition support, and yes, filestream is supported.

share|improve this answer
    
We don't meet the age or revenue requirements for bizspark. –  Chris Marisic Oct 19 '09 at 21:01
    
What's the best way to get started with the Microsoft Volume Licensing program? Prior to my current job I never had to deal with any of the acquisition stage of software and was always just provided it. –  Chris Marisic Oct 21 '09 at 12:40
    
I haven't done that kind of thing myself for a few years. Find a reseller & contact them. microsoft.com/licensing –  Nick Kavadias Oct 22 '09 at 0:59

The SQL Server 2008 does come with FILESTREAM support.

I'm always confused with their complex licensing systems, but I believe web is only available from resellers and doesn't come with CALs or it has a limited amount of CALs and you can't buy more.

You can buy SQL Server 2008 Standard with 10CALs for around 2000 USD and you will own it, and you can take it wherever you want.

My biased advice? Go with MySQL.

share|improve this answer
1  
10 CAL's isn't suitable for a website application –  Nick Kavadias Oct 19 '09 at 23:54

Not the answer you're looking for? Browse other questions tagged or ask your own question.