Bug report #10428: MSSQL - Login/Connection error - QGIS Application - QGIS Issue Tracking

Bug report #10428

MSSQL - Login/Connection error

Added by Jan Lippmann over 10 years ago. Updated over 10 years ago.

Status:	Closed
Priority:	Severe/Regression
Assignee:	Nathan Woodrow
Category:	Data Provider
Affected QGIS version:	master	Regression?:	No
Operating System:	Win 7	Easy fix?:	No
Pull Request or Patch supplied:	No	Resolution:
Crashes QGIS or corrupts data:	No	Copied to github as #:	18842

Description

hello,

if i load a layer from mssql 2008 express r2 database , qgis (master 32 bit date 2.6.2014) throw an error ...see below.
can anybody reproduce this error?how can i solve this problem?

there are no problems under qgis 2.2 32 bit with the same layer.

thanks jan

Login error. The login is from an untrusted domain and can not be used with Windows authentication. There can be no connection.

original german error:
QSqlDatabasePrivate::database: unable to open database: "[Microsoft][ODBC SQL Server Driver][SQL Server]Anmeldefehler. Die Anmeldung stammt aus einer nicht vertrauenswürdigen Domäne und kann mit der Windows- Authentifizierung nicht verwendet werden. QODBC3: Es kann keine Verbindung aufgebaut werden"

QGIS-Version 2.3.0-Master QGIS-Codeversion ca6d4d9
Kompiliert gegen Qt 4.7.1 Laufendes Qt 4.7.1
Kompiliert mit GDAL/OGR 1.11.0 Läuft mit GDAL/OGR 1.11.0
Kompiliert mit GEOS 3.4.2-CAPI-1.8.2 Läuft mit GEOS 3.4.2-CAPI-1.8.2 r3921
PostgreSQL-Client-Version 8.3.10 SpatiaLite-Version 4.1.1
QWT-Version 5.2.1 PROJ.4-Version 480
QScintilla2-Version 2.6.2 Diese QGIS-Kopie schreibt Debugausgaben.

qgis_mssql_connection.png (22.4 KB) Jan Lippmann, 2014-06-03 05:42 AM

qgis_debugView_log.log (16 KB) Jan Lippmann, 2014-06-04 12:35 AM

Associated revisions

Revision 6392fa92
Added by Jürgen Fischer over 10 years ago

mssql provider: cleanup driver and service usage and copy password in feature iterator (fixes #10428)

History

#1 Updated by Jan Lippmann over 10 years ago

File qgis_debugView_log.log added
Assignee set to Nathan Woodrow

here are some additional infos:

-the sql server is NOT the local machine!
-the connection test in the connection dialog window works
-if i add the layer , the layer appears in the TOC but there are no records in the attribute table and no features in the map
-i think the problem is there.. "c:\\src\\qgis\\src\\providers\\mssql\\qgsmssqlfeatureiterator.cpp(42) : (QgsMssqlFeatureIterator::QgsMssqlFeatureIterator) Failed to open database"...you can see it in the debugview-logfile

#2 Updated by Nathan Woodrow over 10 years ago

What if you use a user and password? If there is no password QGIS will try and use trusted connection.

#3 Updated by Giovanni Manghi over 10 years ago

Status changed from Open to Feedback

#4 Updated by Jan Lippmann over 10 years ago

-We and our customers absolutely need sql server authenication mode.
-By the way, there is no successful connection without password, qgis throws the same error.