We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

jstuardo
Posts: 88
Joined: Mon Nov 09, 2015 10:44 pm

Trusted connection does not work

Hello..

I have a custom SQL Server dialog that has one checkbox. The control name of the check box is TrustedConnectionCheck and the property name is SQL_TRUSTED_CONNECTION.

When installing the application, checking that check box, this error is shown: "Login failed for user 'Jaime'."

'Jaime' is the local user with administrator rights, and in fact, if I use SQL Management Studio, it connects perfectly.

I tried by not using Trusted Connection and create a SQL Server user. In that case, the exact same error occurs.

What may be happening here?

Regards
Jaime
Attachments
ai_sql connection.png
ai_sql connection.png (60.04 KiB) Viewed 4842 times
ai_error.png
ai_error.png (2.63 KiB) Viewed 4842 times
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Trusted connection does not work

Hello Jaime,

I cannot say why this happens. Can you please send us the .AIP (project file) and a verbose log of the installation to support at advancedinstaller dot com so we can investigate them?

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
jstuardo
Posts: 88
Joined: Mon Nov 09, 2015 10:44 pm

Re: Trusted connection does not work

Hello.... files attached.

Regards
Jaime
Attachments
installation.log
(752.68 KiB) Downloaded 457 times
setup.aip
(82.74 KiB) Downloaded 315 times
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Trusted connection does not work

Hello Jaime,

From what I have checked into your sent log file the related error occurs because at install time the customer configured a SQL authentication type (sql user and password), but in "SQL Databases" page you configured the "[LogonUser]" property reference to be used instead of the property of the username edit box (USERNAME_PROP) from your "SQLServerDlg" dialog.

Can you please proceed like this:

1. go to "SQL Databases" page of your setup project and select the "Base de Datos" predefined connection
2. in the right pane set the "Username" field to [USERNAME_PROP]
3. rebuild and test again the installation scenario

Hope this helps.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Building Installers”