Hi,
I have a Wix file where I'm using the <SqlDatabase> element to create a
database. I've omitted the User attribute, because I want it to use Windows
Authentication of the currently logged in user (as per the documentation).
"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.
"
During runtime however, it fails with the following.
"MSI (s) (A0:24) [13:51:38:920]: Executing op:
ActionStart(Name=CreateDatabase,Description=Creating Databases,)
Action 13:51:38: CreateDatabase. Creating Databases
MSI (s) (A0:24) [13:51:38:920]: Executing op:
CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (A0:1C) [13:51:38:920]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSID48.tmp, Entrypoint: CreateDatabase
CreateDatabase: Error 0x80040e4d: failed to create to database: 'TestDB',
error: unknown error"
In the SQL Server log, it shows a failed login attempt with an empty user name.
"Date 4/8/2013 1:51:39 PM
Log SQL Server (Current - 4/8/2013 1:51:00 PM)
Source Logon
Message
Login failed for user ''. Reason: Could not find a login matching the name
provided. [CLIENT: <named pipe>]"
Note that the user string is empty (''). It appears that the SqlDatabase
extension is not picking up the Windows user information.
Has anyone else seen this behavior? Could it be a bug in the Sql Extension?
I am using Wix version 3.6.
Thanks,
Nick
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
