Re: SBS 2003 Premium, and a WebServer?

In article <eQMwRj4vHHA.2004@xxxxxxxxxxxxxxxxxxxx>,
quadrantcomputerNOSPAM@xxxxxxxxxxx says...
Hi All

We have a client running SBS 2003 Premium with SQL Server 2000, which
supports a large membership database (this site was upgraded from SBS 2000.)
The boss asked us whether, using a separate ADSL service, and running a
separate web server on the Windows Server 2003 platform, they could host a
web site for the membership which could use the LAN's SQL Server? I think
they envisage the membership updating their own records & etc.

If we put a second NIC in the webserver, we could access the webserver from
the LAN... but...my questions are:
(1) What are the security implications for this approach?
(2) What would be the SQL Licensing position?
(3) Is there a better way?

Thanks in advance for any and all responses.

SBS is not licenses to allow any type of "Membership" lookup, you can't
write an application (web) that looks up users ID's, Names, etc in order
to provide authentication with your application. If your member base is
Anonymous then you're good, if they EVER authenticate (even just a
lookup of a web user/password in a table) then that would violate the
SBS licensing. We just went through this with a doctors office and MS
Licensing - the doc wanted Patients to be able to connect to the web
application and see their records - the vendor said SQL CPU licenses, I
suggested SBS 2003 Prem - MS said that "Authentication by ANY MEANS" and
a web app that looks up users in a table would be "Authentication by Any
Means", well......

The rest of your question doesn't need answered as SBS is not a valid
host for you, based on licensing, so I will stop here.


--

Leythos
- Igitur qui desiderat pacem, praeparet bellum.
- Calling an illegal alien an "undocumented worker" is like calling a
drug dealer an "unlicensed pharmacist"
spam999free@xxxxxxxxxx (remove 999 for proper email address)
.

Relevant Pages

  • Re: SQL Licensing
    ... I believe that the SBS license for SQL Server is a Standard Edition, ... that it requires the SQL Server to be installed on the same box as SBS. ... The best place to ask those questions is with the licensing folks. ...
    (microsoft.public.sqlserver.setup)
  • Re: licensing SQL Server 2000 CE
    ... Let me say up front that I am not a SQL Server licensing expert. ... If it does work like SBS, then you only have to count ... >>> a workstation and a mobile device, do I need 2 CALs? ...
    (microsoft.public.sqlserver.ce)
  • Re: Licenseing
    ... SQL Server CALs, however I'm not sure that this is true in SBS 2003 as ... Applications, the Licensing is I believe "Per Processor", and not "per ... Administration in such a configuration that far outweighs the cost of a ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server and Windows SBS
    ... I would highly recommend AGAINST the idea of allowing unauthenticated ... I recommend calling the licensing folks. ... Q. I want to use the SQL Server component of SBS 2003 R2 Premium ... As long as the Internet users do not authenticate on the SBS ...
    (microsoft.public.sqlserver.setup)
  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install ...
    (microsoft.public.windows.server.sbs)
Loading