I am running SQL Server 2014 Management Studio and 2.18.16 version of QGIS. When I attempt Layer -> Add Layer -> SQL Server layer and click new:

  • Connection name: Local
  • Provider/DSN blank
  • Host: Localhost

Clicking "List Databases" shows a - "Server does not exist or access denied" error that disappears really fast. Other processes I am using can connect to the database fine (although this had an option for Windows Authentication). I have also tried enabling TCP/IP and named pipes in the management studio options

  • Management Studio is a client, just like QGIS. You want to connect to the Server, not the Studio.
    – Vince
    Sep 11 '18 at 13:05

Changing the settings in the services did fix it, I just neglected to restart the service!

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.