So I'm trying to connect to one of our SQL server from a RHEL Server 7.4 machine, I already installed kerberos, unixodbc and Microsoft ODBC for Linux.
The SQL Server I'm trying to connect to is inside Active Directory domain, I was able to authenticate through that using kinit
but still getting SSPI Provider: Server not found in Kerberos database.
error.
This is my snippet from terminal:
[RH@localhost /]$ sudo kinit rh@ADS.LOCAL.COM
[sudo] password for RH:
Password for rh@ADS.LOCAL.COM:
[RH@localhost /]$ sqlcmd -E -S MyServer
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : SSPI Provider: Server not found in Kerberos database.
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Cannot generate SSPI context.
This is my /etc/krb5.conf
:
[libdefaults]
dns_lookup_realm = false
ticket_lifetime = 24h
forwardable = yes
default_realm = ADS.LOCAL.COM
default_ccache_name = KEYRING:persistent:%{uid}
dns_lookup_kdc = true
[domain_realm]
.ads.local.com = ADS.LOCAL.COM
Thanks in advance!