Unable to Connect to Microsoft SQL Database Error 42000

[carltonp]

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?

[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 · Accepted solution]

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?

[Tienie]

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