navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

MS SQL Server licensing for web data access

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> Server Issues >> MS SQL Server licensing for web data access
Page: [1]
 
Webwork

 

Posts: 89
From: New Jersey USA
Status: offline

 
MS SQL Server licensing for web data access - 8/2/2002 19:06:27   
I am considering installing MS SQL server on 2 co-located servers. (Plan B is MySQL but my research suggests if I can bear the expense of MS SQL it may, in the end, be less " time/admin costly" )

Here' s what I don' t understand about the licensing.

The standard edition makes reference to 5user.

How does the # of users relate to running MS SQL provide data access for websites?

Is the standard license applicable? I hope so because I can' t afford much more, but I don' t want to run afoul of licensing.

Any experts or persons experienced with this issue?

Tanks a ton, or 50 tons, or just tanks a lot.

_____________________________

www.DirectoryCompany.com
Doug G

 

Posts: 1189
Joined: 12/29/2001
From: SoCal
Status: offline

 
RE: MS SQL Server licensing for web data access - 8/2/2002 23:27:08   
Take a look here. With SQL 7 you needed an Internet Connection license, I haven' t looked closely at the SQL 2000 licensing for internet use.

http://www.microsoft.com/sql/howtobuy/production.asp


_____________________________

======
Doug G
======

(in reply to Webwork)
Webwork

 

Posts: 89
From: New Jersey USA
Status: offline

 
RE: MS SQL Server licensing for web data access - 8/3/2002 9:17:27   
I read the page 3 times and found no language about an " internet connection license" but I Googled the phrase you provided and found this page:

http://www.microsoft.com/sql/howtobuy/70/pricing.asp

which offered an explanation about the ICL and other nasty Microsoft pricing practices.

Thanks for the help.

_____________________________

www.DirectoryCompany.com

(in reply to Webwork)
caywind

 

Posts: 1479
From: USA
Status: offline

 
RE: MS SQL Server licensing for web data access - 8/3/2002 17:42:26   
<.02>my experience with MS SQL Server is this: This server will need to be on one very fast, dedicated server, with as much RAM as it will take. Think GIG' s.

MySQL however, needs less and will probably run faster, until you hit a large number of concurrent users... Much work is being done on MySQL interfaces to make it friendlier</.02>

(in reply to Webwork)
Doug G

 

Posts: 1189
Joined: 12/29/2001
From: SoCal
Status: offline

 
RE: MS SQL Server licensing for web data access - 8/3/2002 18:24:28   
quote:

I read the page 3 times and found no language about an " internet connection license" but I Googled the phrase you provided and found this page:

That' s because the Internet Connection License went away when SQL Server 2000 was released a year or so ago. SQL Server 2000 uses the licensing model as described on the link I posted.

MySQL is a decent db, as long as you are willing to put up with it' s loose interpretation of the SQL Standard, lack of stored procedures, etc.

The horsepower you will need for SQL Server depends on the load. For lower usage sites SQL Server can run fine on a server shared with other apps.


_____________________________

======
Doug G
======

(in reply to Webwork)
Page:   [1]

All Forums >> Web Development >> Server Issues >> MS SQL Server licensing for web data access
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts