Hello! I use WIX to create an ApplicationPool and a DataBase. I use <Component Id="iis_AppPool" Guid="C70C5742-A4EB-468D-82F1-972497672638"> <iis:WebAppPool Id="AP_MyApp" Name="MyAppPool" ManagedRuntimeVersion="v4.0" ManagedPipelineMode="integrated" /> /Component>
to create an ApplicationPool And I want to make a Login on SQL Server for 'IIS AppPool\MyAppPool' account. I make a query to SQL Server using wix extension <sql:SQLScript> <Component Id="ServerDB" Guid="A2D87274-BE77-49AD-9BF4-F689A9685EBB" KeyPath ="yes"> <sql:SqlDatabase Id="ServerDB" Database="ServerDB " Server="[SQLSERVER_SELECTED]" CreateOnInstall="yes" > <sql:SqlScript Id ="ServerDB" BinaryKey="installdb.sql" ExecuteOnInstall=" yes" Sequence="1" /> </sql:SqlDatabase> </Component> installdb.sql script is simply do this CREATE LOGIN [IIS AppPool\MyAppPool] FROM WINDOWS; But during the installation process I get an error that "User or group IIS AppPool\DSS_AppPool is not found". I suppose it occurs because ConfigureIIs custom action is sheduled after creating the DataBase and executing of sql scripts. Is it possible to manually shedule the exucuting of sql scripts to avoid such an error? Thanks in advance. P.S. I tried to add such string to <InstallExecuteSequence> <Custom Action="ExecuteSqlStrings" After="ConfigureIIs"></Custom> but it doesn't help. -- George May the Force be with you. ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnmore_122712 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
