Search code examples
installationwindows-installernsis

Installer installing on two machines

I need to create one installer which will install components on two different machines.Windows services and web services on "APP Server" and database part on "DB Server". SQL Server 2005/2008 will be already present on DB SERVER. But it may use different port than default port for sql server.

What things I will require in order to implement this ?

Thanks in advance.

Solution

  • It is simply a matter of bundling a SQL script with the installer and executing the script by calling sqlcmd with ExecWait.

    We can run a script using a trusted connection via:

    sqlcmd -S _SERVER\_INSTANCE_ -d _DBNAME_ -i _SCRIPT_FILE_

    Or with a SQL Login:

    sqlcmd -S _SERVER\_INSTANCE_ -d _DBNAME_ -U _USERNAME_ -P _PASSWORD_ -i _SCRIPT_FILE_

    For performing actions on remote SQL Server engine native driver is required.In SQL Server 2005 or later the command line client is called sqlcmd.