I discovered the problem. There is a bug, it is just a different bug than I thought. it is also not limited to SQL Server. I created a MySQL instance and it had the same problem.
The SQL Connector Plugin doesn’t know how to handle special characters in the connection string…at least in the password. I had a password that has a few special characters in it and eventually, while trying twenty other things, I changing the password to something simple and POOF it worked.
So if anyone else was having problems trying to connect to a database via the connector, look to see if your password is “too good”.
Marc
Example of what will work and what will fail.
Azure SQL Example
This will fail
mssql://username:pass#word@myserver.database.windows.net:1433/MyDatabase?encrypt=true
This will not
mssql://username:password@myserver.database.windows.net:1433/MyDatabase?encrypt=true