2

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?

2
1

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

1
  • Thanks Omegon ,yes my host was wrong. – Simon GIS Mar 12 at 1:20

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.