0

I tried to connect to MSSQL from QGIS and I couldn't find any solution to my problem.

I install MSSQL on my Mac with Docker and try to connect QGIS with localhost(host=localhost) and left the DSN empty, also inserted USER&PASS.

I tried to insert the IP instead, even mentioning the port (1433), nothing helped.

Did anyone have an idea how to solve this issue?

...

  • use the MAC MSSQL driver for OS X 10.11 (El Capitan), macOS 10.12 (Sierra), and macOS 10.13 (High Sierra) > docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/… (install via curl) > github.com/Microsoft/homebrew-mssql-release – Mapperz Feb 8 at 2:22
  • @Mapperz,thanks for your time.... I tried to do it and it didn't work. I also tried to uninstall MSSQL and install again and then install the ODBC using brew but it didn't help as well. I don't know if it is important but when I installed the 'msodbcsql17' & 'mssql-tools' the "-no--sandbox" option didn't worked so I installed it with out this option. do you have any more ideas? – Amirp96 Feb 8 at 14:25
  • cross-ref stack exchange > stackoverflow.com/questions/44120781/… – Mapperz Feb 8 at 15:02
  • @Mapperz, already tried it, still getting the same error while try to connect the server to QGIS. I checked the server and it's working and I can query the tables. – Amirp96 Feb 8 at 16:08

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.