I have a table called [stg].[Stops] in SQL Server that I would like to load in QGIS for data analysis. This is the first time I use the MSSQL Server connection option in QGIS. Unfortunately, even though QGIS recognizes the table and its geography data type. When I attempt to connect, I get an invalid layer error.
Here is a screenshot of the menu:
and here is the error:
2017-01-25T11:07:37 1 dbname='TK463' host=******* srid=4326 type=Point table="stg"."Stops" (GEOM) sql= is an invalid layer - not loaded
What could possible cause that?