sqlserver icon indicating copy to clipboard operation
sqlserver copied to clipboard

Cannot connect to SQL server using a # character in the password

Open dbkblk opened this issue 3 years ago • 1 comments

Hi,

I cannot find a way to connect using a password with a # in the password.

The sqlstring is something like: sqlserver://user:pass#word@theadress:23456?database=GENERIC"

This string would fail with an error of this type: Failed to initialize database, got error parse sqlserver://user:pass: invalid port :pass after host.

The parsing seems to stop after the # char.

How can I workaround this?

dbkblk avatar Nov 10 '22 15:11 dbkblk

sqlserver://user:pass%23word@theadress:23456?database=GENERIC You should encode url, after that will work well.

jhajjaarap avatar Nov 27 '23 05:11 jhajjaarap