I was looking for interactive query options for SQL Server (similar to SQL Server Management Studio). The "DB Manager" works great for Postgres and I'm primarily using the Load as new layer as I build out spatial queries. I would love to be able to do the same thing with SQL Server. Currently, I'll make a view and access that view via the Add MSSQL Spatial Layer..., that's a lot of flipping back and forth.
But I'm fairly inexperienced with QGIS, so I'd like to confirm that I am seeing what I should be seeing and that I'm not missing a configuration item?
If what I am seeing is correct, are there any GIS plug-ins out there that approximate this functionality? My searches have been unsuccessful so far (searching for SQL and Server returns a lot of irrelevant results!) and the Plugin search brings back a lot of results for Postgres:
QGIS version: 2.12.1-Lyon QGIS code revision: 16760fd
Best Answer
It's not supported (yet). Db manager only supports Postgres, Spatialite and Oracle databases.