Application deployment - asp.net mvc, windows service

Question

I've created an application that consists of a

asp.net mvc 3 control panel
windows service
ms sql database

I would like to create an installer that is able to handle the deployment and auto updates of this application.

The application requires at least those things to be done during install:

ensure MsSQL 2008 is installed (if not prompt the user or install express version)
ensure user has Net Framework 4.0, ASP.NET MVC 3.0 installed (and probably some other Ms products I forgot)
set appropriate connection strings in an xml configuration file
add SQL Server user (the one that is used to run the instance) privileges to read/write to a folder
create an IIS Site and application pool (and deploy the app)
set the application pool mode to 4.0 Integrated
create a windows service
grant the asp.net application a privilege to control the mentioned windows service (subinacl /service service_name /grant="IIS APPPOOL\DeployTest"=F)
create the database, run create scripts
create database users and grant them appropriate privileges
edit web config file to set some custom settings

Is it at all possible? Or am I forced to do that manually?

Hi I need to install a service from the WebApp, is there a way to do it? How you ended doing this. Thanks — VAAA
– VAAA, Commented Sep 30, 2019 at 16:44

xing · Accepted Answer · 2011-09-16 13:37:56Z

1

It is possible and there're many ways and tools to achieve that.

Ultimately you can create a windows installer (msi) package which WIX can help.

answered Sep 16, 2011 at 13:37

xing

4472 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

kubal5003 Over a year ago

Can you name just a few of these tools?

kubal5003 Over a year ago

I've investigated the windows installer option (including WIX) and the problem is that windows installer does not support automatic updates.

kubal5003 Over a year ago

After reading WIX tutorial - WIX is out of the question. It's complex, it provides nothing really useful in my situation.

xing Over a year ago

Web Deploy should be perfect to deploy the website and possible the database. MSBuild scripts can help deployment of windows services. MSBuild Community Task includes a XmlUpdate task to help updating the config files.

kubal5003 Over a year ago

I can't use Web Deploy, because often I need to deploy to Windows Vista/Seven - it's impossible to enable WebDeploy on those systems (I've spent several days on this case)

|

Collectives™ on Stack Overflow

Application deployment - asp.net mvc, windows service

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related