Hi,
I am using the WixSQLExtension to create DBs to a remote server in network
as
<Component Id ="RUNSQL" Guid ="MY-GUID">
<util:User Id="MYUSER" Name ="[SQLUSERNAME]"
Password="[SQLPASSWORD]"/>
<sql:SqlDatabase Id ="sqldb" Database ="[LISTBOXPROP_DATABASE]" Server
="[SERVER]" User="MYUSER" CreateOnInstall="yes" ConfirmOverwrite ="no"
DropOnUninstall="no" ContinueOnError="no">
<sql:SqlScript Id ="sqlscript" BinaryKey
="binary_sqlscript" Sequence ="1" ExecuteOnInstall ="yes" />
</sql:SqlDatabase>
</Component>
*Environment:-*
1. We are using SQL server 2000
*Problem:-*
1. gets an error as "Not able to create user MYUSER as it has an invalid
password."
here are my follow-up on the same issue:-
1. i have used the same username and password in the SQL authentication
dialog in th UI to connect to the database and it worked perfectly fine.
2. after long time of googling and using HIT and TRIALS method, i found out
that if we follow PASSWORD policies for the SQLSERVER then it is writing the
DB as we expect it to do.
3. The same thing is possible when we do it in INSTALLSHIELD.
4. Am i missing something here or some attribute/property to set in my
package which will take help resolve my problem.
Any sort of help on this issue will be highly appreciated!
--
Cheers,
Akash
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
