[Solved] Sql Server Express Connection Metabase.jar

Hi there,

I´m trying to connect metabase locally to my Sql Server Express Database (using the jar file), but i´m having no success.

I´m using Sql Server 2012

Connection to my Ms Sql Server Management Studio works fine.
I was also able to connect to DBeaver usign this setup

When trying to connect to metabase, all i get is "An error occurred" message

I´m a small business owner and not particularly technical so i might be missing something obvious or omitting something obvious to anyone

Hi @diegoltt
Post "Diagnostic Info" from Admin > Troubleshooting.
And check the logs for more detailed errors - Admin > Troubleshooting > Logs.

@flamber Thanks a lot, I did not know about the logs.
I got a giant file to analyze.
The most prevalent error i see is: Caused by: javax.net.ssl.SSLHandshakeException: The server selected protocol version TLS10 is not accepted by client preferences [TLS12]

@diegoltt That's the only interesting part. You either need to upgrade your MSSQL or try the workarounds listed here: https://github.com/metabase/metabase/issues/16718

thanks a lot, @flamber.
I tryed adding the string encrypt=false to the connection, but it did not work. I´ll have to consult with my system provider about upgrading the Sql Server, but the were alredy reticent about giving me access do the database, so i will try to see if there would be a different way to do that.

i did update to the sql server 2012 sp2 and i was finally able to my database