When the user performs an STI backup, SQL database errors appear in the log

[TCC_2]

Core Issue

The backup completes successfully, but errors such as these are found in the log:

Deleting license.properties files from staging directory
[14:12:42]     Finding latest cra database on CRA-server
[14:12:42]     Fatal Error - Error finding SQL database: [Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
[14:12:42]     Fatal Error - Could not find a craSQL database on CRA-server
[14:12:42]     Finding latest ccdr database on CRA-server
[14:12:42]     Fatal Error - Error finding SQL database: [Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
[14:12:42]     Fatal Error - Could not find a ccdrSQL database on CRA-server
[14:12:42]     Finding latest scheduler database on CRA-server
[14:12:42]     Fatal Error - Error finding SQL database: [Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
[14:12:42]     Fatal Error - Could not find a schedulerSQL database on CRA-server
[14:12:42]     Finding latest ICD database on CRA-server
[14:12:42]     Fatal Error - Error finding SQL database: [Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
[14:12:42]     Fatal Error - Could not find a ICDSQL database on CRA-server
[14:12:42]     Staging Sch.ini from CRA-server
[14:12:42]     Staging JobRunner.ini from CRA-server
[14:12:42]     Staging Grammar and Prompt files from CRA-server
[14:13:08]     Staging all files from Desktop_Config\Config folder
[14:13:08]     Staging all files from Desktop_Config\Icons folder
[14:13:08]     Staging all files from Desktop_Config\AudioFiles folder
[14:13:08]     Saving version information
[14:13:09]     No Cisco CER targets found
[14:13:10]     Staging stiBack.log file as 00stiBack.log
[14:13:10]     RESULT: Backup failed for CRA: CRA-server
[14:13:10]     Finished copying stiBack.log file to the staging directory

These errors indicate that Customer Response Applications (CRA) was not backed up successfully, but other applications may have been backed up successfully.

Resolution

If the backup server and CRA server are different machines, the backup software has to be installed on both servers. Perform these steps:

1. On the machine that conducts the backup, install the software as Backup Server.
2. On the machine that needs to be backed up, install the software as Backup Target.

The backup process uses the BackAdmin user account for connecting to Structured Query Language (SQL). The passwords for this user should be synchronized on the two servers. A situation similar to the one described would occur if BackAdmin passwords were not synchronized (if the target was not installed or the passwords were not synchronized on the two machines) while the administrator passwords were the same.

For more information on the installation of the backup and recovery tool for the CRA side, refer to the Backing Up and Restoring Your Cisco CRA Files section of Installing Cisco CRA 3.0.