Question: "Connector connect error: Login failed for user"

Mon, 08 May 2017 12:15:48 GMT

Greetings Qlik Community.

I am attempting to connect Qlik Sense to an SQL Express database on a remote server. Sadly, whenever I try to do this I always get the following error message:

Connector connect error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Login failed for user 'QS01'.

The connection string I'm using looks like this:

OLEDB CONNECT TO [

Provider=SQLOLEDB.1;

Persist Security Info=True;

User ID=QS01;

Initial Catalog=NovotekReportPlusConfiguration;

Data Source=192.168.1.30\SQLEXPRESS, 49166;

Use Procedure for Prepare=1;

Auto Translate=True;

Packet Size=4096;

Workstation ID=QS01;

Use Encryption for Data=False;

Tag with column collation when possible=False] (XPassword is auto11It);

So, the error message implies that the user cannot access the database. However, 'QS01' is a user I've added to the SQL Express database, and 'auto11It' is the password this account uses when accessing the database through with SQL Server Authentication through SQL Server Management Studio on the remote server.

As a result I'm not certain what is causing this issue. Does anyone have ideas on how to resolve this problem?

Thanks a lot!

Re: Question: "Connector connect error: Login failed for user"

reporting_neu — Thu, 16 Mar 2023 08:41:03 GMT

I have the same problem. Is there already a solution for this?

topic Re: Question: "Connector connect error: Login failed for user" in Connectivity & Data Prep

Question: "Connector connect error: Login failed for user"

Re: Question: "Connector connect error: Login failed for user"