Update Password not working properly

[justinneff]

On multiple occasions, when I publish with the login password in single quotes, the password that gets updated for login in SQL Server is not correct. I have had to go in and manually change the password correctly.

This appears to only be an issue publishing from the command line as publishing from a node script does not suffer this issue. Suspect the problem has to do with the interpretation of the quoted arguments by yargs.

[justinneff]

I have tracked it down to what appears to be an issue in the yargs library. The caret (^) character is getting removed from the parsed parameter string value. Therefore any password containing a caret are being changed to a form without the caret.

I have opened an issue on the yargs project. yargs/yargs#860

[justinneff]

This is a Windows command shell issue. See this SO post. There are several characters that Windows command shell and powershell treat as special characters. The characters & | ( < > ^ are reserved characters and may cause problems.

Possible, workarounds would include reading password for a file or prompting the user for the passwords after launching the command.