Connect to MSSQL Server Issue

Hi There!

I´ve just installed metabase and was testing it with some databases.
But I was unable to connect to MS SQL Server. I did a lot of googling and follow some of the suggestions (explicity inform port, some driver options, check firewall, check java ssl settings...), but I still couldnt manage to connect.

I´m running metabase locally. From the same PC, I was able to connect to server via sql management studio.

My setup:
Windows 10 running metabase v0.34.1
SQL Server v.10.0.2531 SP1 with no SSL enabled

The error message that I get is:
"The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:052d1f6a-1a33-40a4-a49b-b75a2a0fd914"."

Here is the settings:

Anyone have a suggestion?

Thx in advance!

That’s an obsolete version of SQL Server (2008).
Could be a problem with TLS, but I don’t really know.
Try installing a test SQL 2016 Express server and see if that connection works.

1 Like

Thanks Andrew… you´re right.

I tried to connect to a newer server and it worked.
:+1: