Connecting Microsoft SQL Server with SSL protection and Kerberos authentication to propagate user ID without the need to reenter the password multiple times.
Secure Sockets Layers (SSL) is a standard that provides confidentiality and integrity to a TCP/IP transport, such as the one that the ODBC driver uses to communicate with an SQL Server instance.
Kerberos is a protocol that is devised by MIT to allow resources to be secured through a trusted third party (The Kerberos KDC). When the protocol is implemented by Microsoft, it can be used only to secure access within a complete active directory domain.
Integrated Windows Authentication (IWA) gives you the option of propagating your user ID in a Windows environment to other Windows services without needing to reenter your password multiple times. This behavior is not available for Linux and UNIX clients because they do not use the same security contexts as Windows. However, a Kerberos login can be used instead to achieve the same result for Linux and UNIX clients.