The SSO configuration supports multiple Trillium users accessing SQL Server connections using their trusted Windows authentication credentials.
The following steps outline this configuration process:
Install Trillium including the Trillium repository server, on a Windows 2012 or 2012 R2 server system. The server installation program installs the ODBC Trillium-supplied adapter. For installation details, see the Trillium DQ Installation Guide.
Create a service account on the Windows domain to provide a context for services running on the Windows server. The service account allows multiple Trillium client users access to secure SQL Server data sources in the Control Center without having to supply a password.
Configure the Windows server system on which Microsoft SQL Server is installed by adding the service account to each database the Trillium user will access.
Configure the Windows server system on which Trillium is installed by granting the service account full rights to the Trillium directories.
Configure the TSS inetd and TSS scheduler services to log on as the service account. If you use Discovery Center in this SSO environment, then configure the TSS REST API service as well.
Define a DSN using the TSS 17 SQL Server Driver.
In the Repository Manager, create a loader connection for SQL Server using the TSS ODBC (Trillium-supplied) driver. Select the Use Single Sign-on check box to enable SSO for that connection. For more information, see Loader Connections.