Unable to Connect to Microsoft SQL Database Error 42000

Hello Community,

I am a real newbie to Alteryx, I primarily work with Databricks. I'm experimenting with Alteryx, and so far I'm loving it.

At the moment, I am getting the following error when I use the Output tool to connect to Microsoft SQL Database

Can someone let me know how to go about fixing this error please?

Connectors

Database Connection

Accepted answers

davidskaife

Hi @carltonp

I've just been playing around with something similar for a client, and had managed to get the same error message. In my case it appears to be down to having preselected a default database that the server didn't like (we have multiple environments, dev, uat etc) and when i switched the connection from one to the other but kept the default database i got this message.

I fixed it by recreating the connection from scratch, could you try that and see if it works?

All comments

nityavid

Check that you can ping the SQL Server box Make sure you are able to ping the physical server where SQL Server is installed from the client machine. If not, you can try to connect to the SQL Server using an IP Address (for default instance) or IP Address\Instance Name for a named instance.

davidskaife

Hi @carltonp

I fixed it by recreating the connection from scratch, could you try that and see if it works?

Tienie

This solution really work. Leave default database blank and happiness!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235