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