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!
