MS SQL - Couldn't connect

Get Help
1

Trying to connect to our Microsoft SQL 2014 SP3 from the Metabase client on a Mac.

The server is remotely hosted, but I have access to it from other applications, like TablePlus.

I'm using all the same credentials across applications, but metabase refuses to connect.

31
311468×1542 289 KB

Log:
[9217809d-f681-43d0-b105-36220d3a857d] 2020-10-06T10:33:59+02:00 ERROR metabase.driver.util Database connection error [9217809d-f681-43d0-b105-36220d3a857d] 2020-10-06T10:33:59+02:00 ERROR metabase.api.database Cannot connect to Database

Any ideas where I'm going wrong?

2

Hi @Gnillab
Metabase uses the JDBC driver to connect, so that host isn’t valid - it needs to be an IP address, hostname, or FQDN.

1 Like
3

Thanks for the swift reply!

So in the case where my host is IP\[Something] I’m SOOL? :frowning:

4

So I moved the value after the backslash down to Instance and cleared the port value and then it worked.

Thanks again for the feedback.