When I run into weird SQL errors like that it is usually down to context, for example the language of the user accessing the db is different between your admin user (that you test with) and your WiX user. More likely, I think you are probably using different users and you have a permissions problem. Run SQL Server Profiler to see what is actually happening and under what user when you try to install.
Pankaj Bhatia wrote: > Hello > > I am new to wix and currently trying to install my sql schema using > wix's SQLExtension. here is my code - > > <Component Id="SlaDB" > Guid="15129d56-f448-4e22-82c5-0035af0099cd"> > <sql:SqlDatabase Id="ABCDatabase" Database="ABCDb" > Server="localhost\SQLEXPRESS" > CreateOnInstall="yes" DropOnUninstall="yes" > ContinueOnError="yes"> > <sql:SqlScript Id="CreateTables" ExecuteOnInstall="yes" > ExecuteOnUninstall="no" BinaryKey="CreateSLADbBin"/> > </sql:SqlDatabase> > <CreateFolder/> > </Component> > > My SQL script runs successfully if run directly with SQL express but > while installing thru wix I simply receive > "msierrSQLFailedCreateDatabase" error. Could anyone tell what is wrong. > I don't have the localization file for SQL extension( though I wrote > 10 basic variables). It would be great if someone could provide me > that loc in US-en. > > Thanks in advance. > Pankaj > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: The Future of Linux Business White Paper > from Novell. From the desktop to the data center, Linux is going > mainstream. Let it simplify your IT future. > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 > ------------------------------------------------------------------------ > > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------ > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.503 / Virus Database: 269.16.13/1170 - Release Date: 12/4/2007 > 10:52 > ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
