This is odd - I've successfully connected to my spatial sql server 2014 instance, and loaded two point layers and one Polygon layer into QGIS. I see nothing on the map. I zoom to the layer, I know it goes to the right location and zoom level. I use the Info option, click the map, and it doesn't find anything. Very puzzling. The Style appears to be fine. I don't know what else to check. All looks good configuration wise - I just don't see anything.
I then selected each of the three layers one at a time, and used the Layer drop down menu, SaveAs... and saved the layer as a shape file at my local computer.
When I load the three Shape files that I've just created by saving the SQL Server layers as shape files using QGIS, these shape files display and act perfectly.
Has anyone else experienced this? I don't know why I cannot successfully work with SQL Server 2014 spatial layers.
For the record, all my layers use the EPSG:2234 CT State Plane CRS, in case that may be relevant. The geometries in the database do specify this CRS, and QGIS displays this as well, and it is set correctly in the saved shape files.