MSSQL Connection fails after Update

alliedarmour — Mon, 13 Oct 2025 14:05:45 GMT

Hello,

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

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 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 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)"

Re: MSSQL Connection fails after Update

mpc — Tue, 21 Oct 2025 09:21:35 GMT

Hi,

Regarding the Release Note, the issue is resolved in Patch 9 : Sense Enterprise on Windows release notes - May 20... - Qlik Community - 2516914

Then you need to upgrade and test.

Best

Re: MSSQL Connection fails after Update

alliedarmour — Tue, 21 Oct 2025 09:32:31 GMT

The latest patch releases is Patch 8, I don't see Patch 9?

Re: MSSQL Connection fails after Update

mpc — Tue, 21 Oct 2025 09:33:55 GMT

You're right, my bad, it'll be available soon.

Re: MSSQL Connection fails after Update

Rahul_123 — Wed, 22 Oct 2025 13:55:08 GMT

Check with your DBA of mssql , the password is syn properly for the user you are using or not assure all the information are correctly filled .

topic Re: MSSQL Connection fails after Update in Connectivity & Data Prep

MSSQL Connection fails after Update

Re: MSSQL Connection fails after Update

Re: MSSQL Connection fails after Update

Re: MSSQL Connection fails after Update

Re: MSSQL Connection fails after Update