Microsoft SQL Server 2008 Web Edition: is it suitable for "closed" websites?

tags:

sql-server-2008

views:

answers:

Microsoft SQL Server 2008 Web Edition: is it suitable for "closed" websites?

Can Microsoft SQL Server 2008 Web Edition be used in "closed" websites, which are hosted on the Internet, but require users to log in?

We are developing a web application for banks. This is a website for clients of the bank; it allows clients to log in and view information on their personal banking accounts, stock portfolios, etc.

Can this web app use SQL Server 2008 Web Edition?

Here is information on this edition of SQL Server:

http://www.microsoft.com/sqlserver/2008/en/us/web.aspx

It is said on this page that Web Edition can be used only on "public and Internet accessible ... Web applications". Technically, the web app we are developing is public and Internet accessible - although it requires authentication. Won't using Web Edition in our web app violate SQL Server license terms?

Thank you.

+1 A:

Yes, perfectly. The website is public (everyone can see the login screen) and it is internet accessible (as in: accessed from / through the internet). You probably have a larger public site, actually, with some news and legal discplaimers.

As the authentication you do will be WITHIN the app, it is totally within the limits that the license says.

(and yes, I am SPLA license holder, so I know the SPUR you ahve to follow)

TomTom 2010-03-15 15:06:13

Does that mean that SQL Server Web Edition can be used to create all kinds of Intranet-like applications, that will be technically accessible over the Internet, but will require authentication and will thus be reserved only to a limited number of users?And will the cost be limited only to the monthly $15 per processor?

micha12 2010-03-15 15:34:27

Theoretically yes, BUT.... you are not allowed to identify users using OS means. This means: account for the website, the resit is to be done wthin the app. Intranet apps rather would love... acive directory integration etc.I know quite a lot of "non public" websites that fit here. Start with communities (I am part of some that are pretty much invitation only), go over to a company selling project management software that is hosted. All valid uses. Also note the technical limits of web edition.Check your SPUR ;)

TomTom 2010-03-15 16:11:32

Thank you for your comment, Tom. As for the technical limits of the web edition: it seems that the Web edition is quite powerful - like the Standard edition in terms of RAM and DB size limitations? Are there any hidden limitations of the Web version? And I am sorry: what is SPUR? :)

micha12 2010-03-17 10:30:08

it is QUITE powerfull - but it misses certain areas of the enterprise edition. SPUR--- you obviously are no SPLA customer. SPUR is a HUGH document describing what you area llowed to do under SPLA for every product. Close to 200 pages (like an EULA for everything MS makes). It is called Service Provider Usage Rights... in short SPUR ;)

TomTom 2010-03-17 11:07:19

ansaurus

tags:

views:

answers:

Microsoft SQL Server 2008 Web Edition: is it suitable for "closed" websites?

related questions