Technical Blog Post
ITCAM for MS Applications SQL Server agent Silent Installation/Configuration
Is it possible to install (and config) the ITCAM MS-Applications MSSQL agent (KOQ) silently?
We have logged onto a server where the agent has been manually installed and configured and exported the responsible file by using the utility in kinconfg and its generated the following...
License Agreement=I agree to use the software only in accordance with the installed license.
Install Folder=IBM Tivoli Monitoring
KGL64CMA=Tivoli Enterprise Monitoring Agent Framework(86-x64 only)
KOQ64CMA=Monitoring Agent for Microsoft SQL Server(86-x64 only)
Where do we set the instance settings such as DBSETTINGS.db_login=UserId
ITCAM for MS Applications MS-SQL agent does not allow silent configuration for multi-instances agents like OQ agent.
This is also the reason why there are not available response files or documentation in the Installation guide manuals.
In the response file even if you add the agent specific parameters it does not configure the agent.
For local as well as for Remote configuration we have to use either GUI or CLI (tacmd).
So basically you an silently install the agent, but then you need to use TEP client or tacmd AddSystem like:
tacmd addSystem -t OQ -n Primary:myhostname:NT -p
DBSETTINGS.db_home="C:\Program Files\Microsoft SQL Server\MSSQL"
DBSETTINGS.db_errorlog="C:\Program FilesçMicrosoft SQL
in order to create and configure the new instance.