I came across an interesting situation when a client could not run my installer to set up their SQL database. It was set to use Windows Authentication and even though the user was set up as an administrator on the SQL server, they could not connect to the database.
After searching around the forums, it seems the MSI file is using the built in local account, and therefore domain specific details are ignored.
Download ORCA tool from Microsoft. See this post here:
Then, when you have ORCA tool, follow this blog
The ORCA row I changed the type for was:
_B25C9B12_5826_4B28_AD29_C2A033133B53.install 1025 InstallUtil ManagedInstall
The database was able to be configured correctly when this amendment was made to the MSI file. For now, this is now an extra step in the build process.