Setting up SQL Server authentication with an ODBC driver
Use the following configuration information when the IBM Cognos server is not hosted on a Microsoft Windows operating system.
1 On the IBM Cognos server, manually create the ODBC data source (SQL Server driver) using the project's database name.
The project’s database name is not always the same as the project ID.
2 Using DPM Explorer on the UNICOM Intelligence cluster, update the DataSourceConnection settings as follows (these are not the default settings):
▪Password: Enter the password for the sa account
▪UseODBCDriver: True
▪UserID: sa
▪WindowsAuthentication: False
See also