Setting up Windows Authentication in the Microsoft SQL Server native client
Use the following configuration information when the IBM Cognos server is hosted on a Microsoft Windows operating system, and the existing Content Store type is Microsoft SQL server.
1 In the IBM Cognos Configuration application, set the Cognos Content Store Type to Microsoft SQL Server Database (Windows Authentication). (Data Access > Content Manager > Content Store > Type).
2 On the IBM Cognos server, change the logon for the IBM Cognos service from Local System account to This account and input the appropriate Windows account information.
The Windows account should have the following authority:
▪Access to all required resources (such as printers)
▪Authority to logon as a service and act as part of the operating system
▪Must be a member of the local Administrator group.
3 Using SQL Server Management Studio on the UNICOM Intelligence computer, add the Windows account, used to start the IBM Cognos service, to the Security > Logins list, and then assign the Server Roles of public and sysadmin.
4 Using DPM Explorer on the UNICOM Intelligence cluster, ensure that the DataSourceConnection property collection matches the following default settings:
Password: blank
UseODBCDriver: False
UserID: blank
WindowsAuthentication: True
See also