Hi all,
I'm trying to connect to an offsite sql database and Alteryx is throwing the error: "Connection Error: Login failed for user 'username'".
I use the same credentials in Microsft SQL Server 2008 R2 and it doesn't give me any problems. The settings I use are:
Server type: Databse engine
Server name: the given offsite server name
Authentication: SQL Server Authentication
I then add the login and password.
In Alteryx I enter the same credentials in the input node after selecting Database Connection, New OleDB Connection, and then Microsoft OLE DB Provider for SQL Server.
Has anyone run into this problem and know what may be happening?
I appreicate any responses!
Solved! Go to Solution.
I also have the same issue. The same user/password is able to login through SSMS.
Test connection also comes out success, but when I double click on the input data box, I get this login failed error.