Re: SBS 2003 Premium, and a WebServer?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Anytime Norm.

--
Henry Craven {SBS-MVP}


"N. Hughes" <quadrantcomputerNOSPAM@xxxxxxxxxxx> wrote in message
news:%23Ow180BwHHA.3508@xxxxxxxxxxxxxxxxxxxxxxx

"N. Hughes" <quadrantcomputerNOSPAM@xxxxxxxxxxx> wrote in message
news:eQMwRj4vHHA.2004@xxxxxxxxxxxxxxxxxxxxxxx
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.
Norm Hughes



I re-iterate my thanks to all respondees for the help. Henry, I will
contact you off-line to pursue the matter a little further (if that's OK
with you).

Regards
Norm Hughes






.

Relevant Pages

  • Re: Bastion Host running SQL server 2000
    ... The local admin on the server does not have an SQL login individually ... > "I guess the lookup of group membership is somehow disabled. ...
    (microsoft.public.sqlserver.security)
  • Re: How can i deploy a database with Membership Tables?
    ... If the server is yours then yes, ... Membership can be used with SQL2000 ... when deploying your data and database to the remote ... You'll also want to determine if your hosting service supports the SQL ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SBS 2003 Premium, and a WebServer?
    ... We have a client running SBS 2003 Premium with SQL Server 2000, ... running a separate web server on the Windows Server 2003 platform, ... could host a web site for the membership which could use the LAN's SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Club Starter Kit and MS Access? part II
    ... It should be almost trivial to export the table structure to a sql script ... which MySQL can use to create the required database. ... Here's a MySQL Membership provider you can use/adapt: ... Then why ODBC Access is free and MS SQL - MySQL on windows server has to be a paid service, ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)