I think this is what you may be looking for. http://stackoverflow.com/questions/1601186/sql-server-script-to-create-a-new-user
I don't think you want to use ContinueOnError="yes". That way you may be able to see what is wrong if you use verbose logging and it might help. J On Wed, Jan 7, 2015 at 2:23 AM, patrickpirzer <patrick.pir...@prosoft.net> wrote: > I have programmed a bootstrapper-project with WiX 3.8. > While the installation i want to create a sql server login with > sql-authentication. > So i embedded in the Product.wxs of my MSI-Project the following component. > > <Component Id="CreateSqlLogin" > Guid="EB24CC36-D016-4E7C-A35D-26D31E1A5DFA" > Directory="TARGETDIR"> > <sql:SqlDatabase Id="SqlDatabase" > Database="testDb" > Server="." > Instance="SQLEXPRESS" > CreateOnInstall="yes" > DropOnUninstall="yes" > DropOnReinstall="no" > ContinueOnError="yes"> > <sql:SqlString Id="CreateLogin" > ContinueOnError="yes" > ExecuteOnInstall="yes" > ExecuteOnUninstall="no" > ExecuteOnReinstall="no" > Sequence="11000" > SQL="BEGIN > USE [master] > GO > CREATE LOGIN [MyUser] WITH > PASSWORD=N'YourPassword', DEFAULT_DATABASE=[master], > DEFAULT_LANGUAGE=[Deutsch], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON > GO > ALTER LOGIN [MyUser] DISABLE > GO > END"></sql:SqlString> > </sql:SqlDatabase> > </Component> > > But when i take a look into the logins with SQL Server Management, the > MyUser-login is not there. > Further i have the problem, that i don't want to create always the database > before creating the login. > Is there a way to do that? > > Thanks in advance! > > > > -- > View this message in context: > http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/How-to-create-a-sql-server-login-without-creating-a-database-tp7598746.html > Sent from the wix-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Dive into the World of Parallel Programming! The Go Parallel Website, > sponsored by Intel and developed in partnership with Slashdot Media, is > your > hub for all things parallel software development, from weekly thought > leadership blogs to news, videos, case studies, tutorials and more. Take a > look and join the conversation now. http://goparallel.sourceforge.net > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > -- "They may forget what you said but they will never forget how you made them feel." -- Anonymous ------------------------------------------------------------------------------ Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
