Website and Database methodology question

Hi

I'm building a company Website using Frontpage 2003 but no very little about
web development. The site will be hosted by our ISP. At our office we run
Microsoft Small Business Server 2003 Premium which includes SQL Server.

We want the website to have some content which is restricted to registered
users so need a log on procedure and also eventually want to develop on-line
ordering for our customers.

My question is concerning whether the user/password data and the more
extensive customer/item/price data (Excel/Access MDB/SQL Server Database
info or whatever) would normally reside on the ISP's server with the Website
or is it normal to link the website to data stored somewhere else e.g. On
our office SBS Server.

Is there a norm for this ?

If the Data needs to reside with the website, how would it be maintained?

Many thanks

Rob
Wed Jul 09 09:11:23 CDT 2008

On the online server - and it won't be Excel.




--
~~~~~~~~~~~~~~~~~~
Rob Giordano
Microsoft MVP Expression






"Jon Lewis@btinternet.com>" <jon.lewis<nospam> wrote in message
news:u8kgGnb4IHA.5012@TK2MSFTNGP02.phx.gbl...
> Hi
>
> I'm building a company Website using Frontpage 2003 but no very little
> about web development. The site will be hosted by our ISP. At our office
> we run Microsoft Small Business Server 2003 Premium which includes SQL
> Server.
>
> We want the website to have some content which is restricted to registered
> users so need a log on procedure and also eventually want to develop
> on-line ordering for our customers.
>
> My question is concerning whether the user/password data and the more
> extensive customer/item/price data (Excel/Access MDB/SQL Server Database
> info or whatever) would normally reside on the ISP's server with the
> Website or is it normal to link the website to data stored somewhere else
> e.g. On our office SBS Server.
>
> Is there a norm for this ?
>
> If the Data needs to reside with the website, how would it be maintained?
>
> Many thanks
>
>
>
>
>

Jon
Wed Jul 09 09:40:03 CDT 2008

Well our local SBS 2003 Server is accessible online but I assume you mean
the ISP server that hosts our website?

If so what would be the normal way to synchronise database info between our
local db's and the info we need available to the website?

Many thanks

"Rob Giordano (Crash)" <webmaster@siriussystems.invalid> wrote in message
news:681FE197-40B8-48C0-992A-FD56B54D5462@microsoft.com...
> On the online server - and it won't be Excel.
>
>
>
>
> --
> ~~~~~~~~~~~~~~~~~~
> Rob Giordano
> Microsoft MVP Expression
>
>
>
>
>
>
> "Jon Lewis@btinternet.com>" <jon.lewis<nospam> wrote in message
> news:u8kgGnb4IHA.5012@TK2MSFTNGP02.phx.gbl...
>> Hi
>>
>> I'm building a company Website using Frontpage 2003 but no very little
>> about web development. The site will be hosted by our ISP. At our
>> office we run Microsoft Small Business Server 2003 Premium which includes
>> SQL Server.
>>
>> We want the website to have some content which is restricted to
>> registered users so need a log on procedure and also eventually want to
>> develop on-line ordering for our customers.
>>
>> My question is concerning whether the user/password data and the more
>> extensive customer/item/price data (Excel/Access MDB/SQL Server Database
>> info or whatever) would normally reside on the ISP's server with the
>> Website or is it normal to link the website to data stored somewhere else
>> e.g. On our office SBS Server.
>>
>> Is there a norm for this ?
>>
>> If the Data needs to reside with the website, how would it be maintained?
>>
>> Many thanks
>>
>>
>>
>>
>>
>

Thomas
Wed Jul 09 09:47:19 CDT 2008

If you are using MS SQL Server and it is connected to the internet, then yes, you could allow the
web site to have access. I suggest you speak with your ISP and System Admin to make sure it is
secure.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================


"Jon Lewis @btinternet.com>" <jon.lewis<nospam> wrote in message
news:u8kgGnb4IHA.5012@TK2MSFTNGP02.phx.gbl...
> Hi
>
> I'm building a company Website using Frontpage 2003 but no very little about web development. The
> site will be hosted by our ISP. At our office we run Microsoft Small Business Server 2003 Premium
> which includes SQL Server.
>
> We want the website to have some content which is restricted to registered users so need a log on
> procedure and also eventually want to develop on-line ordering for our customers.
>
> My question is concerning whether the user/password data and the more extensive
> customer/item/price data (Excel/Access MDB/SQL Server Database info or whatever) would normally
> reside on the ISP's server with the Website or is it normal to link the website to data stored
> somewhere else e.g. On our office SBS Server.
>
> Is there a norm for this ?
>
> If the Data needs to reside with the website, how would it be maintained?
>
> Many thanks
>
>
>
>
>