has anyone figured out how to get a remote sql db to fire off scripts on a
patch?
my initial install works fine, but the patch fails saying it can't connect
to [DBNAME].
<Fragment>
<util:User Id="sysadmin" Name="[DBUSERNAME]" Password="[DBUSERPW]"/>
<DirectoryRef Id="INSTALLDIR">
<Component Id="sql_db_remote_sql" Guid="xxxxxx"
SharedDllRefCount="yes">
<Condition>SQLTYPE=3</Condition>
<sql:SqlDatabase Id="sqltest_remote_sql" Database="[DBNAME]"
Server="[DBSERVERNAME]" ConfirmOverwrite="yes" CreateOnInstall="yes"
ContinueOnError="no" User="sysadmin">
<sql:SqlString Id="executesqlstring_createlogin" Sequence="1"
ExecuteOnInstall="yes" SQL="CREATE LOGIN [PROMPTEDUSER] WITH
PASSWORD='[PROMPTEDPASSWORD]', DEFAULT_DATABASE=[DBNAME]; USE [DBNAME];
CREATE USER [PROMPTEDUSER] FOR LOGIN [PROMPTEDUSER];" />
<sql:SqlString Id="executesqlstring_changedb_owner" Sequence="2"
ExecuteOnInstall="yes" SQL="EXEC sp_addrolemember 'db_owner',
'[PROMPTEDUSER]'" />
<sql:SqlScript Id="executesqlscript_remote_sql" Sequence="3"
ExecuteOnInstall="yes" ExecuteOnReinstall="yes" BinaryKey="SqlScript1" />
</sql:SqlDatabase>
<CreateFolder></CreateFolder>
</Component>
</DirectoryRef>
</Fragment>
Any ideas? I've tried so many different things. Thanks to anyone who can
shed some insight.
Chad
--
View this message in context:
http://n2.nabble.com/remote-sql-db-on-patch-tp1498996p1498996.html
Sent from the wix-users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
