I'm feeling like this should work, but I'm banging my head against the keyboard, the documentaion and the google as I can't find any examples to follow for MSSQL.
I have 3rd party data only in an ESRI Personal DB (.MDB). I converted that to MSSQL because I believe there's no way to open that in QGIS.
The ACCESS to SQL conversion ran fine and I can see the tables and data in the SQL Server DB. I setup a User DSN to the DB and when I add a new MSSQL Layer connection, the Test Connection works.
However when I attempt to Connect to the DB in the Add MSSQL Table Dialog I get the following error:
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name 'geometry_columns'. QODBC3: Unable to execute statement
Maybe there a schema migration I need to run?