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

[Michael Hamann]

Hello,

I reply to myself... I just tried to use the DNS Name (CCM1 in our case)
instead of the ip address in the Data source configuration of bars.

With DNS name it seems to work...

Will try to restore the data on a standby server the next days but so far
it looks quite good...

just to let you know...

Michael


Am Di, 16.02.2010, 10:40, schrieb 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
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>