Setting the DSN for ODBC Clients and Kerberos SSO
Using Kerberos with an ODBC client requires driver configuration. ODBC Client applications can connect with TDV using a 32-bit or a 64-bit TDV driver. The computer on which the ODBC client application resides must have one of the TDV drivers installed and configured.
To add the Kerberos system DSN
1. Log in as an administrator.
NOTE: The ODBC manager may truncate the password at 14 characters.
2. Run one of the following to install the ODBC driver on a Windows client:
— CsOdbcInstall<version>.exe installs cis<version>.dll
— CsOdbcInstall<version>_x64.exe installs cis<version>_x64.dll
3. Open the ODBC Data Source Administrator, accessible through the Windows control panel named Data Sources (ODBC) under Administrative Tools.
4. Select the System DSN tab, click the Add button, select the system data source you just installed, and click Finish.
The ODBC Driver Configuration window appears.
5. In the ODBC Driver Configuration window, set the Integrated Authentication field to Kerberos.
This System DSN enables TDV to recognize the specified data source and catalog.
6. Define the Kerberos SPN using the Microsoft format:
HTTP/FullyQualified_HostName@Realm
7. Click Test.
8. Click OK.