TransWikia.com

Connecting to Microsoft SQL Server from QGIS

Geographic Information Systems Asked by Simon GIS on April 1, 2021

I can’t connect my QGIS to SQL Server.

This is my database:

enter image description here

This is my connection configuration to QGIS

enter image description here

If I press test connection it says “Driver not loaded”. If i load database, there is nothing happening.

What is wrong here?

One Answer

I would check the name of the MSSQL server again. Normally it is something like: username/MSSQLSERVER unless you renamed it during installation. I would also either set the checkbox to trusted connection or enter the sa user if you have the rights. Before you can test the connection, you have to click on the database list. Make sure that you have checked the box at the bottom for "Also list tables with no geometry, because especially in the beginning you often don't have any geodata in the database. Select your database and you can test the connection.

enter image description here

Correct answer by Omegon on April 1, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP