[cisco-voip] Problem with Cisco Bars after Database Republish ("Could not find Cisco Unified database on this server")

[Michael Hamann]

Hello,

During the upgrade process of our CUCM 4.2(3) to version CUCM 4.2(3)sr4b
the database replication between our 2 servers (1x pub, 1x sub) failed.
After fixing this via dbhelper tool (everthing´s green and smiling again)
service seemed to be ok.

But now Cisco Bars does not work anymore. The backup process of the
publisher fails with "Error=[Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user '(null)'. Reason: Not associated with a
trusted SQL-Server connection." So it looks like some kind of database
setting for bars  is misconfigured after the republishing process.

Yesterday I tried to reinstall BARS (now in the newest version
4.0.150000), but the same error message occured. Now I get the message
"Could not find Cisco Unified database on this server" when I try to
configure the Backup source within BARS.

Curiously the backup of our second CCM (sub) works as expected (but
without CDR and TFTP Data). The "BackAdmin" User exists and is not locked
(and wasn´t changed manually at all).

I am runnig out of ideas... :-(

Any hint or idea on how to fix this is kindly appreciated

best regards
Michael


----------
OS Version: 2000.4.3a
OS Service Release: 2000.4.5bSR21
OS Upgrade: 2000.4.5a
Bars Version: 4.0.15000
CUCM Version: 4.2(3)sr4b
----------
Eventlog1:

18452 :
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.

----------

Eventlog2:

The description for Event ID ( 2 ) in Source ( Cisco BARS Scheduler )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer. The following information is part of the event: [Scheduler_Timer
at checkTime = 12:42:29 PM] The BARS Scheduler has missed the scheduled
backup for today. Recommended Action: Please take a manual backup.

----------

Bars Trace Log:

[02:00:04 AM]   CCM 4.2(3) on xx.xx.xx.xx is the supported version by BARS
4.0-
                .12000
[02:00:04 AM]   In function modBackupCCM backing up server xx.xx.xx.xx
[02:00:04 AM]   Staging Cisco Unified CallManager target xx.xx.xx.xx.
[02:00:04 AM]   strCRSInstall = False
[02:00:04 AM]   CM version = 4.2(3)
[02:00:04 AM]   ModCM33orAbove = True
[02:00:04 AM]   Saving Cisco Unified CallManager version.
[02:00:04 AM]   Server type = MCS7825H04
[02:00:04 AM]   LmHosts file not found.
[02:00:04 AM]   Staging Hosts file.
[02:00:04 AM]   Staging CallManagerAttendant file.
[02:00:04 AM]   Certificates folder created.
[02:00:04 AM]   Staging security files from C:\Program
Files\Cisco\Certificates
[02:00:04 AM]   In function modStageDir
[02:00:04 AM]   Staging IPMA configuration file.
[02:00:04 AM]   Finding Cisco Unified CallManager database.
[02:00:04 AM]   In function modSQLGetDB
[02:00:04 AM]   Error finding SQL database: -2147217843
[02:00:04 AM]   Error=[Microsoft][ODBC SQL Server Driver][SQL Server]Login
fail-
                ed for user '(null)'. Reason: Not associated with a
trusted SQL-
                 Server connection.
[02:00:04 AM]   Exiting function modSQLGetDb with return value = !!!error!!!
[02:00:04 AM]   Could not find CM db on xx.xx.xx.xx.
[02:00:04 AM]   Error occured while finding SQL database on xx.xx.xx.xx.
[02:00:05 AM]   Could not find CDR database on xx.xx.xx.xx.
[02:00:05 AM]   Inside Function modExecuteQuery
[02:00:05 AM]   Error in modExecuteQuery: -2147217843 - [Microsoft][ODBC
SQL Se-
                rver Driver][SQL Server]Login failed for user '(null)'.
Reason:-
                 Not associated with a trusted SQL Server connection.
[02:00:05 AM]   Could not determine the path for CDR flat files from
database. -
                Backing up from default location.
[02:00:05 AM]   LocalCDRPath = C:\Program Files\Cisco\CallDetail