Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Connection to SQL database

Ecaterina
7 - Meteor

I am  trying to connect to a SQL server. O got a error message that I can not connect to the database with my user, but it is work if I try to connect from SSMS.

 

The alteryx create own IP address when it is trying to connect to the database?

3 REPLIES 3
echuong1
Alteryx Alumni (Retired)

It sounds like there's an issue with authentication - have you tried using SQL Authentication instead of windows? See information about connecting below.

 

echuong1_0-1584556090692.png

 

https://help.alteryx.com/current/SQLServerConnections.htm

Ecaterina
7 - Meteor

yes, I tried . But I still get the error with the connection. 
How could I see the request which are do the alteryx to the SQL instance. It is important to see the IP address

RolandSchubert
16 - Nebula
16 - Nebula

Hi @Ecaterina ,

 

you should be able to see the IP address and the error message using SQL Server Management Studio. (Administration -> SQL Server Logs). If the error is really caused by access rights, there should be a log file entry.

 

Best,

 

Roland

Labels
Top Solution Authors