Hello,
this is my constellation: exe bootstrapper, fixed defined multiple instances and want to add automatic upgrades without any UI.
These are my EXE params: /upgrdinst {6741C389-4B66-4ED5-AF4E-7EC661F8EF8A} /exenoui /qn /quiet /norestart
When I run the upgrade with UI, I have no problem, but once I call the exe with /exenoui /qn /quiet /norestart the upgrade fails due to:
MSI (s) (2C:24) [13:17:12:737]: Product: Connect -- Error 4140. There was an error during the SQL script execution process.
Error 4140. There was an error during the SQL script execution process.
CustomAction AI_SqlConfig64 returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
To give more information
I have some SQL scripts in the setup which are to run under Trusted Connection with [LogonUser in full UI mode. With this script I create a SQL sysadmin login that I want to use later for additional scripts and also use this sysadmin login during the silent upgrade.
The problem I am having is that I cannot find a way that this script that creates the sysadmin user runs only when the product is installed for the first time and with full UI mode. Tried combinations of OLDPRODUCTS and UPGRADINGPRODUCTCODE and also UILevel>2.
Nothing seems to work and as soon as I run this upgrade in silent mode, get the 1603 error.
Any hint would be welcomed or different approach as well.
I must confess that I am still on 16.0 version of AI (I know, I know)
Thank you. Hopefully there will be some light shed onto this.
Kissack