Enterprise
I have a post-install prerequisite that has a custom SQL connection that runs several inline SQL scripts. Running the main install followed by the post-install prerequsite runs normally as expected but when running via basic install, the post-install prereq cannot connect to the SQL database. Within the logs, I get the following error:
Process of the install:CREATE DATABASE permission denied in database 'master'
1. Execute Main install with the following command:
Code: Select all
.\program.exe /qb /passive
3. Post-install prereq starts
4. First custom action sets [SQL_AUTHORIZATION] to the following:
Code: Select all
Uid=localuser;Trusted_Connection=yes;
Code: Select all
Driver=[\{]SQL Server[\}];Server=[SERVER_PROP];[SQL_AUTHORIZATION]
Troubleshooting:
-Ensured that the Local sys admin account has sufficient privileges to create databases in SQL
-Ensured that installs work on Full UI installation
-Attempted on Advanced Installer 18.3
*One other thing I came across is when calling [LogonUser] resulted in SYSTEM instead of the current user so I had to explicitly set Uid=localusername.
I have sent a sample project to the support email with subject line as the same name of this post.