Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
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:

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!

1 Reply
reporting_neu
Creator III
Creator III

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