There is a WCF service which is running under IIS. This service accesses the files in its folder, it accesses a SQL Server database and it writes messages to the EventLog.
The deployment platform is Windows Server 2008 in some datacenter. I developed the service, but I'm really still a beginner.
The deployment will causes the creation of a new Windows user account and, possibly, a role that is assigned to that user. This is needed to start the service from a separate account with strictly defined rights (as I understand, this approach is recommended, but not to start the service from NT Service account).
Obviously, the deployment needs to run scripts to create database, tables, scheduling of tasks.
What tools could you advice to accomplish such a deployment? Maybe I can use the standard Setup Project? Or some third-party tools such as WiX Toolset? Should I use PowerShell to create windows user account and role?
There is also a question: should I pull the prerequisites, such as .NET framework installer, SQL Server installer?