Heat Server setup fails with MSI Error message that a parameter is unknown

Version 1


    During ServerSetup.exe running a installation subroutine Service Catalog is using the provided SQL user and password as parameter to call the MSI. The SQL-User contained a quote " character which lead to corrupt the syntax of the MISEXEC parameters.

    see corrupt Example with SQL password 3?8GO"Lq,5
    "C:\Windows\System32\msiexec.exe" /i "C:\Users\Administrator\AppData\Local\Temp\1\{BE2FA00A-9D34-4559-A6E7-4D40543F739B}\{6F392EE3-2798-4BC6-8067-94C72688BF8E}\Frontrange Service Catalog.msi" /QB /L "C:\Users\Administrator\AppData\Local\Temp\1\ISTMcatalog.log" TEMPPLACE="" IS_SQLSERVER_PASSWORD="3?8GO"Lq,5" IS_SQLSERVER_USERNAME="SQL-ITSM" IS_SQLSERVER_SERVER="DB-SERVER.customer.com" IS_SQLSERVER_DATABASE="ITSM" INSTALLDIR="C:\Program Files (x86)\FrontRange Solutions\Service Management\" IS_SQLSERVER_AUTHENTICATION="" PARENT="ITSM7"


    Change the SQL user password not containing quotation marks or questions marks and change the SQL user password in SQL, then in the 2-tier connection and last in the connectionstrings.config file.