{"id":167,"date":"2021-10-04T10:10:11","date_gmt":"2021-10-04T02:10:11","guid":{"rendered":"https:\/\/idez.biz\/?p=167"},"modified":"2021-10-04T10:10:12","modified_gmt":"2021-10-04T02:10:12","slug":"connect-dbeaver-to-ms-sql-server-without-kerberos-ticket-cache-in-windows","status":"publish","type":"post","link":"https:\/\/idez.biz\/index.php\/connect-dbeaver-to-ms-sql-server-without-kerberos-ticket-cache-in-windows\/","title":{"rendered":"Connect DBeaver to MS SQL Server without Kerberos Ticket Cache in Windows"},"content":{"rendered":"\n

There is a good article on connecting DBeaver to MS SQL Server with Kerberos Ticket Cache in Windows<\/a>. I only chanced upon this article after I have fixed by issue without using a Kerberos Cache. <\/p>\n\n\n\n

You would have noticed that when you select Kerberos, the User name and password prompt is grayed out. Choose another authentication scheme to enter the Kerberos user name and password, in the form of xxx@yyy.local, assuming your Kerberos domain is yyy.local. Do also ensure that the sql server name is the fully qualified name that matches the SPN. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

After that, you may proceed to test the connection. And it should work. Do let me know if you find otherwise. <\/p>\n\n\n\n

I have chanced upon Kerberos authentication because Windows Authentication failed because of integrated authentication. I have also found a link <\/a>that sets the driver properties of “Integrated Authentication” to be true. This also works for me.<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

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<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[14,54,53,37],"tags":[47,55,57,56],"class_list":["post-167","post","type-post","status-publish","format-standard","hentry","category-authentication","category-dbeaver","category-kerberos","category-sql-server","tag-authentication","tag-dbeaver","tag-kerberos","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"jetpack-related-posts":[],"jetpack_shortlink":"https:\/\/wp.me\/pcj45d-2H","_links":{"self":[{"href":"https:\/\/idez.biz\/index.php\/wp-json\/wp\/v2\/posts\/167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/idez.biz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/idez.biz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/idez.biz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/idez.biz\/index.php\/wp-json\/wp\/v2\/comments?post=167"}],"version-history":[{"count":1,"href":"https:\/\/idez.biz\/index.php\/wp-json\/wp\/v2\/posts\/167\/revisions"}],"predecessor-version":[{"id":169,"href":"https:\/\/idez.biz\/index.php\/wp-json\/wp\/v2\/posts\/167\/revisions\/169"}],"wp:attachment":[{"href":"https:\/\/idez.biz\/index.php\/wp-json\/wp\/v2\/media?parent=167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/idez.biz\/index.php\/wp-json\/wp\/v2\/categories?post=167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/idez.biz\/index.php\/wp-json\/wp\/v2\/tags?post=167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}