[wix-users] SqlDatabase, SqlScript User with Windows Authentication

[Edwin Castro]

Perhaps you've encountered a bug either in implementation or documentation?

--
Edwin G. Castro


On Tue, Jun 12, 2018 at 8:15 PM, Ven H <venh.123 at gmail.com> wrote:

> Thanks a lot, Edwin. I just saw the Description for the User attribute and
> unfortunately, it is empty. I didn't scroll down further to read the
> Remarks. Sorry about that.
>
> Anyways, I will come to know the Authentication mode during installation.
> So, it will be difficult to add / remove this attribute during that time,
> since the markup would have been already defined in the MSI.
>
> Should I manipulate the MSI DB to achieve this at run time and is it
> possible or there is another way? For Windows Auth, I was not passing the
> Login Name and Password. But, it was not working and throwing run time
> exceptions.
>
> So, I am a little confused. Please advise.
>
> Regards,
> Venkatesh
>
> On Tue, Jun 12, 2018 at 11:29 PM, Edwin Castro <egcastr at gmail.com> wrote:
>
>> Have you tried it yet? What were your results?
>>
>> http://wixtoolset.org/documentation/manual/v3/xsd/sql/sqldatabase.html
>>
>> "The User attribute references credentials specified in a User element.
>> If a user is not specified then Windows Authentication will be used by
>> default using the credentials of the user performing the install to execute
>> sql strings, etc."
>>
>> --
>> Edwin G. Castro
>>
>>
>> On Tue, Jun 12, 2018 at 10:31 AM, Ven H via wix-users <
>> wix-users at lists.wixtoolset.org> wrote:
>>
>>> Can the User attribute in SqlDatabase, SqlScript etc be a Windows user?
>>> If
>>> so, can we use it without password? In many case, we need to install sql
>>> using Windows Authentication? Please help.
>>>
>>> ____________________________________________________________________
>>> WiX Toolset Users Mailing List provided by FireGiant
>>> http://www.firegiant.com/
>>>
>>
>>
>