There have been questions related to this, but some of them seem out of date or no one has asked. I'm trying to connect to SQL Server 2008R2 using a MSSQL connection in QGIS. I'm not exactly sure if I'm connecting to the correct site. I'm able to connect through Autocad Civil 2014 so i'm using what I used to connect to that. Any ideas? The last posts I've seen are around 2011.

enter image description here

enter image description here

  • One does not connect to ArcSDE, one connects to a database through ArcSDE, which makes for a mismatch between title and question content. – Vince May 29 '14 at 21:30
  • My experience with QGIS and SDE is via PostgreSQL/PostGIS. QGIS ignored SDE altogether and connected directly to the database. – Michael Stimson May 29 '14 at 22:30

Have you put {server_name}{instance_name} in the [Host] field? In my SQL Server instance where I have mixed mode authentication, connecting as below works fine:

enter image description here

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.