Connection to SQLServer

[KGouni]

Hi,

I am connecting to SQL Server using in-DB Connection, I used ODBC Admin and it says: the file "servername|||" is not in a known format.

I have tested this connection in ODBC Data Source Administrator and it says successful.

Any sample connections or inputs would be great.

Thanks!!

[mceleavey · Accepted solution]

Hi @KGouni ,

Set up your ODBC connection so it includes the following information:

Ensure the server is provided.

In Alteryx, ensure you can connect to the data source using a standard input tool:

If this is working, then try it with the Connect IN-DB tool. 

As long as the server is provided in the ODBC setup, you should be good to go.

If you've already done all of this, let me know and I'll have a look at other possibilities.

M.

[KGouni]

Thank you so much. This worked!

[mceleavey]

Glad I could help.