search

bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases
MIT License
31 stars 18 forks source link

Potential issue with special characters in password #39

Closed Steve-Mcl closed 3 years ago

Steve-Mcl commented 3 years ago

Ref: https://discourse.nodered.org/t/node-red-contrib-mssql-plus-0-5-1-cant-connect-to-mssql/32501/12?u=steve-mcl

change password of my previous account to: "123456789password" --> it worked--> no issue with my account's role or permission.

add "@" to my pass: "123456789password@" --> it doesn't work any more --> may be some issue if there is character "@" in password.

Steve-Mcl commented 3 years ago

Tested this out - cannot see an issue.

Hi kabuto-gyu I have tried setting a SQL 2017 "SQL account" password to 123456789password@ and everything worked correctly.

The only thing I can think is if your keyboard mapping was incorrect & the @ was being entered in the password field as some other character?

If you wish to test this, type your password into a visible editor (notepad / vscode etc) copy the password and paste it into the field (to ensure the correct characters are entered)

Please re-open if the issue persists.