I use the following apps:
SelectSurvey.NET: http://classapps.com/SelectSurveyDocumentation.asp
MojoPortal: http://www.mojoportal.com/installation-quick-start.aspx
ScrewTurn Wiki: http://www.screwturn.eu/Help.InstallSqlServer.ashx
Other programs like DotNetNuke are similar. Create an empty database, permission it. Copy the web files to your IIS server. Set database connection in web.config. Go to an install.aspx page and it sets up the database.
No BOFH. I control my SQL server. I control my IIS server. I control my App Pools. I want to be able to control the Lansweeper install. Best practice for SQL is to use Windows Authentication for authentication mode. The installer routine currently allows you to choose the 3 parts individually. That's a good breakdown - it allows an Enterprise company to allow the SQL admin to handle the SQL portion, the service portion installed by a Server admin, and the web portion installed by an IIS admin. For the SQL portion, I would like to run the installer and have it create the Lansweeper database where I choose the SQL server, database name, the Windows credentials. For the service portion I would like to give the server to run on and the option for Windows credentials to run the service as. For the web portion, I would like to provide a folder path (I'll do the IIS setup), and the web.config file could be auto updated with the information already provided.
I'll reiterate, I'm a happy Premium
pro-active customer.
-Joe