Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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:



    Persist Security Info=True;

        User ID=QS01;

        Initial Catalog=NovotekReportPlusConfiguration;

        Data Source=\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!

1 Reply
Creator II
Creator II

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