Problem:
I have changed SOI store user password (Default user 'sa'). now I am not able to run reports from CABI.
Solution:
When SAMStore password is changed it need to change on the CABI as:
--------------------
1. Shut down the CA SAM Application Server and CA SAM User Interface Server services on the SA Manager system(SOI machine)
2. Open Reports designer in CABI Server
3. Login using administrator / <Password>
4. Select Tools -> Connections from the menu bar
5. Following steps need to be performed for both CA_SAM and CSDP connections in Connection wizard.
6. Select CA_SAM name and click on Edit button
7. Update sa user password in the password field and test connection and proceed further
8. Select Start, Programs, BusinessObjects XI 3.1, BusinessObjects Enterprise, Central Configuration Manager. The Central Configuration Manager dialog opens.
9. Select Apache Tomcat <version> and Server Intelligence Agent, click Stop, and then click Start when the services stop.
The database password is changed on the report server.
10. Access the Control Panel on the report server and double-click Administrative Tools, then Data Sources (ODBC).The ODBC Data Source Administrator dialog opens.
Click the System DSN tab, select SAMStore, and click Configure.
The Microsoft SQL Server DSN Configuration dialog opens.
11. Click Next, enter the new password in the Password field, and click Next again.
The connection is verified with the new password.
12. Click Finish.
The password is changed for report server communication.
13. Open the SOI_HOME\Reports\samreports.xml file on the report server, enter the new password in the <password> attribute, and save and close the file.
14.Start the CA SAM Application Server and CA SAM User Interface Server services in SOI machine.