Re: [WiX-users] Create MS SQL Server 2008 database during installation.
I hate decoding custom action types - what's the impersonation setting there? If the custom action is running with no impersonation it's running with the local system account, and that probably doesn't have the rights to create a database. Is there a good reason to create the database at install time instead of just shipping it in your setup? Phil Wilson -Original Message- From: Michael Osmond [mailto:mosm...@baytech.com.au] Sent: Wednesday, March 24, 2010 10:47 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Create MS SQL Server 2008 database during installation. Hi Error 0x80004005: failed to create to database: 80004005 - is Access Denied. Regards Michael -Original Message- From: Asiri Wanigarathne [mailto:waas...@gmail.com] Sent: Thursday, 25 March 2010 3:43 PM To: General discussion for Windows Installer XML toolset. Subject: 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 *** Confidentiality Notice: This e-mail, including any associated or attached files, is intended solely for the individual or entity to which it is addressed. This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify the sender immediately by reply e-mail and then delete this message from
Re: [WiX-users] Create MS SQL Server 2008 database during installation.
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
Re: [WiX-users] Create MS SQL Server 2008 database during installation.
On 3/25/2010 1:43 AM, Asiri Wanigarathne wrote: CreateDatabase: Error 0x80004005: failed to create to database: 'TestDatabase', error: unknown error Any error at this point should also have logged additional errors, so I can't explain why you're not seeing them. That said, you're creating a user and trying to connect to the database as that user, so I wouldn't expect that to work. The user needs to already have SQL permissions. Try omitting the user info to use Windows authentication. -- 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
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.
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
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
Re: [WiX-users] Create MS SQL Server 2008 database during installation.
Hi Error 0x80004005: failed to create to database: 80004005 - is Access Denied. Regards Michael -Original Message- From: Asiri Wanigarathne [mailto:waas...@gmail.com] Sent: Thursday, 25 March 2010 3:43 PM To: General discussion for Windows Installer XML toolset. Subject: 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