I can't connect my QGIS to SQL Server.
This is my database:
This is my connection configuration to QGIS
If I press test connection it says "Driver not loaded". If i load database, there is nothing happening.
What is wrong here?
QGIS – Connecting to Microsoft SQL Server: A Comprehensive Guide
qgissql server
Best 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.