Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mtabernad
Partner - Creator
Partner - Creator

User error when connecting to SQL Server

Hi everyone,

Could anyone help me? I am trying to connect to SQL Server through its connector. I enter everything but when I click on "Create" attached error shows up (loggin error for the SQL Server user).

Is it due to SQL Server user or password?

Thank you very much in advance.

1 Reply
vunguyenq89
Creator III
Creator III

Hi,

In the error message I can see error code 18456 returned by SQL server, which usually indicates incorrect username/ password being used in the connection. See https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-18456-database-e...

If the database server requires SQL Server Authentication (username-password), make sure you can log in with this credentials on another SQL Server client (for example SQL Server Management Studio)

If Windows authentication is being used, make sure the service account running Qlik Sense Engine service has access to the database.

BR,

Vu Nguyen