When installing the peer-to-peer distribution server, some instances need SQL Server Express. If your firewall rules on the peer-to-peer server block the free SQL Server Express download you can install the SQL Server Express manually.

Procedure

  1. Download SQL Server Express from http://redirect.adaptiva.cloud/sqlexpress2014 on a machine without firewall restrictions.
  2. On the server machine, copy and extract the downloaded SQL Server Express setup in c:\sqltemp.
  3. Enter the command-line parameter.
    C:\sqltemp\Setup.exe /q /Hideconsole /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /Features=SQLEngine /TCPENABLED=1 /BROWSERSVCSTARTUPTYPE=Automatic /AddCurrentUserAsSQLAdmin /SQLSYSADMINACCOUNTS="NT AUTHORITY\LOCAL SERVICE" "NT AUTHORITY\SYSTEM" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSVCSTARTUPTYPE=Automatic /INSTANCENAME=ADAPTIVASQL
  4. Run the peer-to-peer server installation wizard with the SQL Server Express.
    The system generates SQL setup logs in %temp%.