jaefm.blogg.se - Install microsoft jdbc driver 6.0 for sql server

INSTALL MICROSOFT JDBC DRIVER 6.0 FOR SQL SERVER HOW TO
INSTALL MICROSOFT JDBC DRIVER 6.0 FOR SQL SERVER INSTALL
INSTALL MICROSOFT JDBC DRIVER 6.0 FOR SQL SERVER PASSWORD
INSTALL MICROSOFT JDBC DRIVER 6.0 FOR SQL SERVER DOWNLOAD
INSTALL MICROSOFT JDBC DRIVER 6.0 FOR SQL SERVER WINDOWS

Then test windows authentication in Squirrel in Linux.

Go into squirrel-sql-3.9.1 folder, modify squirrel-sql.bat squirrel-sql-3.9.1]$ vi squirrel-sql.bat.

Put below information into nf fileĬom.Krb5LoginModule required useTicketCache=true Create nf file inside squirrel-sql-3.9.1 folder. ‘krb5cc_bobcai’ is Kerberos ticket cache ~]$ sudo vi /etc/profileĮxport KRB5CCNAME=/home/bobcai/krb5cc_bobcaiġ9. You will find ‘sqljdbc_6.0’ folder was created under the same ~]$ tar -zxf sqljdbc_.200_

Unzip sqljdbc_.200_ which has been downloaded from above link.

I am using Microsoft JDBC 6.0 to do this test.

INSTALL MICROSOFT JDBC DRIVER 6.0 FOR SQL SERVER DOWNLOAD

When Squirrel is installed, Please download Microsoft JDBC.

INSTALL MICROSOFT JDBC DRIVER 6.0 FOR SQL SERVER INSTALL

Install it using below ~]$ java -jar squirrel-sql-3.9.1-standard.jar Download squirrel-sql-3.9.1-standard.jar from above official web site. We use this tool to verify JDBC connectivity/authentication issue. Ticket cache: KEYRING:persistent:1000:1000ĭefault principal: starting Expires Service principal

INSTALL MICROSOFT JDBC DRIVER 6.0 FOR SQL SERVER PASSWORD

Password for Use Klist to verify bobcai’s Kerberos Packages]$ klist So we need to run “kinit bobcai” to get bobcai’s TGT Packages]$ kinit bobcai I will use “bobcai” ticket to login SQL Server. Pkinit_anchors = /etc/pki/tls/certs/ca-bundle.crtĭefault_ccache_name = KEYRING:persistent:% # Configuration snippets may be placed in this directory as well The following yellow highlight parts should be changed to your own domain name.

When you have successfully joined windows domain, please modify /etc/nf file.

This account should have permission to add computer into domain and also have permission to login SQL SERVER. Please replace yellow highlighted domain name and domain account.

Join Linux server into windows domain.

Specify hostname in case the server hasn’t.

Modify /etc/hosts file, add domain controller records.

Add below information into /etc/nf file.

Sudo vi /etc/sysconfig/network-scripts/ifcfg-ens33

INSTALL MICROSOFT JDBC DRIVER 6.0 FOR SQL SERVER HOW TO

How to configure windows authentication for Microsoft JDBC in Linux.