Database on the Net

From: Jzxy (Jaxy555@Yahoo.com)
Date: 11/28/02 

From: "Jzxy" <Jaxy555@Yahoo.com>
Date: Thu, 28 Nov 2002 09:15:18 -0800

Happy Thanks Giving:

            I do have a planning/Security question. I'm
sure most
of you have done this so many times. I'm hoping I would
get some idea and feedback from here.

I have a SQL 2000 Database on Windows 2000 server that
would be used for web-based application. I am working on
how this data be placed in local LAN and how best it
could be protected.
 
So my plan is ...

1) By no means the web-based application will talk to the
original DB directedly and I think I need to use VIEW for
this purpose. Then at the end of the day View would feed
the data to the ORIGINAL Table or Database. BUT I'm not
sure this is the solution I need to implement or something
else you recommend.

2) The Database server would be placed in a DMZ for
security.

3) I want anyone from internet can use this Web-based
Application, so what Account I should use for SQL and
Windows 2000 server and what kinda permission it should be
given.

4) Is there anything else I need to consider?/

Any knda feedback is appreciated..

Cheers...

Jaxy..........

Relevant Pages

  • Re: help with 2000i on win2k server (sp3 on database)
    ... See Leonard's post for the config options. ... If the server is mangling itself, then ANYTHING running on the server ... that I work with will support the database AND the application. ... As for Windows vs. Linux/NetWare, I can agree, but I also see MANY ...
    (comp.databases.btrieve)
  • Re: nt4.5 to w2003
    ... keep in mind that there basically is two different things you can do to move from an NT 4 (SAM Database) domain to an Active Directory Domain. ... You can choose to upgrade the domain from NT 4 to Windows 200x Active Directory. ... The thing to keep in mind here is that you have to Upgrade an NT 4 PDC to Windows 200x. ... You could download and install Virtual Server 2005 if you needed to upgrade an NT 4 machine to Windows 200x and your real hardware either does not support NT 4, or the NT 4 hardware you have does not really support Windows 200x. ...
    (microsoft.public.windows.server.migration)
  • Re: Setting up Linked server to MsAccess
    ... At the server level I have added my windows user group ... At the database level I have added my Server login ...
    (microsoft.public.sqlserver.security)
  • Problem with Sharepoint Windows Services on Win 2003 SBS Server
    ... The other day we had a server that crashed for some unknown reason. ... "Cannot connect to the configuration database. ... I should point out at this stage that the OS is Windows 2003 Small Business ... SharePoint Services 2.0 and tried re-installing MSDE by launching ...
    (microsoft.public.windows.server.sbs)
  • Re: Database Connection/ Results not working
    ... After you have created your database connection and renamed your page to .asp, ... You can not test any thing under Windows XP Home ... that requires a MS Web server, ...
    (microsoft.public.frontpage.client)