I have programmed a bootstrapper project with WiX 3.8. In my setup i create in my MSI a new local user (if he doesn't exist). Then i'm installing (as a prerequisite) SQL Server Express and create a SQL Server instance called "SQLEXPRESS". After this i want to create a SQL Server login with SQLAuthentication using the new local user. So i tried it with these lines in my MSI:
<Component Id="CreateSqlLogin" Guid="3283AD6D-B870-4D09-A414-1A9D56A1398C" Directory="TARGETDIR"> <sql:SqlDatabase Id="SqlDatabase" Database="master" Server="." Instance="SQLEXPRESS" CreateOnInstall="no" DropOnUninstall="no" DropOnReinstall="no" ContinueOnError="yes"> <sql:SqlString Id="CreateLogin" ContinueOnError="yes" ExecuteOnInstall="yes" ExecuteOnUninstall="no" ExecuteOnReinstall="no" Sequence="11000" SQL="IF NOT EXISTS (SELECT name FROM master.sys.server_pricipals WHERE name = '[DBUSER_PROP]) BEGIN EXEC sp_addlogin '[DBUSER_PROP]','[DBPW_PROP]' END"></sql:SqlString> </sql:SqlDatabase> </Component> But even when i create a login with user AND password, i always get a login with WindowsAuthentication. What have i to do, to get a login with SQLAuthentication? 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-with-sqlauthorization-tp7598627.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users