deploying VWDxpress websites with databases?

Tech-Archive recommends: Fix windows errors by optimizing your registry



I have a "newbie" deployment question.

I want to confirm what's involved in deploying a web created with Visual Web
Developer Express Edition to a production Server2003/IIS 6 server.

The project to be deployed has a typical membership database created through
the administrative interface ("App_Data/ASPNETDB.MDF").

For that dB to work on the webserver, does SQL Server Express Ed. have to be
installed on the webserver as well?

If so, are there any downsides to installing it, other than the performance
issue of running a dB server on the webserver? Any security issues? This is
not a high-traffic website.

Or is the recommended solution, regardless, to set up a dB on a separate SQL
server and have the user change the connection strings to use the SQL
Server? (and copy the tables from the local dB to the server using SQL Mgmt
Studio Express?)

TIA, and please point me to a better group if this question is Off-Topic!


.



Relevant Pages

  • Re: Sharepoint on 2003 Web Edition
    ... Are you using it in plain vanilla Remote SQL Deployment? ... I already know that Web Edition does not support any db stuff. ... you can use Web Edition as a Front-end server. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: SQL Server Ziel in SSIS 2005
    ... SSIS udn SQL Server auf dem gleichen Rechner liegen und laufen. ... ich bin mittlerweile dazu übergegangen nur noch Alias-Namen in SSIS-Paketen ... Dies erleichtert auch das Deployment erheblich. ...
    (microsoft.public.de.sqlserver)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)