Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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