User error when connecting to SQL Server

[mtabernad]

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.

[vunguyenq89 · Accepted solution]

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