Is there any way to recover failed instance of ThingWorx Navigate?

[Shripad]

Hi All,

I m trying to install ThingWorx Navigate of Version 8.5.3 but the installation is failed with error -

Setting variable validation_result from cmd
Error running cmd /c "sqlcmd" -S ****\****,**** -U **** -P "****" -Q "****": Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login failed for user 'tw1'. Reason: The password of the account must be changed..
[14:28:31] - SQL Server connection validation [FAILED]

Any suggestion?

Best Regards,

-Shripad

[raluca_edu]

Hi,

Don't know if it something specific to  Navigate, but from the error you need to check connectivity to database.

1. Can you connect with tw1 to MSSQL?

2. Port 1443 is open?

3. tw1 has a password that expired? Password has enough characters? 

4. What kind of authentication has MSSQL? I think Windows mode is not appropriate.

Hope it helps,

Raluca Edu

[Constantine]

Hello @Shripad,

It looks like the user tw1 was created with "Enforce password policy" option, which requires changing password on the first login. Either do it, or remove this policy.

You'll find details and examples if you google for "The password of the account must be changed" (with quotes).

/ Constantine