Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 Solution

Accepted Solutions
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

 

View solution in original post

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