Hello,
From my setup I need to create a SQL Server database. I am taking a SQL
Server instance name, username and password from the user. I then try to
create the SQL database as below:
<Binary Id='CreateMyDB' SourceFile='MyDB.sql' />
<util:User Id='SQLUser' Name='[SQLNAME]' Password='[SQLPASS]' />
<DirectoryRef Id="TARGETDIR">
<Component Id='ComponentSqlCreateDB'
Guid='1F252BC2-7D01-4940-AE7A-EF69827A35F3'>
<sql:SqlDatabase Id='MyDB' Database='MyDatabase'
User='SQLUser' Server='[SQLINSTANCE]'
ConfirmOverwrite='yes'
CreateOnInstall='yes' ContinueOnError='no' >
<sql:SqlScript Id='CreateMyDB' BinaryKey='CreateMyDB'
ExecuteOnInstall='yes' ContinueOnError='no' />
</sql:SqlDatabase>
<Condition>NOT PRODUCTFOUND</Condition>
</Component>
</DirectoryRef>
But, I am getting the following error when the setup tries to create the
database:
MSI (s) (E8:DC) [15:49:13:162]: Running as a service.
MSI (s) (E8:DC) [15:49:13:162]: Hello, I'm your 32bit Elevated custom action
server.
MSI (s) (E8:FC) [15:49:13:287]: Executing op:
ActionStart(Name=CreateDatabase,Description=Creating Databases,)
Action 15:49:13: CreateDatabase. Creating Databases
MSI (s) (E8:FC) [15:49:13:287]: Executing op:
CustomActionSchedule(Action=CreateDatabase,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (E8:A8) [15:49:13:287]: Invoking remote custom action. DLL:
C:\Windows\Installer\MSIF388.tmp, Entrypoint: CreateDatabase
CreateDatabase: Error 0x80040e4d: failed to check if database exists:
'MyDatabase', error: unknown error
Error 26201. Error -2147217843: failed to create SQL database: MyDatabase,
error detail: unknown error.
Please let me know on how to fix this error. Thanks in advance.
Thanking You,
With Regards,
// Sudripta Nandy
S.D.E (Systems Programming),
SARANGSoft (India) Pvt. Ltd.
Kolkata, India.
Phone: +91 33 4008 9813. Extn: 24
Visit: http://www.sarangsoft.com/
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
