[WiX-users] Copy text (Serial Key) to clipboard in a C# Custom Action
Hi Folks, In my installer I have serial key specific to the PC software been installed. for validation purposes use has to send that key to us and obtain a verification key. both keys are 32 characters long. hence they are hard to type manually and best is to copy and paste. I would like to add a button saying Copy Serial Key to Clipboard which copies the key to the clipboard and then user can email it to us. I am fine with adding a button to a dialog box and attaching it a custom action. but I got my doubts on using the Clipboard in custom action project. Anyone has used it before in your custom actions ? I need to refer to WinForms library to access the clipboard in C#. Please share your experience and suggestions regarding this. Thanks in advance Regards, Asiri Wanigarathne -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] MSBuild generated bootstrapper question
yes it is possible t change the password. you need to tweak the configuration file and set authentication to use mixed mode. Refer to the following msdn page find the parameters you need to change http://msdn.microsoft.com/en-us/library/ms144259.aspx Regards, Asiri Wanigarathne On 16 May 2010 06:09, ALive aliv...@gmail.com wrote: Good day to Wix community! Is it possible to pass a parameter inside MSBuild generated bootstrapper? I would like to pass a 'SA' password for the SQL Server Express setup along with some other setup options. According to a Package.xml file taken from SQL Server express bootstrapper (C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bootstrapper\Packages\SqlExpress2008\en\package.xml) we have this predefined parameters (for x86 version): !-- Defines a new installation (x86) -- Command PackageFile=SQLEXPR32_x86_ENU.EXE Arguments='/q /hideconsole /action=Install /features=SQL /instancename=SQLEXPRESS /enableranu=1 /sqlsvcaccount=NT Authority\Network Service /AddCurrentUserAsSqlAdmin /skiprules=RebootRequiredCheck' EstimatedInstalledBytes=22500 EstimatedInstallSeconds=420 It would be nice at least to change Argiments property. Is that possible? Any advices would be appreciated! Thanks! -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Execute a script
Hi What is the WiX build you are using to build the MSI ? I got a WiX project with one database creation and multiple XML file modifications and that works fine. But I had issues creating the database in MSI built with WiX 3.5 Build 1602. Regards, Asiri Wanigarathne http://www.asiri.name On 21 April 2010 22:23, Will Sullivan wsulli...@softdocs.com wrote: XmlFile breaks SqlDatabase. See http://stackoverflow.com/questions/2602950/wix-xmlfile-is-keeping-sqldatabase-from-creating-databasesand https://sourceforge.net/tracker/?func=detailaid=2986062group_id=105970atid=642714 -Original Message- From: Carolina Zuqueto Amaral [mailto:carolina.ama...@conv.com.br] Sent: Friday, April 16, 2010 8:21 AM To: 'General discussion for Windows Installer XML toolset.' Subject: [WiX-users] Execute a script Hi, I created a path for to do the following changes: - Remove a file - Update some files - Execute a script But, the third option did not work. Setup Commands: ?xml version=1.0 encoding=UTF-8? Wix xmlns=http://schemas.microsoft.com/wix/2006/wi; xmlns:Util=http://schemas.microsoft.com/wix/UtilExtension; xmlns:Sql=http://schemas.microsoft.com/wix/SqlExtension; Product Id={F57E0806-B8E9-4e4b-A4B7-83797657175E} Name=WiX Patch Example Product Language=1064 Version=1.0.0 Manufacturer=Convergencia UpgradeCode={71C36DBF-DED5-4367-8D27-ED1D438AADC6} Package Description=Installs a file that will be patched. Comments=This Product does not install any executables InstallerVersion=200 Compressed=yes / Media Id=1 / ?define path = C:\Dev\usr\carolina.amaral\PatchCreation\Product\Product? ?define Version = 1.1? ?define RTMProductVersion=0.0.0 ? ?define ProductVersion=1.0.0 ? ?define UpgradeCode={F57E0806-B8E9-4e4b-A4B7-83797657175E}? Property Id=ALLUSERS1/Property Property Id=ProductIDnone/Property Property Id=DBNAMEConvergenciaAHClientCFG/Property Property Id=SQLSN(local)\CONVERGENCIA/Property Property Id=WIXUI_INSTALLDIR Value=INSTALLLOCATION / Property Id=WIXUI_DATA Value=DATA / Directory Id=TARGETDIR Name=SourceDir Directory Id=ProgramFilesFolder Name=PFiles Directory Id=INSTALLLOCATION Name=Patch Sample Directory Component Id=SampleComponent Guid={C28843DA-EF08-41CC-BA75-D2B99D8A1983} DiskId=1 File Id=SampleFile Name=Sample.txt Source=$(var.path)\1.1\Sample.txt Compressed=no / File Id=ConvergenciaAHAppexeCONFIG Name=Convergencia.AH.App.exe.config Source=$(var.path)\$(var.Version)\Convergencia.AH.App.exe.config Compressed=no / File Id=WpfControlLibraryDLL Name=WpfControlLibrary.dll Source=$(var.path)\$(var.Version)\WpfControlLibrary.dll Compressed=no / File Id=WpfUpdatableAppEXE Name=WpfUpdatableApp.exe Source=$(var.path)\$(var.Version)\WpfUpdatableApp.exe Compressed=no / /Component Directory Id=DataFolder Name=DATA Component Id=DataFolderComp Guid={C0054A15-8E33-49a6-B13A-8FD0743C328D} CreateFolder Directory=DataFolder/ /Component /Directory Component Id=DatabaseComp Guid={FA1987E8-EBB6-4886-B2C0-C92CAACF8C84} CreateFolder/ Sql:SqlDatabase Id=DropDatabase Database=[DBNAME] Server=[SQLSN] DropOnInstall=yes ContinueOnError=yes / Sql:SqlDatabase Id=CreateDatabase Database=[DBNAME] Server=[SQLSN] DropOnUninstall=yes ContinueOnError=no Sql:SqlScript Id=BinarySql ExecuteOnInstall=yes ExecuteOnUninstall=no BinaryKey=ScriptDB ContinueOnError=no Sequence=1/ /Sql:SqlDatabase /Component /Directory /Directory /Directory Upgrade Id=$(var.UpgradeCode) UpgradeVersion Minimum=$(var.ProductVersion) IncludeMinimum=no Language=1046 OnlyDetect=yes Property=NEWPRODUCTFOUND / UpgradeVersion Minimum=$(var.RTMProductVersion) IncludeMinimum=yes Language=1046 Maximum=$(var.ProductVersion) IncludeMaximum=no Property=UPGRADEFOUND / /Upgrade CustomAction Id =SAVETARGETDIR Property=ARPINSTALLLOCATION Value=INSTALLLOCATION/ Binary Id=ScriptDB SourceFile=.\sources\FACTConfigurationScript.sql/ Binary Id=InsertDB SourceFile=.\sources\FactInsert.sql / InstallExecuteSequence Custom Action=SAVETARGETDIR After=InstallValidate/ RemoveExistingProducts After=InstallInitialize / /InstallExecuteSequence Feature Id=SampleProductFeature Title=Sample Product Feature Level=1 ComponentRef Id=SampleComponent / ComponentRef Id=DatabaseComp/ ComponentRef Id=DataFolderComp/ /Feature /Product /Wix Upgrade Commands: ?xml version=1.0 encoding=UTF-8
Re: [WiX-users] Dependency Conditionals?
hi try reading the JDK 32 bit and JDK 64 bit registry entries to 2 properties such as JDK32 and JDK64 and then use a condition combining those two properties to evaluate either of those present in the registry. Eg: Property Id=JDK32 RegistrySearch Id=regJDK32 Root=HKLM Type=raw Key=SOFTWARE\JavaSoft Name=Java Runtime Environment / /Property Property Id=JDK64 RegistrySearch Id=regJDK32 Root=HKLM Type=raw Key=SOFTWARE\JavaSoft\Wow6432 Name=Java Runtime Environment / /Property Condition Message=This application requires JDK ![CDATA[ JDK32 = AND JDK64 = ]] /Condition Regards, Asiri Wanigarathne http://www.asiri.name On 22 April 2010 02:44, jeff00seattle jeff_tan...@earthlink.net wrote: Hi Is there a way to define external product dependency conditionals within WiX authoring, and if this conditional is not meet then do not install? I am creating a WiX for a product that has a dependency to an another product, or it will not run. The dependency product is JDK 32-bit build. When JDK 32-bit build is installed on different architectures, it has different registry settings: a. JDK 32-bit build on 32-bit hosts: HKLM\SOFTWARE\JavaSoft\Java Runtime Environment b. JDK 32-bit build on 64-bit hosts: HKLM\SOFTWARE\JavaSoft\Wow6432\Java Runtime Environment Thereby, I am looking to check registry for dependency product before excuting MSI, and only install if this dependency is satisfied. Thanks - Thanks Jeff in Seattle -- View this message in context: http://n2.nabble.com/Dependency-Conditionals-tp4938089p4938089.html Sent from the wix-users mailing list archive at Nabble.com. -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] SQL Extension broken in WIX 3.5 Beta build 1602?
Hi Rob, Update on the issue. I upgraded to WiX 3.5 build 1616. This works fine as it worked in the build 1526. It installs the database and run the SQL scripts. Comparison of log files shows that “Doing action: InstallSqlData” is missing in the MSI built with WiX 3.5 Build 1602. Thank you. Regards, Asiri Wanigarathne http://www.asiri.name On 19 April 2010 18:08, Asiri Wanigarathne waas...@gmail.com wrote: Hi Rob, I have attached log files for both builds. On build 1602 installer doesn't pop-up the database already exists dialog. Also it doesn't create the database or run the scripts. thanks. Regards, Asiri Wanigarathne http://www.asiri.name On 17 April 2010 10:48, Asiri Wanigarathne waas...@gmail.com wrote: Rob, I didn't inspect the log files. but when installing status doesn't show SQL Extension tasks such as Configuring SQL Server, Creating Database and Running SQL Scripts in Build 1602 where as in build 1526 it does. Also when I check the target SQL server instance installer (build with WiX 3.5 Beta Build 1602) has not created a database. Also Installer indicates successful installation. On Monday I can provide you the log files. Do you want log files for installers built with both builds or just build 1602 ? thanks. Regards, Asiri Wanigarathne http://www.asiri.name On 17 April 2010 00:12, Rob Mensching r...@robmensching.com wrote: Can you be a bit more specific about what is broken? Is there something in the log file showing the SQL Custom Action failing? On Fri, Apr 16, 2010 at 3:06 AM, Asiri Wanigarathne waas...@gmail.com wrote: Hi Folks, The database creation doesn’t work in the installer built with WIX 3.5 Beta 1602 as it did with WIX 3.5 Beta 1528 build and earlier builds. I tested it couple of times by going back and forth between WIX 3.5 beta build 1526 and build 1602 and I confirmed that database creation and running SQL scripts do not work in the installer build with WIX 3.5 Beta build 1602. I think SQL Extension is broken in the build 1602. Anyone else has noticed this issue with WIX 3.5 beta build 1602? Thanks. Regards, Asiri Wanigarathne http://www.asiri.name -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- virtually, Rob Mensching - http://RobMensching.com LLC -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] SQL Extension broken in WIX 3.5 Beta build 1602?
Hi Rob, I have attached log files for both builds. On build 1602 installer doesn't pop-up the database already exists dialog. Also it doesn't create the database or run the scripts. thanks. Regards, Asiri Wanigarathne http://www.asiri.name On 17 April 2010 10:48, Asiri Wanigarathne waas...@gmail.com wrote: Rob, I didn't inspect the log files. but when installing status doesn't show SQL Extension tasks such as Configuring SQL Server, Creating Database and Running SQL Scripts in Build 1602 where as in build 1526 it does. Also when I check the target SQL server instance installer (build with WiX 3.5 Beta Build 1602) has not created a database. Also Installer indicates successful installation. On Monday I can provide you the log files. Do you want log files for installers built with both builds or just build 1602 ? thanks. Regards, Asiri Wanigarathne http://www.asiri.name On 17 April 2010 00:12, Rob Mensching r...@robmensching.com wrote: Can you be a bit more specific about what is broken? Is there something in the log file showing the SQL Custom Action failing? On Fri, Apr 16, 2010 at 3:06 AM, Asiri Wanigarathne waas...@gmail.com wrote: Hi Folks, The database creation doesn’t work in the installer built with WIX 3.5 Beta 1602 as it did with WIX 3.5 Beta 1528 build and earlier builds. I tested it couple of times by going back and forth between WIX 3.5 beta build 1526 and build 1602 and I confirmed that database creation and running SQL scripts do not work in the installer build with WIX 3.5 Beta build 1602. I think SQL Extension is broken in the build 1602. Anyone else has noticed this issue with WIX 3.5 beta build 1602? Thanks. Regards, Asiri Wanigarathne http://www.asiri.name -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- virtually, Rob Mensching - http://RobMensching.com LLC -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] SQL Extension broken in WIX 3.5 Beta build 1602?
Hi Folks, The database creation doesn’t work in the installer built with WIX 3.5 Beta 1602 as it did with WIX 3.5 Beta 1528 build and earlier builds. I tested it couple of times by going back and forth between WIX 3.5 beta build 1526 and build 1602 and I confirmed that database creation and running SQL scripts do not work in the installer build with WIX 3.5 Beta build 1602. I think SQL Extension is broken in the build 1602. Anyone else has noticed this issue with WIX 3.5 beta build 1602? Thanks. Regards, Asiri Wanigarathne http://www.asiri.name -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] SQL Extension broken in WIX 3.5 Beta build 1602?
Rob, I didn't inspect the log files. but when installing status doesn't show SQL Extension tasks such as Configuring SQL Server, Creating Database and Running SQL Scripts in Build 1602 where as in build 1526 it does. Also when I check the target SQL server instance installer (build with WiX 3.5 Beta Build 1602) has not created a database. Also Installer indicates successful installation. On Monday I can provide you the log files. Do you want log files for installers built with both builds or just build 1602 ? thanks. Regards, Asiri Wanigarathne http://www.asiri.name On 17 April 2010 00:12, Rob Mensching r...@robmensching.com wrote: Can you be a bit more specific about what is broken? Is there something in the log file showing the SQL Custom Action failing? On Fri, Apr 16, 2010 at 3:06 AM, Asiri Wanigarathne waas...@gmail.com wrote: Hi Folks, The database creation doesn’t work in the installer built with WIX 3.5 Beta 1602 as it did with WIX 3.5 Beta 1528 build and earlier builds. I tested it couple of times by going back and forth between WIX 3.5 beta build 1526 and build 1602 and I confirmed that database creation and running SQL scripts do not work in the installer build with WIX 3.5 Beta build 1602. I think SQL Extension is broken in the build 1602. Anyone else has noticed this issue with WIX 3.5 beta build 1602? Thanks. Regards, Asiri Wanigarathne http://www.asiri.name -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- virtually, Rob Mensching - http://RobMensching.com LLC -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] (no subject)
Hi Folks, I am trying to configure MS DTC by modifying the registry entries. As following: Component Id=compMSDTC Guid={D8E711B5-851A-4ac7-80A5-F2665139C67B} ServiceControl Id=serviceMSDTCStop Name=MSDTC Stop=install Wait=yes / RegistryKey Root=HKLM Key=SOFTWARE\Microsoft\MSDTC RegistryValue Name=AllowOnlySecureRpcCalls Type=integer Value=1 / RegistryKey Key=Security RegistryValue Name=NetworkDtcAccess Type=integer Value=1 / RegistryValue Name=NetworkDtcAccessInbound Type=integer Value=1 / RegistryValue Name=NetworkDtcAccessOutbound Type=integer Value=1 / RegistryValue Name=NetworkDtcAccessTip Type=integer Value=1 / RegistryValue Name=NetworkDtcAccessTransactions Type=integer Value=1 / /RegistryKey /RegistryKey ServiceControl Id=serviceMSDTCStart Name=MSDTC Start=install Wait=no / /Component But when I uninstall the product it removes all the modified registry values. Because if this MS DTC will not start after removing the product. Is it possible to retain the registry modifications? I am not removing any MS DTC configurations on uninstall because this might cause other applications depending on MS DTC to stop working. Thanks Regards, Asiri Wanigarathne -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Create MS SQL Server 2008 database during installation.
thanks guys, I got rid of the user and the following worked fine: sql:SqlDatabase Id=testDB ContinueOnError=no CreateOnInstall=yes DropOnUninstall=yes Server=[DBSERVER] Database=TestDatabase/ Regards, Asiri Wanigarathne On 26 March 2010 11:54, Bob Arnson b...@joyofsetup.com wrote: On 3/25/2010 1:46 AM, Michael Osmond wrote: Error 0x80004005: failed to create to database: 80004005 - is Access Denied. That's 0x80040005; 0x80004005 is E_FAIL. -- sig://boB http://joyofsetup.com/ -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Create MS SQL Server 2008 database during installation.
Hi Bob, thanks for the reply. here are the few linnes from the log just before the error occured. I tried it on SQL server 2005 express installation. My target is SQL Server 2008. MSI (s) (40:80) [15:38:34:583]: File: C:\Program Files\WIX\WindowsFormsApplication1.exe;To be installed;Won't patch;No existing file MSI (s) (40:80) [15:38:34:583]: Source for file 'filF7ACBEF0DD4EC370428FC8B34F8A49E4' is compressed MSI (s) (40:80) [15:38:34:593]: SOFTWARE RESTRICTION POLICY: Verifying object -- 'C:\WINDOWS\Installer\333e3.msi' against software restriction policy MSI (s) (40:80) [15:38:34:593]: Note: 1: 2262 2: DigitalSignature 3: -2147287038 MSI (s) (40:80) [15:38:34:593]: SOFTWARE RESTRICTION POLICY: C:\WINDOWS\Installer\333e3.msi is not digitally signed MSI (s) (40:80) [15:38:34:593]: SOFTWARE RESTRICTION POLICY: C:\WINDOWS\Installer\333e3.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (40:80) [15:38:34:593]: Note: 1: 2318 2: C:\Program Files\WIX\WindowsFormsApplication1.exe MSI (s) (40:80) [15:38:34:593]: Executing op: CacheSizeFlush(,) MSI (s) (40:80) [15:38:34:593]: Executing op: InstallProtectedFiles(AllowUI=1) MSI (s) (40:80) [15:38:34:593]: Executing op: ActionStart(Name=CreateDatabase,Description=Creating Databases,) MSI (s) (40:80) [15:38:34:593]: Executing op: CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**,CustomActionData=**) MSI (s) (40:78) [15:38:34:603]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI5.tmp, Entrypoint: CreateDatabase CreateDatabase: Error 0x80004005: failed to create to database: 'TestDatabase', error: unknown error MSI (c) (2C:30) [15:38:51:175]: Font created. Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg Error 26201. Error -2147467259: failed to create SQL database: TestDatabase, error detail: unknown error. MSI (s) (40!7C) [15:38:53:449]: Product: WIX -- Error 26201. Error -2147467259: failed to create SQL database: TestDatabase, error detail: unknown error. Action ended 15:38:53: InstallFinalize. Return value 3. also attached the full log file. thanks Regards, Asiri Wanigarathne On 25 March 2010 07:17, Bob Arnson b...@joyofsetup.com wrote: On 3/22/2010 10:36 PM, Asiri Wanigarathne wrote: My installer fails with following error message: Error – 2147467259. Failed to create SQL database. TestDatabase, error detail: unknown error. There's additional logging before that line that might be helpful to pinpoint the cause. -- sig://boB http://joyofsetup.com/ -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Create MS SQL Server 2008 database during installation.
Hi Folks, I am working on a WIX installer project that requires creating a MS SQL Server database on SQL Server 2008. My installer fails with following error message: Error – 2147467259. Failed to create SQL database. TestDatabase, error detail: unknown error. To isolate the issue I created a new project. That only creates the SQL server database. I found the installer adds a new user to local users with given user credentials. Anyone has come across this error before? Any work abounds? WIX Prooject Source code: ?xml version=1.0 encoding=UTF-8? Wix xmlns=http://schemas.microsoft.com/wix/2006/wi; xmlns:sql=http://schemas.microsoft.com/wix/SqlExtension; xmlns:util=http://schemas.microsoft.com/wix/UtilExtension; Product Id=02d96309-6e59-45a2-9094-9d738fa6bd30 Name=WIX Language=1033 Version=1.0.0.0 Manufacturer=WIX UpgradeCode=4169c4e0-054c-4166-900a-1c8c30c62175 Package InstallerVersion=200 Compressed=yes / Media Id=1 Cabinet=media1.cab EmbedCab=yes / util:User Id=User Name=TestUser Password=TestPassword/ Directory Id=TARGETDIR Name=SourceDir Directory Id=ProgramFilesFolder Directory Id=INSTALLLOCATION Name=WIX Component Id=ProductComponent Guid=f2c5d3af-bea8-45db-89ca-f9039bcf3af1 CreateFolder / sql:SqlDatabase Id=testDB ContinueOnError=no CreateOnInstall=yes DropOnUninstall=yes Server=(local) Instance=MSSQLSERVER Database=TestDatabase User=User/ /Component /Directory /Directory /Directory Feature Id=ProductFeature Title=WIX Level=1 ComponentRef Id=ProductComponent / ComponentGroupRef Id=Product.Generated / /Feature /Product /Wix Thanks, Regards, Asiri Wanigarathne -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] install SQL server with mixed mode authentication
Hi Shabbir, Try changing the following Command node of package.xml located at C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\SqlExpress\en: Command PackageFile=sqlexpr32.exe Arguments='-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1' EstimatedInstalledBytes=22500 EstimatedTempBytes=22500 EstimatedInstallSeconds=420 change the arguments attribute to allow mixed mode authentication. hope this helps. Regards, Asiri Wanigarathne On 19 March 2010 02:23, Shabbir Ahsan shabbir_ah...@hotmail.com wrote: HI, I have included SQL server 2005 express via the bootstrapper on my install. The problem I am getting is when the installation is complete, I find the website installed cannot connect to the DB and neither cna the windows service. The reason being that the server has been installed with the default windows authentication. I then have to download SQL management studio and then enable SQL Server and Windows authentication mode. The question is, can I not set this at install time, so everything just works out of the box. I have looked at SQL scripts, and they just return in errors. I have found that a command can be used when installing, but how can this be included with the bootstrapper? Thanks _ We want to hear all your funny, exciting and crazy Hotmail stories. Tell us now http://clk.atdmt.com/UKM/go/195013117/direct/01/ -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Pass selected Features as parameters to custom action
thanks mate you are spot on schdule it after CostFinalize and it worked fine. Regards, Asiri Wanigarathne On 4 March 2010 13:06, jnanneng john.nanne...@microsoft.com wrote: Costing operations haven't occurred at the time the CA is being scheduled so the feature state items are not set, yet. -- View this message in context: http://n2.nabble.com/Pass-selected-Features-as-parameters-to-custom-action-tp4657879p4671925.html Sent from the wix-users mailing list archive at Nabble.com. -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users