SQL Details not found in limited user?

[Codename K]

Hello,

I have created an installer to create the SQL database from SQL script. This works fine in administrator user account. The program that gets installed retrieves the SQL information set by the installer. But when the installer is installed as administrator from limited user account it does not retrieve the SQL information. How to fix this?

[Daniel]

Hello,

Most likely this happens due to a limitation of our "SQL Connection" feature design. When the trusted connection method is used the SQL Connection will use at install time the user account set by Windows Installer into "LogonUser" property and this property is always set to the user account which started the installation package and not to the one actually performing the installation after the UAC prompt appear (i.e. the admin one). Therefore your SQL Scripts will run under the limited user account authentication.

To avoid this limitation you could go to "Install Parameters" page and enable the "Run as administrator" option. Thus your setup package will run under the admin user account from the very beginning.

Let us know if this helped.

All the best,
Daniel

[Codename K]

Thanks for the information.

To avoid this limitation you could go to "Install Parameters" page and enable the "Run as administrator" option. Thus your setup package will run under the admin user account from the very beginning.

It already runs with that option set with "Require Administrator".

[Daniel]

Hello,

Could you try to isolate this behavior in a small sample which we could build and fully run and test on our side? If you can send us a sample and a small test case this will help us to fully understand the scenario you are trying to implement.

All the best,
Daniel

[Codename K]

If you can send us a sample and a small test case this will help us to fully understand the scenario you are trying to implement.

I have sent the project file to support email.

[Daniel]

Hello,

Thank you for the sent file. Your setup project seems to be configured just fine.

To further investigate how the SQL Database scripts impact your installed application, we will need a test case. More exactly, we will need to know what exactly is not set up correctly into your database during installation process? Could you please investigate this and try to give us more details.

If you could build a small test project which we can build on our side and test it this will be great.

All the best,
Daniel