• DBA

    SPN registration to SQL server to make a Kerberos authentication

    Overview of the issue. It is UAT server which has two SQL instances older 2008R2 and newer 2014. Application team is managing it their own. The issue is application is not connecting after migrated databases from 2008R2 to 2014, even connection string been changed. I did basic connectivity checks, I can able to connect from other windows server where SSMS been installed. But unfortunately, I cannot test it from application server since it was UNIX server and application is JAVA based one. I have checked SQL logs and had logon trace as well to find any incoming connection and failures etc. I could not get any, then connection string been…