Where to start with SQL Server? 1

[TheInsider]

Hello,
My company would like to switch from Access to SQL Server. I would like to know your expert advice as to what product to purchase. I need to be able to develop databases and then centralize the data entry on a server, by having the clients log in via a

http://WWW interface.

I realize that the

http://WWW interface

can be achieved with 3rd party tools. Should I purchase a copy of MS SQL Server Standard with 25 client license or a single processor license? Does this include the development tools (I don't expect it to have the web tools)? What version of SQL server should I purchase - 7 or 2000? Is there a limitation with version 7 - we're cheap? I need any input asap!
Thanks in advance, Rob Marriott
rob@career-connections.net

 

[TomSark]

If you want to use SQL Server for an internet application(s), you will have to buy some pricy licenses:
SQL Server 7.0 - requires the internet connector license (somewhere around 3000.00)
SQL Server 2000 - requires you purchase the per processor license (around 5500 per processor)

But, by buying this, you will get call the CALs you need for your enterprise as well as the internet users hitting your web site.

Also, keep in mind that this either of these routes is still much cheaper than Oracle. Call Microsoft Sales for more info...
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[TheInsider]

Thanks,
Actually, I should have said "intranet" not "internet", they will log in through

http://WWW forms,

however, only 20 clients (who will never change) will be allowed access to the database. Do I still need a special license? Rob Marriott
rob@career-connections.net

 

[TheInsider]

Oh, and do these packages include the standard database development tools. I notice that there is a developer edition of SQL Server.
Thanks, Rob Marriott
rob@career-connections.net