Does ERU(EEM Reporting Utility) tool works with MSSQL Server named instance

book

Article ID: 145464

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Workload Automation AE

Issue/Introduction


Does ERU(EEM Reporting Utility) tool works with MSSQL Server named instance ?

Resolution

Yes, ERU tool works with MSSQL named instance.

You need to mention the port number of the named instance in the below files(no need to specify instance name):
1.file "conf\service.xml" under Reporting Service installation folder.
2.file "conf\client.xml" under Reporting Client installation folder.

Ex:
<param name="url" value="jdbc:ca:sqlserver://hostname:port;DatabaseName=ERUDB" />