ZRS Linux Appliance connection error after database move

  • 7010091
  • 01-Feb-2012
  • 30-Apr-2012

Environment

Novell ZENworks 11 Configuration Management (ZCM)
Novell ZENworks 11 Configuration Management Reporting Server (ZRS)
Novell ZENworks 11 Configuration Management Business Objects Reporting
BusinessObjects Enterprise (BOE)
SUSE Linux Enterprise Server 11 Service Pack 1 (SLES)

Situation

The ZENworks Microsoft SQL database IP/DNS address has changed.
Steps in the ZENworks documentation followed to point to a new MS SQL database (see Additional Information section below).
This file updated: /etc/opt/novell/zenworks/datamodel/zdm.xml

After these changes ZRS can be logged into, but no reports can be run.  When running a report the following error is displayed:
A database error occurred.  Cannot open database "database_name" requested by the login.  The login failed (WIS 10901)

Resolution

This file will also need updating for a ZRS server to point at the new database address:
/opt/novell/zenworks/share/boe/bobje/odbc.ini

Edit the Address= entry.
For example: Address=server_address, 1344

Once updated restart the ZRS service:
/etc/init.d/BobjEnterprise120 stop
/etc/init.d/BobjEnterprise120 start

Additional Information

The main documentation:
32.6 Configuring the ZENworks Server to Point to the New MS SQL Database Containing Data Moved from Another MS SQL Database
https://www.novell.com/documentation/zenworks11/zen11_system_admin/data/bfxsr85.html

For a ZRS server the steps in the documentation must be carried out in addition to the steps in this TID.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.