Getting “No suitable driver found for jdbc:sqlserver://DB server” error while saving db details. Can anyone pls help ?
Hi @vs1188
Which version of Metabase?
Are you using a custom driver or the one included in Metabase, which has been extracted to the plugins directory?
Metabase v0.33.
I am using the driver included in Metabase. Please help.
Which version of Java are you using? java -version
What’s the checksum of the driver? sha256sum plugins/sqlserver.metabase-driver.jar
The checksum should be: e8eed4ab46d637340a85c2611998a6caeccb4717d8101e08915b7c6243db7428
Can you post the entire log from when you start Metabase until the following line? It should be about 50 lines.
INFO metabase.core :: Metabase Initialization COMPLETE
Hi flamber,
Java version - 1.8.0_131.
checksum - d6c57604d0b0a29ad678345ad31ed732a4c4097d4642c3fe29e322bb061a75de
It’s actually way more than 50 lines. Here is the complete log:
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
09-04 20:55:44 ?[1mERROR util.files?[0m :: Failed to copy file
java.nio.file.AccessDeniedException: D:\CMetabaseLatest\plugins\googleanalytics.
metabase-driver.jar
at sun.nio.fs.WindowsException.translateToIOException(Unknown Source)
at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
at sun.nio.fs.WindowsFileSystemProvider.implDelete(Unknown Source)
at sun.nio.fs.AbstractFileSystemProvider.deleteIfExists(Unknown Source)
at java.nio.file.Files.deleteIfExists(Unknown Source)
at java.nio.file.CopyMoveHelper.copyToForeignTarget(Unknown Source)
at java.nio.file.Files.copy(Unknown Source)
at metabase.util.files$copy_file_BANG_.invokeStatic(files.clj:80)
at metabase.util.files$copy_file_BANG_.invoke(files.clj:76)
at metabase.util.files$copy_files_BANG_$fn__45476.invoke(files.clj:89)
at metabase.util.files$copy_files_BANG_.invokeStatic(files.clj:88)
at metabase.util.files$copy_files_BANG_.invoke(files.clj:82)
at metabase.plugins$extract_system_modules_BANG_$fn__66034.invoke(plugin
s.clj:58)
at metabase.util.files$do_with_open_path_to_resource.invokeStatic(files.
clj:111)
at metabase.util.files$do_with_open_path_to_resource.invoke(files.clj:10
3)
at metabase.plugins$extract_system_modules_BANG_.invokeStatic(plugins.cl
j:57)
at metabase.plugins$extract_system_modules_BANG_.invoke(plugins.clj:54)
at metabase.plugins$load_plugins_BANG_.invokeStatic(plugins.clj:136)
at metabase.plugins$load_plugins_BANG_.invoke(plugins.clj:122)
at metabase.core$init_BANG_.invokeStatic(core.clj:67)
at metabase.core$init_BANG_.invoke(core.clj:55)
at metabase.core$start_normally.invokeStatic(core.clj:122)
at metabase.core$start_normally.invoke(core.clj:116)
at metabase.core$main.invokeStatic(core.clj:142)
at metabase.core$main.doInvoke(core.clj:137)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
09-04 20:55:44 ?[1mERROR util.files?[0m :: Failed to copy file
java.nio.file.AccessDeniedException: D:\CMetabaseLatest\plugins\google.metabase-
driver.jar
at sun.nio.fs.WindowsException.translateToIOException(Unknown Source)
at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
at sun.nio.fs.WindowsFileSystemProvider.implDelete(Unknown Source)
at sun.nio.fs.AbstractFileSystemProvider.deleteIfExists(Unknown Source)
at java.nio.file.Files.deleteIfExists(Unknown Source)
at java.nio.file.CopyMoveHelper.copyToForeignTarget(Unknown Source)
at java.nio.file.Files.copy(Unknown Source)
at metabase.util.files$copy_file_BANG.invokeStatic(files.clj:80)
at metabase.util.files$copy_file_BANG.invoke(files.clj:76)
at metabase.util.files$copy_files_BANG_$fn__45476.invoke(files.clj:89)
at metabase.util.files$copy_files_BANG_.invokeStatic(files.clj:88)
at metabase.util.files$copy_files_BANG_.invoke(files.clj:82)
at metabase.plugins$extract_system_modules_BANG_$fn__66034.invoke(plugin
s.clj:58)
at metabase.util.files$do_with_open_path_to_resource.invokeStatic(files.
clj:111)
at metabase.util.files$do_with_open_path_to_resource.invoke(files.clj:10
3)
at metabase.plugins$extract_system_modules_BANG_.invokeStatic(plugins.cl
j:57)
at metabase.plugins$extract_system_modules_BANG_.invoke(plugins.clj:54)
at metabase.plugins$load_plugins_BANG_.invokeStatic(plugins.clj:136)
at metabase.plugins$load_plugins_BANG_.invoke(plugins.clj:122)
at metabase.core$init_BANG_.invokeStatic(core.clj:67)
at metabase.core$init_BANG_.invoke(core.clj:55)
at metabase.core$start_normally.invokeStatic(core.clj:122)
at metabase.core$start_normally.invoke(core.clj:116)
at metabase.core$main.invokeStatic(core.clj:142)
at metabase.core$main.doInvoke(core.clj:137)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
09-04 20:55:44 ?[1mERROR util.files?[0m :: Failed to copy file
java.nio.file.AccessDeniedException: D:\CMetabaseLatest\plugins\druid.metabase-d
river.jar
at sun.nio.fs.WindowsException.translateToIOException(Unknown Source)
at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
at sun.nio.fs.WindowsFileSystemProvider.implDelete(Unknown Source)
at sun.nio.fs.AbstractFileSystemProvider.deleteIfExists(Unknown Source)
at java.nio.file.Files.deleteIfExists(Unknown Source)
at java.nio.file.CopyMoveHelper.copyToForeignTarget(Unknown Source)
at java.nio.file.Files.copy(Unknown Source)
at metabase.util.files$copy_file_BANG.invokeStatic(files.clj:80)
at metabase.util.files$copy_file_BANG.invoke(files.clj:76)
at metabase.util.files$copy_files_BANG_$fn__45476.invoke(files.clj:89)
at metabase.util.files$copy_files_BANG_.invokeStatic(files.clj:88)
at metabase.util.files$copy_files_BANG_.invoke(files.clj:82)
at metabase.plugins$extract_system_modules_BANG_$fn__66034.invoke(plugin
s.clj:58)
at metabase.util.files$do_with_open_path_to_resource.invokeStatic(files.
clj:111)
at metabase.util.files$do_with_open_path_to_resource.invoke(files.clj:10
3)
at metabase.plugins$extract_system_modules_BANG_.invokeStatic(plugins.cl
j:57)
at metabase.plugins$extract_system_modules_BANG_.invoke(plugins.clj:54)
at metabase.plugins$load_plugins_BANG_.invokeStatic(plugins.clj:136)
at metabase.plugins$load_plugins_BANG_.invoke(plugins.clj:122)
at metabase.core$init_BANG_.invokeStatic(core.clj:67)
at metabase.core$init_BANG_.invoke(core.clj:55)
at metabase.core$start_normally.invokeStatic(core.clj:122)
at metabase.core$start_normally.invoke(core.clj:116)
at metabase.core$main.invokeStatic(core.clj:142)
at metabase.core$main.doInvoke(core.clj:137)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
09-04 20:55:44 ?[1mERROR util.files?[0m :: Failed to copy file
java.nio.file.AccessDeniedException: D:\CMetabaseLatest\plugins\bigquery.metabas
e-driver.jar
at sun.nio.fs.WindowsException.translateToIOException(Unknown Source)
at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source)
at sun.nio.fs.WindowsFileSystemProvider.implDelete(Unknown Source)
at sun.nio.fs.AbstractFileSystemProvider.deleteIfExists(Unknown Source)
at java.nio.file.Files.deleteIfExists(Unknown Source)
at java.nio.file.CopyMoveHelper.copyToForeignTarget(Unknown Source)
at java.nio.file.Files.copy(Unknown Source)
at metabase.util.files$copy_file_BANG.invokeStatic(files.clj:80)
at metabase.util.files$copy_file_BANG.invoke(files.clj:76)
at metabase.util.files$copy_files_BANG_$fn__45476.invoke(files.clj:89)
at metabase.util.files$copy_files_BANG_.invokeStatic(files.clj:88)
at metabase.util.files$copy_files_BANG_.invoke(files.clj:82)
at metabase.plugins$extract_system_modules_BANG_$fn__66034.invoke(plugin
s.clj:58)
at metabase.util.files$do_with_open_path_to_resource.invokeStatic(files.
clj:111)
at metabase.util.files$do_with_open_path_to_resource.invoke(files.clj:10
3)
at metabase.plugins$extract_system_modules_BANG_.invokeStatic(plugins.cl
j:57)
at metabase.plugins$extract_system_modules_BANG_.invoke(plugins.clj:54)
at metabase.plugins$load_plugins_BANG_.invokeStatic(plugins.clj:136)
at metabase.plugins$load_plugins_BANG_.invoke(plugins.clj:122)
at metabase.core$init_BANG_.invokeStatic(core.clj:67)
at metabase.core$init_BANG_.invoke(core.clj:55)
at metabase.core$start_normally.invokeStatic(core.clj:122)
at metabase.core$start_normally.invoke(core.clj:116)
at metabase.core$_main.invokeStatic(core.clj:142)
at metabase.core$_main.doInvoke(core.clj:137)
at clojure.lang.RestFn.invoke(RestFn.java:397)
at clojure.lang.AFn.applyToHelper(AFn.java:152)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at metabase.core.main(Unknown Source)
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Plugin ‘Metabase BigQuery Dr
iver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Metabase BigQuery Driver dep
endency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Plugins with unsatisfied dep
s: [“Metabase BigQuery Driver”]
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :druid…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :druid
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :google…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered abstract driver :googl
e
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Metabase BigQuery Driver dep
endency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
09-04 20:55:44 ?[1mDEBUG plugins.initialize?[0m :: Dependencies satisfied; these
plugins will now be loaded: [“Metabase BigQuery Driver”]
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :bigquery…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :bigquery (pare
nts: [:sql :google])
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Plugin ‘Metabase Google Anal
ytics Driver’ depends on plugin ‘Metabase Google Drivers Shared Dependencies’
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Metabase Google Analytics Dr
iver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied?
true
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :googleanalytics…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :googleanalytic
s (parents: [:google])
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :mongo…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :mongo
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Metabase cannot initialize p
lugin Metabase Oracle Driver due to required dependencies. Metabase requires the
Oracle JDBC driver in order to connect to Oracle databases, but we can’t ship i
t as part of Metabase due to licensing restrictions. See https://metabase.com/do
cs/latest/administration-guide/databases/oracle.html for more details.
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Metabase Oracle Driver depen
dency {:class oracle.jdbc.OracleDriver} satisfied? false
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Plugins with unsatisfied dep
s: [“Metabase Oracle Driver”]
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :presto…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :presto (parent
s: [:sql])
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :redshift…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered abstract driver :sql-j
dbc (parents: [:sql])
Load driver :sql-jdbc took 8.4 ms
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :postgres (pare
nts: [:sql-jdbc])
Load driver :postgres took 85.0 ms
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :redshift (pare
nts: [:postgres])
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :snowflake…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :snowflake (par
ents: [:sql-jdbc])
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :hive-like…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered abstract driver :hive-
like (parents: [:sql-jdbc])
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :sparksql…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :sparksql (pare
nts: [:hive-like])
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :sqlite…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :sqlite (parent
s: [:sql-jdbc])
09-04 20:55:44 ?[1mINFO plugins.lazy-loaded-driver?[0m :: Registering lazy loadi
ng driver :sqlserver…
09-04 20:55:44 ?[1mINFO metabase.driver?[0m :: Registered driver :sqlserver (par
ents: [:sql-jdbc])
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Metabase cannot initialize p
lugin Metabase Vertica Driver due to required dependencies. Metabase requires th
e Vertica JDBC driver in order to connect to Vertica databases, but we can’t shi
p it as part of Metabase due to licensing restrictions. See https://metabase.com
/docs/latest/administration-guide/databases/vertica.html for more details.
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Metabase Vertica Driver depe
ndency {:class com.vertica.jdbc.Driver} satisfied? false
09-04 20:55:44 ?[1mINFO plugins.dependencies?[0m :: Plugins with unsatisfied dep
s: [“Metabase Oracle Driver” “Metabase Vertica Driver”]
09-04 20:55:45 ?[1mINFO metabase.driver?[0m :: Registered driver :h2 (parents: [
:sql-jdbc])
Load driver :h2 took 20.0 ms
09-04 20:55:45 ?[1mINFO metabase.driver?[0m :: Registered driver :mysql (parents
: [:sql-jdbc])
Load driver :mysql took 24.7 ms
09-04 20:55:45 ?[1mINFO metabase.core?[0m :: Setting up and migrating Metabase D
B. Please sit tight, this may take a minute…
09-04 20:55:45 ?[1mWARN metabase.db?[0m :: WARNING: Using Metabase with an H2 ap
plication database is not recommended for production deployments. For production
deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If
you decide to continue to use H2, please be sure to back up the database file re
gularly. For more information, seehttps://metabase.com/docs/latest/operations-gu
ide/migrating-from-h2.html
09-04 20:55:45 ?[1mINFO metabase.db?[0m :: Verifying h2 Database Connection …
09-04 20:55:45 ?[1mINFO metabase.driver?[0m :: Initializing driver :sql…
09-04 20:55:45 ?[1mINFO metabase.driver?[0m :: Initializing driver :sql-jdbc…
09-04 20:55:45 ?[1mINFO metabase.driver?[0m :: Initializing driver :h2…
09-04 20:55:45 ?[1mINFO metabase.db?[0m :: Verify Database Connection …
09-04 20:55:45 ?[1mINFO metabase.db?[0m :: Running Database Migrations…
09-04 20:55:45 ?[1mINFO metabase.db?[0m :: Setting up Liquibase…
09-04 20:55:45 ?[1mINFO metabase.db?[0m :: Liquibase is ready.
09-04 20:55:45 ?[1mINFO metabase.db?[0m :: Checking if Database has unrun migrat
ions…
09-04 20:55:46 ?[1mINFO metabase.db?[0m :: Database Migrations Current …
09-04 20:55:47 ?[1mINFO db.migrations?[0m :: Running all necessary data migratio
ns, this may take a minute.
09-04 20:55:47 ?[1mINFO db.migrations?[0m :: Finished running data migrations.
Application database setup took 1.9 s
09-04 20:55:47 ?[1mINFO metabase.events?[0m :: Starting events listener: metabas
e.events.activity-feed
09-04 20:55:47 ?[1mINFO metabase.events?[0m :: Starting events listener: metabas
e.events.dependencies
09-04 20:55:47 ?[1mINFO metabase.events?[0m :: Starting events listener: metabas
e.events.driver-notifications
09-04 20:55:47 ?[1mINFO metabase.events?[0m :: Starting events listener: metabas
e.events.last-login
09-04 20:55:47 ?[1mINFO metabase.events?[0m :: Starting events listener: metabas
e.events.metabot-lifecycle
09-04 20:55:47 ?[1mINFO metabase.events?[0m :: Starting events listener: metabas
e.events.notifications
09-04 20:55:47 ?[1mINFO metabase.events?[0m :: Starting events listener: metabas
e.events.revision
09-04 20:55:47 ?[1mINFO metabase.events?[0m :: Starting events listener: metabas
e.events.sync-database
09-04 20:55:47 ?[1mINFO metabase.events?[0m :: Starting events listener: metabas
e.events.view-log
09-04 20:55:47 ?[1mINFO metabase.task?[0m :: Initializing task SyncDatabases
09-04 20:55:47 ?[1mINFO metabase.task?[0m :: Initializing task CheckForNewVersio
ns
09-04 20:55:47 ?[1mINFO metabase.task?[0m :: Initializing task SendAnonymousUsag
eStats
09-04 20:55:47 ?[1mINFO metabase.task?[0m :: Initializing task SendAbandomentEma
ils
09-04 20:55:47 ?[1mINFO metabase.task?[0m :: Initializing task SendPulses
09-04 20:55:47 ?[1mINFO metabase.task?[0m :: Initializing task SendFollowUpEmail
s
09-04 20:55:47 ?[1mINFO metabase.task?[0m :: Initializing task TaskHistoryCleanu
p
09-04 20:55:47 ?[1mINFO metabase.core?[0m :: Metabase Initialization COMPLETE
@vs1188
Okay, update Java - latest release of version 8 is 221
That’s the checksum of the Metabase. I was asking for the checksum of the driver.
But looking at the log, it’s clear why it doesn’t work - you don’t have access rights to plugins.
Make sure everything in D:\CMetabaseLatest can be write-accessed by the user who’s starting Metabase.
I am not able to get the checksum of the driver as access is denied to the plugins folder. Will try it once I get access and get back to you in case I have any queries.
Thanks for your HELP !!!