Re: [WiX-users] Unable to execute sql scripts

2014-08-06 Thread garymonk
I have resolved the problem by moving the sqldatabase element outside of a component. By doing that it the installer is not trying to create the database (I have a script for that) and I no longer need a until:user and the installer seems to be using the current user to run the SQL scripts. Here i

Re: [WiX-users] Unable to execute sql scripts

2014-08-06 Thread garymonk
The current user is created as a sysadmin when SQL Server is installed. This is done as part of a bundle just prior to running the install that creates the database. -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Unable-to-execute-sql-scripts-tp75

Re: [WiX-users] Unable to execute sql scripts

2014-08-05 Thread John Cooper
, 2014 6:25 PM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Unable to execute sql scripts I changed the util:user to use sa as the user and it worked. So the problem is definitely a permissions issue. The problem is that I have to be able to use Windows authentication. When the database is created t

Re: [WiX-users] Unable to execute sql scripts

2014-08-05 Thread garymonk
I changed the util:user to use sa as the user and it worked. So the problem is definitely a permissions issue. The problem is that I have to be able to use Windows authentication. When the database is created the flag is set to create the current user as an administrator (ADDCURRENTUSERASSQLADMIN=

Re: [WiX-users] Unable to execute sql scripts

2014-08-05 Thread garymonk
Thanks for the reply. The database is on the local machine. I'm not sure how to turn on profiling but I will take a look. One thing I forgot to mention is that the scripts will run in SQL Server Management Console under the same user that is in the user element. I was wondering if the user and dom

Re: [WiX-users] Unable to execute sql scripts

2014-08-05 Thread John Cooper
day, August 5, 2014 3:58 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Unable to execute sql scripts Hi, I'm new to WIX and I'm having some problems executing SQL scripts. I have looked at a number of posts and none of them have worked. I have also looked for any SQL Serv

[WiX-users] Unable to execute sql scripts

2014-08-05 Thread garymonk
Hi, I'm new to WIX and I'm having some problems executing SQL scripts. I have looked at a number of posts and none of them have worked. I have also looked for any SQL Server logs that would help and I couldn't find any. The error messages that I'm receiving in the install log are... CreateDatabase