Unable to login to ZAM WebConsole

  • 7001342
  • 11-Sep-2008
  • 27-Apr-2012

Environment

Novell ZENworks 7.5 Asset Management - ZAM7.5
Novell ZENworks 7 Asset Management - ZAM7

Situation

Login to the ZAM Manager works
 
When launching the WebConsole the login screen does not come up. 
 
ERROR: "Server error connecting to database. Contact your system administrator."

Resolution

Go to C:\Tomcat5\Webapps and open the rtrsetup.xml file in Wordpad.exe. Locate the following sections
 
<ReportServerSetup>
     <param>
          <name>DBName</name>
          <value>jdbc:odbc:ZENworks Reports</value>
     </param>
     <param>
          <name>DBUser</name>
          <value>NCSystem</value>
     </param>
     <param>
          <name>DBPasswordEncrypted</name>
          <value>394531345501317</value>
     </param>
 
Verify the information in those sections are correct.  The DBName should be the same ODBC driver you are using for the Manager.  The DBUser should be NCSystem, or can be something else if you specified a different name for NCSystem during the ZAM installation.  The DBPasswordEncrypted is the encrypted password for the NCSystem user. 
 
If the DBName and DBUser fields are correct and you think the password may not be correct, you can try one of the 3 following options.
1) Open a ticket with Novell Support at no charge to get your password encrypted
2) Remove the word Encrypted from the value, and put in the plain text password
3) Remove the WebConsole and Apache/Tomcat from Add/Remove programs, then reinstall it.