ASP.NET + SQL Server + WebHost Questions

I'm getting ready to build my first ASP.NET/SQL Server website that will be
hosted on some web host out there. The work I've done in the past
(pre-.NET) was all done on in-house servers. Since this will be hosted
elsewhere, I wanted to ask some questions to make sure that I'm doing things
correctly.

We have a SQL 2000 db hosted on a server here. I need to build a website
that will both read and write data from this database as well as a couple of
other SQL 2000 (maybe 2005 also) databases located on machines here.

What is the best way to accomplish this via a hosted setup and ASP.NET?

What features do I need to make sure I have when trying to select a web
hosting provider?

What is the best method for accessing the databases here from the off-site
website? I want to make sure I'm using the best methods for speed,
security, stability, etc.

Will I just access the SQL Servers here directly, or do I need to have a SQL
Server running at the web host also with mirrored data, or some type of a
subscription setup?

I have no idea what the best way to accomplish this is and I'm feeling lost.
Thanks in advance for any and all information, I really appreciate it.

RE: ASP.NET + SQL Server + WebHost Questions

Hello Dean,

Are the web host server and your database server in same intranet or in
different wetwork? If they are far way from each other, performance will be
a serious issue in the solution. When your ASP.NET query data from the
database server, it may take seconds or even minutes, if there were many
database operations in the asp.net application, the user experience will
not be good.

So, the Web Host should support local database server, further more,
provide a good replication method so that you can replicate data between
local and remote database server.MS SQL server provide rich features on
replications, so you may choose a Web Host provider fully support this.

BTW, for ASP.NET related questions, you may post in a more proper group
like microsoft.public.dotnet.framework.aspnet.

Sincerely,

Luke Zhang

Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/de fault.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx .
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

RE: ASP.NET + SQL Server + WebHost Questions

Hello,

Is there any update on this issue? If you need further assistance on this
issue, please feel free to let us know.

Sincerely,

Luke Zhang

Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/de fault.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx .
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.