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

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:

 

 

 

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