Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
alliedarmour
Contributor III
Contributor III

MSSQL Connection fails after Update

Hello,

we have a data connection to a MSSQL Database which was working fine before the last update:

mssql1.PNG

After I ran the latest patch for Qlik Sense Enterprise (May 2025 Patch 7) the connection doesn't work anymore and the connection cannot be established:

Data Connection after updateData Connection after update

If I try to connect to the database specified in DBeaver (which is running on our QS Server aswell), it connects successfully (exact same credentials, crosschecked multiple times):

DBeaver ConnectionDBeaver Connection

Any ideas how to resolve this? The logfile is not really helpful:


System.Data.Odbc.OdbcException (0x80131937): ERROR [28000] [Qlik][SqlServer] (18456) Fehler bei der Anmeldung für den Benutzer ""BNS\rkaqliksense"".
ERROR [28000] [Qlik][SqlServer] (18456) Fehler bei der Anmeldung für den Benutzer ""BNS\rkaqliksense"".
bei System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
bei System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
bei System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
bei System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
bei System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
bei System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
bei System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
bei System.Data.Odbc.OdbcConnection.Open()
bei Qlik.Connectors.Odbc.OdbcConnectorSourceConnection.ConnectInternal(Boolean testConnectOnly, EngineCallContext callContext)"

Labels (2)
0 Replies