Interviewer - Server Admin > Publish Data > Setting up Publish Data for IBM Cognos > Setting up SQL Server authentication with an ODBC driver
 
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.
Note 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
Setting up Publish Data for IBM Cognos