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!
Best Answer
what did you get from
executed as root? If there is nothing to see, then your server is not joined to the active directory. Otherwise you see your host entries for the kerberos system.
Normally, RHEL 7 Systems are configured with sssd as the central authentication service. Please check if sssd is installed and running:
If not, you can try to join again with
Otherwise, configure your sssd to join your active directory domain with
You can get more Information about this here:
https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/windows_integration_guide/SSSD-AD
Regards, Björn