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.
#solved
i did update to the sql server 2012 sp2 and i was finally able to my database
thanks