Setting up SQL Server 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 not Microsoft SQL server.
1 Ensure that the UNICOM Intelligence RDB2 SQL Server uses mixed SQL Server and Windows Authentication mode. If the server uses Windows Authentication mode only, update the authentication mode using the following steps.
Changing the security authentication mode
2 In SQL Server Management Studio Object Explorer, right-click the server and then select Properties.
3 On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
4 In the SQL Server Management Studio dialog, click OK to acknowledge the requirement to restart SQL Server.
5 In Object Explorer, right-click the server, and then click Restart.
If SQL Server Agent is running, it must also be restarted.
Enabling the sa login
1 In SQL Server Management Studio Object Explorer, expand Security, expand Logins, right-click sa, and then select Properties.
2 You might be required to create and confirm a password for the login on the General page.
3 On the Status page, in the Login section, click Enabled, and then click OK.
4 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: False
▪UserID: sa
▪WindowsAuthentication: False
See also