Article - CS339008

"Password: sqlcmd : Sqlcmd: '1433': Unexpected argument." is seen when running the AzureSQL Install Scripts on ThingWorx Platform

Modified: 16-Feb-2021   


Applies To

  • ThingWorx Platform 8.4 to 9.1
  • Windows Server

Description

  • AzureSQL scripts do not run with the correct syntax supplied
  • Installation Powerscript fail when following the instructions
  • ThingWorx Azure SQL database PowerShell scripts do not work correctly
  • Cannot execute thingworxAzureSingleInstanceDBSetup.ps1 or thingworxAzureSingleInstanceSchemaSetup.ps1 when attempting to install ThingWorx Platform backed by AzureSQL
  • Cannot progress Azure SQL ThingWorx install passed the database installation scripts
  • DB scripts failing for AzureSQL ThingWorx
  • Seeing the following when executing thingworxAzureSingleInstanceSchemaSetup.ps1:
    • sqlcmd -S $server\\$serverInstance,$port -U $sqlServerLoginName -d $database -i ...
      ...
      Setting up model schema...
      Password: sqlcmd : Sqlcmd: '1433': Unexpected argument. Enter '-?' for help.
      ...
This is a printer-friendly version of Article 339008 and may be out of date. For the latest version click CS339008