To check your krb.conf works to authenticate with the credentials you want to use: on Windows you can use \bin\kinit.exe, on Linux kinit To have Integrated Auth working with authenticationScheme=JavaKerberos it looks like you MUST have a krb.conf file and point to it.
Metabase hosting environment: Metabase.jar on Windows 10 tested both in a CMD shell and a Ubuntu WSL shell (so essentially Linux) Metabase version: yesterdays master (but since this is driver/config related I think 0.26.2 and up) Your databases: Microsoft SQL Server 2008 Note: this is the case using Metabase.jar directly, not Docker yet I can confirm connection to SQL Server using Integrated Authentication works-for-me based on the description in the #6056 (comment) above. Please can this bug be investigated further? Thanks. Using this I can successfully connect to the server in RazorSQL, but when replicated in the Metabase connection settings, I can't connect :( Jdbc:sqlserver:// databaseName=Testdb integratedSecurity=false instanceName=IT trustServerCertificate=true authenticationScheme=NativeAuthentication authentication=SqlPassword selectMethod=cursor encrypt=false serverName=
In RazorSQL I'm using the '.SQLServerDriver' driver and the following connection string. I've been reading the MS connection string docs here: and have been able to successfully connect to the same database using RazorSQL on MacOS X. I'm using SQL Authentication, and still can't get the database to connect using v0.26+.
IntegratedSecurity=true authenticationScheme=JavaKerberosĮdit: We are on v0.26.2 on a CentOS 1708 box, using PostgreSQL as the as the internal database. The important part of the JDBC string to make Kerberos authentication work after Kerberos is setup and the metabase is launched to use Kerberos I also had to set it up using the UserPrincipalName, with the domain in upper case (Referenced in Microsofts above guide) usr/bin/java .config=/opt/metabase/nf =/etc/krb.conf -jar /opt/metabase/metabase.jar > /var/log/metabase.log
Setting up Java to use the inf and krb.conf, this is the line we use.Generate diagrams for database objects, build query and execution plans, generate flame graphs for EXPLAIN statements.We had to setup Kerberos on the server before we were able to connect with Domain Credentials.Īfter Kerberos was working from the first guide, the important parts from the second guide areĬom.Krb5LoginModule required useTicketCache=true If you could not find the answer, try to contact JetBrains and we can try to help you.
This troubleshooting article will guide you through the most common steps to identify and fix the issue.
Tutorial shows you how to start working with Microsoft SQL server and connect to its instance with Windows domain or SQL Server authentication.Ĭonnectivity issue is a very common definition and might include many problems. Step-by-step tutorial how to create, connect, and start working with your SQL Server Express LocalDB instance. Import and export your data to and from various formats with or without special tools like mysqldump, pg_dump, pg_restore, or psql. Start working with your data source by creating a connection to it.Ĭonnect an SQL file to a data source and run your code.