How to get ZRS on Linux to work with external ZCM database on MSSQL

  • 7006288
  • 15-Jun-2010
  • 12-May-2014

Environment

Novell ZENworks 11 Configuration Management Reporting Server
Zenworks Configuration Management 10.3
Zenworks Reporting Server
SUSE Linux Enterprise Server 11
SUSE Linux Enterprise Server 10
Microsoft MSSQL 2005
 
 

Situation

Installed Zenworks Configuration Management 10.3 on SUSE Linux 11.
Set Active Directory as the user source and set up external DB as MSSQL on an AD server.
Verified that ZCC is running properly.
Then installed ZRS Zenworks Reporting Server on the same server. 
When trying to run any reports the following error is seen:
 
[DataDirect][ODBC SQL Server Driver][SQL Server]Login failed for user zcm-db-user@company.com
 
 

Resolution

Zenworks Reporting Server on Linux uses BOE and BOE does not support Windows Authentication
In order to get ZRS to properly authenticate and query against MSSQL
 
 If AD is going to be used as the user source then:
   a) Setup MSSQL server to function in MixedMode.
   b) In MSSQL create a local DB account with full rights to the Zenworks DB.
   c) modify the following 2 files  dmaccounts.properties and dmamappings.properties.
   The files are located in   /etc/opt/novell/zenworks/datamodel/
   replace the AD username and password with the local DB user account/password  created in step b) above.
   d)  Restart the services.   (/opt/novell/zenworks/bin/novell-zenworks-configure -c Start).
   e) verify access ZCC is working.
   f) Update the BOE to see the updated config files   (novell-zenworks-configure -c UpdateBOE)
   g) verify reports for ZRS now run in ZCC

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