Re: [WiX-users] Error database does not exist when executing ExecuteSQLStrings
Thanks for the reply! After looking at the verbose log I didn't see where the database was being created so I removed the condition and changed the SQLDatabase to use 'sa' with a password. I'm now receiving errors when the database is being created... Action 12:18:29: CreateDatabase. Creating Databases MSI (s) (C4:6C) [12:18:29:608]: Executing op: CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**,CustomActionData=**) MSI (s) (C4:C0) [12:18:29:624]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI66CF.tmp, Entrypoint: CreateDatabase CreateDatabase: Error 0x80004005: failed to create to database: 'mvdb', error: unknown error Error 26201. Error -2147467259: failed to create SQL database: mvdb, error detail: unknown error. MSI (s) (C4!E4) [12:18:57:695]: Product: Guru Teach Server Installation -- Error 26201. Error -2147467259: failed to create SQL database: mvdb, error detail: unknown error. CustomAction CreateDatabase returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox) Action ended 12:18:57: InstallFinalize. Return value 3. The product.was now looks like this... util:User Id='SQLUser' Name='sa' Password='' / Component Id='SqlComponent' Guid='A60B1852-7C4B-402B-A619-EECA2893C5AC' KeyPath='yes' sql:SqlDatabase Id='SqlDatabase' Database='mvdb' Server='MVSQLEXPRESS' User='SQLUser' CreateOnInstall='yes' DropOnUninstall='no' ContinueOnError='no'/ sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes BinaryKey=CreateUsersSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes BinaryKey=CreateBaseLineDbSql SqlDb=SqlDatabase/ sql:SqlScript Id=RemoveOldGuruContent ExecuteOnInstall=yes BinaryKey=RemoveOldGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=Upgrade ExecuteOnInstall=yes BinaryKey=UpgradeSql SqlDb=SqlDatabase/ sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes BinaryKey=AddCompleteMediaSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallGuruContent ExecuteOnInstall=yes BinaryKey=InstallGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes BinaryKey=UpdateCustomPlayListSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes BinaryKey=InstallFeaturedContentSql SqlDb=SqlDatabase/ /Component I have installed SQL Management Studio on my test machine. After the installation I logged on using the 'sa' user and manually created the mvdb database without a problem. I have also uploaded the complete verbose log but I don't see anything else that could be the cause of the problem. Thanks, Gary serverinstall.log http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/file/n7597803/serverinstall.log -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-database-does-not-exist-when-executing-ExecuteSQLStrings-tp7597477p7597803.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
Re: [WiX-users] Error database does not exist when executing ExecuteSQLStrings
Hi, Is there anyone that has created a database using SQL scripts? I have a requirement to complete this installer and I can't get the database created. Thanks, Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-database-does-not-exist-when-executing-ExecuteSQLStrings-tp7597477p7597758.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
Re: [WiX-users] Error database does not exist when executing ExecuteSQLStrings
From your log: 1) is 'SqlComponent' being selected for install? If so, 2) What is the value of the property USEINTEGRATEDSECURITY from the verbose log? Note that this property is going to have to be remembered for repair, upgrade, and patching to work. Note also that it will currently only be evaluated the first time the Component is consider for install since the Component is not marked transitive. This may or may not be what you want. 3) What is the instance you are trying to install to? This method has known issues installing to default instances. I highly recommend installing only to named instances. 4) What are the permissions of the installing user? Some of these scripts appear to require Administrator rights on either the installing compute or the SQL server or both. 5) What does the verbose log look like? Most of these issues can be easily diagnosed from a verbose log, but I'm just guessing without one. In answer to your later post, I have done this many, many times. But I'm currently at the end of a GA cycle on one of my products, and I therefore have limited time. -- John Merryweather Cooper Senior Software Engineer | Enterprise Service Applications | Continuing Development Jack Henry Associates, Inc.® | Lenexa, KS 66214 | Ext: 431050 |jocoo...@jackhenry.com -Original Message- From: garymonk [mailto:g...@gurudental.com] Sent: Friday, October 24, 2014 5:28 PM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Error database does not exist when executing ExecuteSQLStrings I changed my product.was to the following but when I test it it doesn't create the database. I don't receive any errors when I run it, it just doesn't create anything. My product.was... Component Id='SqlComponent' Guid='A60B1852-7C4B-402B-A619-EECA2893C5AC' KeyPath='yes' ConditionUSEINTEGRATEDSECURITY = 1/Condition sql:SqlDatabase Id='SqlDatabase' Database='mvdb' Server='MVSQLEXPRESS' CreateOnInstall='yes' DropOnUninstall='no' ContinueOnError='no'/ sql:SqlScript Id=CreateDatabase ExecuteOnInstall=yes BinaryKey=CreateDatabaseSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes BinaryKey=CreateUsersSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes BinaryKey=CreateBaseLineDbSql SqlDb=SqlDatabase/ sql:SqlScript Id=RemoveOldGuruContent ExecuteOnInstall=yes BinaryKey=RemoveOldGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=Upgrade ExecuteOnInstall=yes BinaryKey=UpgradeSql SqlDb=SqlDatabase/ sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes BinaryKey=AddCompleteMediaSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallGuruContent ExecuteOnInstall=yes BinaryKey=InstallGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes BinaryKey=UpdateCustomPlayListSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes BinaryKey=InstallFeaturedContentSql SqlDb=SqlDatabase/ /Component Feature Id=Server Title=Guru Teach Server Level=1 ComponentRef Id=RegistryEntries/ ComponentRef Id='CreateDtxDataUser.exe' / ComponentRef Id='Guru.Server.exe' / ComponentRef Id='ChangeFirewall' / ComponentRef Id='Guru.Server.exe.config' / ComponentRef Id='Guru.Server.Remoting.dll' / ComponentRef Id='Guru.ServerLibrary.dll' / ComponentRef Id='Ionic.Zip.Reduced.dll' / ComponentRef Id='JsonChannel.dll' / ComponentRef Id='license.dat' / ComponentRef Id='Microsoft.Practices.Prism.dll' / ComponentRef Id='Microsoft.Practices.ServiceLocation.dll' / ComponentRef Id='SQLExpressProvider.dll' / ComponentRef Id='Guru_Featured_manifest.xml' / ComponentRef Id='GURU_Library_manifest.xml' / ComponentRef Id='Guru.Server.Configuration.dll' / ComponentRef Id='SqlComponent'/ /Feature Tanks for the help! Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-database-does-not-exist-when-executing-ExecuteSQLStrings-tp7597477p7597489.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 NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies
[WiX-users] Error database does not exist when executing ExecuteSQLStrings
I have an installer that needs to execute a number of sql scripts. For some
reason they are not getting executed and so I receive the above message.
here is my Product.was file..
?xml version=1.0 encoding=UTF-8?
Wix xmlns=http://schemas.microsoft.com/wix/2006/wi;
xmlns:fire=http://schemas.microsoft.com/wix/FirewallExtension;
xmlns:sql=http://schemas.microsoft.com/wix/SqlExtension;
xmlns:util=http://schemas.microsoft.com/wix/UtilExtension;
Product Id=* Name=Guru Teach Server Installation Language=1033
Version=6.0.4.0 Manufacturer=Guru Dental
UpgradeCode=76c642f5-9ef3-4575-8ce1-05dd36ea4195
Package InstallerVersion=200 Compressed=yes
InstallScope=perMachine Id=* Platform=x86/
MajorUpgrade DowngradeErrorMessage=A newer version of [ProductName] is
already installed. /
Media Id='1' Cabinet='Data.cab' EmbedCab='yes' DiskPrompt='Please
insert DVD #1' /
Property Id='DiskPrompt' Value=Guru Teach Installation [1] /
Property Id=ARPPRODUCTICON Value=guru.ico /
Property Id='CHGFIREWALL' Value='False' Secure='yes'/
UI Id=MyWixUI_Mondo
UIRef Id=WixUI_Mondo /
UIRef Id=WixUI_ErrorProgressText /
DialogRef Id=FirewallDlg /
Publish Dialog=WelcomeDlg Control=Next Event=NewDialog
Value=FirewallDlg Order=11/Publish
Publish Dialog=SetupTypeDlg Control=Back Event=NewDialog
Value=FirewallDlg1/Publish
/UI
sql:SqlDatabase Id=SqlDatabase Database=master Server=localhost
Instance=MVSQLEXPRESS /
Directory Id=TARGETDIR Name=SourceDir
Component Id=RegistryEntries
Guid={E677A056-74D9-4AF0-BC88-A4BE8C237E5E}
RegistryKey Root=HKLM Key=Software\Reality Engineering,
Inc.\Medvisor Dental ForceDeleteOnUninstall=yes
RegistryValue Type=string Name=INSTALLDIR
Value=[APPLICATIONROOTDIR]/
RegistryValue Type=string Name=ProgName Value=Guru
KeyPath=yes/
/RegistryKey
/Component
Directory Id=ProgramFilesFolder
Directory Id=APPLICATIONROOTDIRECTORY Name=Guru
Directory Id=AdditionalFolders
Directory Id=SERVER Name=Server
Directory Id=MANIFESTS Name=Manifests /
Directory Id=MODULES Name=Modules /
/Directory
/Directory
/Directory
/Directory
/Directory
Binary Id=CreateDatabaseSql SourceFile=SQL
Scripts\CreateDatabase.sql /
Binary Id=CreateUsersSql SourceFile=SQL Scripts\CreateUsers.sql /
Binary Id=CreateBaseLineDbSql SourceFile=SQL
Scripts\CreateBaseLineDb.sql /
Binary Id=RemoveOldGuruContentSql SourceFile=SQL
Scripts\RemoveOldGuruContent.sql /
Binary Id=UpgradeSql SourceFile=SQL Scripts\Upgrade.sql /
Binary Id=AddCompleteMediaSql SourceFile=SQL Scripts\Upgrade.sql
/
Binary Id=InstallGuruContentSql SourceFile=SQL
Scripts\InstallGuruContent.sql /
Binary Id=UpdateCustomPlayListSql SourceFile=SQL
Scripts\UpdateCustomPlayList.sql /
Binary Id=InstallFeaturedContentSql SourceFile=SQL
Scripts\InstallFeaturedContent.sql /
DirectoryRef Id=SERVER
Component Id='CreateDtxDataUser.exe'
Guid='26f80392-dcbe-47af-a7e0-d187cbec0e15'
File Id='CreateDtxDataUser.exe' Source='C:\VS
Publish\Guru\ProgramFiles\Guru\Server\CreateDtxDataUser.exe' KeyPath='yes'/
/Component
Component Id='Guru.Server.exe'
Guid='8027388d-0f90-465b-9668-d1388977caaa'
File Id='Guru.Server.exe' Source='C:\VS
Publish\Guru\ProgramFiles\Guru\Server\Guru.Server.exe' KeyPath='yes'/
ServiceInstall
Id=ServiceInstaller
Type=ownProcess
Name=GuruService
DisplayName=Guru Media and Licensing Service
Description=Provides media distribution, data coordination, and
licensing services to the Guru application
Start=auto
Account=[SERVICEACCOUNT]
Password=[SERVICEPASSWORD]
ErrorControl=normal
/
ServiceControl Id=StartService Start=install Stop=both
Remove=uninstall Name=GuruService Wait=yes /
sql:SqlScript Id=CreateDatabase ExecuteOnInstall=yes
BinaryKey=CreateDatabaseSql SqlDb=SqlDatabase/
sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes
BinaryKey=CreateUsersSql SqlDb=SqlDatabase/
sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes
BinaryKey=CreateBaseLineDbSql SqlDb=SqlDatabase/
sql:SqlScript Id=RemoveOldGuruContent ExecuteOnInstall=yes
BinaryKey=RemoveOldGuruContentSql SqlDb=SqlDatabase/
sql:SqlScript Id=Upgrade ExecuteOnInstall=yes
BinaryKey=UpgradeSql SqlDb=SqlDatabase/
sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes
BinaryKey=AddCompleteMediaSql SqlDb=SqlDatabase/
sql:SqlScript Id=InstallGuruContent ExecuteOnInstall=yes
BinaryKey=InstallGuruContentSql SqlDb=SqlDatabase/
sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes
BinaryKey=UpdateCustomPlayListSql SqlDb=SqlDatabase/
sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes
BinaryKey=InstallFeaturedContentSql SqlDb=SqlDatabase/
Re: [WiX-users] Error database does not exist when executing ExecuteSQLStrings
If you're creating a database using script, I would recommend a separate
component with a sql:SqlDatabase element wrapped around the sql:SqlScript
elements.
--
John Merryweather Cooper
Senior Software Engineer | Enterprise Service Applications | Continuing
Development
Jack Henry Associates, Inc.® | Lenexa, KS 66214 | Ext: 431050
|jocoo...@jackhenry.com
-Original Message-
From: garymonk [mailto:g...@gurudental.com]
Sent: Friday, October 24, 2014 4:06 PM
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] Error database does not exist when executing
ExecuteSQLStrings
I have an installer that needs to execute a number of sql scripts. For some
reason they are not getting executed and so I receive the above message.
here is my Product.was file..
?xml version=1.0 encoding=UTF-8?
Wix xmlns=http://schemas.microsoft.com/wix/2006/wi;
xmlns:fire=http://schemas.microsoft.com/wix/FirewallExtension;
xmlns:sql=http://schemas.microsoft.com/wix/SqlExtension;
xmlns:util=http://schemas.microsoft.com/wix/UtilExtension;
Product Id=* Name=Guru Teach Server Installation Language=1033
Version=6.0.4.0 Manufacturer=Guru Dental
UpgradeCode=76c642f5-9ef3-4575-8ce1-05dd36ea4195
Package InstallerVersion=200 Compressed=yes
InstallScope=perMachine Id=* Platform=x86/
MajorUpgrade DowngradeErrorMessage=A newer version of [ProductName] is
already installed. /
Media Id='1' Cabinet='Data.cab' EmbedCab='yes' DiskPrompt='Please insert
DVD #1' /
Property Id='DiskPrompt' Value=Guru Teach Installation [1] /
Property Id=ARPPRODUCTICON Value=guru.ico /
Property Id='CHGFIREWALL' Value='False' Secure='yes'/
UI Id=MyWixUI_Mondo
UIRef Id=WixUI_Mondo /
UIRef Id=WixUI_ErrorProgressText /
DialogRef Id=FirewallDlg /
Publish Dialog=WelcomeDlg Control=Next Event=NewDialog
Value=FirewallDlg Order=11/Publish
Publish Dialog=SetupTypeDlg Control=Back Event=NewDialog
Value=FirewallDlg1/Publish
/UI
sql:SqlDatabase Id=SqlDatabase Database=master Server=localhost
Instance=MVSQLEXPRESS /
Directory Id=TARGETDIR Name=SourceDir
Component Id=RegistryEntries
Guid={E677A056-74D9-4AF0-BC88-A4BE8C237E5E}
RegistryKey Root=HKLM Key=Software\Reality Engineering,
Inc.\Medvisor Dental ForceDeleteOnUninstall=yes
RegistryValue Type=string Name=INSTALLDIR
Value=[APPLICATIONROOTDIR]/
RegistryValue Type=string Name=ProgName Value=Guru
KeyPath=yes/
/RegistryKey
/Component
Directory Id=ProgramFilesFolder
Directory Id=APPLICATIONROOTDIRECTORY Name=Guru
Directory Id=AdditionalFolders
Directory Id=SERVER Name=Server
Directory Id=MANIFESTS Name=Manifests /
Directory Id=MODULES Name=Modules /
/Directory
/Directory
/Directory
/Directory
/Directory
Binary Id=CreateDatabaseSql SourceFile=SQL Scripts\CreateDatabase.sql
/
Binary Id=CreateUsersSql SourceFile=SQL Scripts\CreateUsers.sql /
Binary Id=CreateBaseLineDbSql SourceFile=SQL
Scripts\CreateBaseLineDb.sql /
Binary Id=RemoveOldGuruContentSql SourceFile=SQL
Scripts\RemoveOldGuruContent.sql /
Binary Id=UpgradeSql SourceFile=SQL Scripts\Upgrade.sql /
Binary Id=AddCompleteMediaSql SourceFile=SQL Scripts\Upgrade.sql
/
Binary Id=InstallGuruContentSql SourceFile=SQL
Scripts\InstallGuruContent.sql /
Binary Id=UpdateCustomPlayListSql SourceFile=SQL
Scripts\UpdateCustomPlayList.sql /
Binary Id=InstallFeaturedContentSql SourceFile=SQL
Scripts\InstallFeaturedContent.sql /
DirectoryRef Id=SERVER
Component Id='CreateDtxDataUser.exe'
Guid='26f80392-dcbe-47af-a7e0-d187cbec0e15'
File Id='CreateDtxDataUser.exe' Source='C:\VS
Publish\Guru\ProgramFiles\Guru\Server\CreateDtxDataUser.exe' KeyPath='yes'/
/Component
Component Id='Guru.Server.exe'
Guid='8027388d-0f90-465b-9668-d1388977caaa'
File Id='Guru.Server.exe' Source='C:\VS
Publish\Guru\ProgramFiles\Guru\Server\Guru.Server.exe' KeyPath='yes'/
ServiceInstall
Id=ServiceInstaller
Type=ownProcess
Name=GuruService
DisplayName=Guru Media and Licensing Service
Description=Provides media distribution, data coordination, and
licensing services to the Guru application
Start=auto
Account=[SERVICEACCOUNT]
Password=[SERVICEPASSWORD]
ErrorControl=normal
/
ServiceControl Id=StartService Start=install Stop=both
Remove=uninstall Name=GuruService Wait=yes /
sql:SqlScript Id=CreateDatabase ExecuteOnInstall=yes
BinaryKey=CreateDatabaseSql SqlDb=SqlDatabase/
sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes
BinaryKey=CreateUsersSql SqlDb=SqlDatabase/
sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes
BinaryKey=CreateBaseLineDbSql SqlDb=SqlDatabase/
sql:SqlScript Id=RemoveOldGuruContent ExecuteOnInstall=yes
Re: [WiX-users] Error database does not exist when executing ExecuteSQLStrings
I changed my product.was to the following but when I test it it doesn't create the database. I don't receive any errors when I run it, it just doesn't create anything. My product.was... Component Id='SqlComponent' Guid='A60B1852-7C4B-402B-A619-EECA2893C5AC' KeyPath='yes' ConditionUSEINTEGRATEDSECURITY = 1/Condition sql:SqlDatabase Id='SqlDatabase' Database='mvdb' Server='MVSQLEXPRESS' CreateOnInstall='yes' DropOnUninstall='no' ContinueOnError='no'/ sql:SqlScript Id=CreateDatabase ExecuteOnInstall=yes BinaryKey=CreateDatabaseSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateUsers ExecuteOnInstall=yes BinaryKey=CreateUsersSql SqlDb=SqlDatabase/ sql:SqlScript Id=CreateBaseLineDb ExecuteOnInstall=yes BinaryKey=CreateBaseLineDbSql SqlDb=SqlDatabase/ sql:SqlScript Id=RemoveOldGuruContent ExecuteOnInstall=yes BinaryKey=RemoveOldGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=Upgrade ExecuteOnInstall=yes BinaryKey=UpgradeSql SqlDb=SqlDatabase/ sql:SqlScript Id=AddCompleteMedia ExecuteOnInstall=yes BinaryKey=AddCompleteMediaSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallGuruContent ExecuteOnInstall=yes BinaryKey=InstallGuruContentSql SqlDb=SqlDatabase/ sql:SqlScript Id=UpdateCustomPlayList ExecuteOnInstall=yes BinaryKey=UpdateCustomPlayListSql SqlDb=SqlDatabase/ sql:SqlScript Id=InstallFeaturedContent ExecuteOnInstall=yes BinaryKey=InstallFeaturedContentSql SqlDb=SqlDatabase/ /Component Feature Id=Server Title=Guru Teach Server Level=1 ComponentRef Id=RegistryEntries/ ComponentRef Id='CreateDtxDataUser.exe' / ComponentRef Id='Guru.Server.exe' / ComponentRef Id='ChangeFirewall' / ComponentRef Id='Guru.Server.exe.config' / ComponentRef Id='Guru.Server.Remoting.dll' / ComponentRef Id='Guru.ServerLibrary.dll' / ComponentRef Id='Ionic.Zip.Reduced.dll' / ComponentRef Id='JsonChannel.dll' / ComponentRef Id='license.dat' / ComponentRef Id='Microsoft.Practices.Prism.dll' / ComponentRef Id='Microsoft.Practices.ServiceLocation.dll' / ComponentRef Id='SQLExpressProvider.dll' / ComponentRef Id='Guru_Featured_manifest.xml' / ComponentRef Id='GURU_Library_manifest.xml' / ComponentRef Id='Guru.Server.Configuration.dll' / ComponentRef Id='SqlComponent'/ /Feature Tanks for the help! Gary -- View this message in context: http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Error-database-does-not-exist-when-executing-ExecuteSQLStrings-tp7597477p7597489.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
