MSSQL Connection fails after Update

[alliedarmour]

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

[mpc · Accepted solution]

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

[alliedarmour]

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

[mpc]

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

[Rahul_123]

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 .