Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

Connection to SQL database

Ecaterina
メテオール

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件の返信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
メテオール

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

ラベル