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
  • I think this same issue applies to Linux (Ubuntu, Mint for sure)... – DPSSpatial Apr 4 at 17:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.