Authentication

DBeaver Kerberos authentication errors: [user; USER] from con properties not available to garner authentication information from the user

by

In DBeaver’s SQL Server connection, one can use Windows authentication if the computer is joined to the domain and the integrated windows credentials can be used to authenticate to the SQL server. If the computer is not joined to the domain, then one of the alternatives is to use Kerberos authentication. Previously, one can code … Read more

How to enable Azure AD login for a Linux VM

by

Linux VM has been able to authenticate to Active Directory via SSSD (System Security Services Daemon), and there has been many articles talking about this. With the infrastructure going towards cloud, the on-premises domain controller is losing its shine and relevance. Microsoft’s alternative is to enable AD Domain Services, and there are articles readily available … Read more

KDC has no support for encryption type while connecting to SQL server on RHEL8

by

After upgrading to RHEL8 or Centos8, connecting to SQL server using trusted authentication may fail with the following error: rc4 encryption is still heavily used in AD environments but it is already disabled by default. Therefore, to re-enabled it again, simply call: After that, reboot the server and the SQL connection would work.

Azure Authentication using Python MSAL

by

Microsoft has released MSAL for Python. This has helped to shield away complexities in calling the API using urllib3 libraries and meddling with the parameters. In this article, I will provide sample code on how to get the access token using the following credentials type: UserID and Password Client ID and Client Secret User ID … Read more

Connect DBeaver to MS SQL Server without Kerberos Ticket Cache in Windows

by

There is a good article on connecting DBeaver to MS SQL Server with Kerberos Ticket Cache in Windows. I only chanced upon this article after I have fixed by issue without using a Kerberos Cache. You would have noticed that when you select Kerberos, the User name and password prompt is grayed out. Choose another … Read more