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
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users
