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!
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!