For my application an instance of SQL Server Express 2014 needs to be installed. I use Installaware (runtimes) to install the SQL Server and my app on a Windows OS. Before installation Installaware checks if the name of the instance is already installed on the system. If not, it will be installed as a pre-requisite.
As the installation of the pre-requisite (SQL Server) is done silently, there is no info about the progress. If for some reason the installation fails the PC of my customer has a partly installed SQL Server with all issues that go with that.
If installation fails it's mostly because there is already another instance of SQL Server running. This might lock certain files or it requires to install SQL Server as an update in stead of a full installation (if installed version is older then 2014).
But even if there is no previous installation of SQL Server it still might give issues, like:
So I'm looking for a way to smooth the installation for my customers.
Can anyboby help me with setting things up in Installaware (add certain checks to script) or give any tips?