12-18-2019 07:50 AM - edited 07-22-2021 12:34 PM
Issue
When connecting to an OleDB Datasource using the either the Input Tool or the In-DB Tools, users can encounter the below error message :
Error opening connect string: Microsoft SQL Server Native Client 11.0: Login failed for user 'user1'.\28000 = 18456
Environment
Diagnosis
Usually, when testing the Data Connection through the OleDB "Data Link Properties" window they are able to successfully test the connection :
However the error message will persist from the canvas.
Cause
When mentioning a username/password combination in a connection string, they need to be extracted in the program calling for it.
A parameter will need to be set and added to the string so windowsremembers the credentials and they can be extracted in program.
Solution
Additional Resources
As always, don't hesitate to contact us over atCustomer Supportif you run into any trouble.
This was soooo helpful. Thank you!
Hi,
I tried the step above to change the Persist Security Info to True, however received error as per below.
Did anyone face the same problem?
Hi @dianazamhari - yes, I got the same error.
Hi @dianazamhari @joshbennett @athaifa ,
Could you please reach out to the support team (support@alteryx.com) with the below details:
- version of Alteryx Designer
- DB + Driver version
- any error message ecountered
Thank you,
Hi @JohnGD,
I am also getting same error. I tried above options, still same :(
Output Data (5) Error SQLDriverConnect: SAML response is invalid or matching user is not found. Contact your local system administrator.
Please help me out!
Hi @Aditia,
Could you please reach out to the Alteryx Support team (support@alteryx.com) with the below details:
- version of Alteryx Designer
- DB type + Driver version
- any error message encountered
Thank you
Hi @JohnGD ,
I have already raised case 00539486.
Again raised this case 00539562 with below details:
- version of Alteryx Designer
- DB type + Driver version
- any error message encountered
Hi @Aditia, This Knowledge Base article is for Microsoft SQL database using OleDB method. In you case you are getting the error 'Output Data (5) Error SQLDriverConnect: SAML response is invalid or matching user is not found. Contact your local system administrator.' when writing data to Snowflake, so it is a different issue. I have taken ownership of case 00539562 and I will be assisting you. Thank you, Nora