SQL Monitor Automation Guidance

tehcoin

Hello,

I have been attempting to automate the upgrades and consistently no matter how its formatted I get an error stating i must accept the EULA. I have extracted the web msi from the webinstaller with the switch and extracted the base msi using lessmsi and extracting that with the/IAgreeToTheEULA switch.

I have tried using =1, different quotes and tried /IAgreeToTheEULA which fails before attempting to install.

I have attempted to use SCCM and encountered it there as well from the event viewer. 

PS Snippet - 

 $MSIArguments = @(

    "/i web.msi",

    "/quiet"

    "I_AGREE_TO_THE_EULA=yes",

    "INSTALLDIR=`"C:\Program Files\Red Gate\SQL Monitor\WebMonitor\`"",

    "SERVICETYPE=local",

    "SERVICERPCPORTNUM=7399",

    "/norestart",

    "/l*v `"$smWebMSILocation\Logs\SQLMonitor-Web-$DateStamp-log.txt`""

) 

Same thing, but a snippet install from SCCM Program field:

msiexec /i "web.msi" /q  I_AGREE_TO_THE_EULA="yes" SERVICETYPE="local" INSTALLDIR="C:\Program Files\Red Gate\SQL Monitor\Web\" SERVICERPCPORTNUM="7399" 

Any guidance would be great!

tehcoin

Excellent. A link to the documentation I was following.

Jon_Kirkwood

Hi @tehcoin

 In regards to your comment about the documentation link; I am assuming it is possibly this guide that you are working through?

https://documentation.red-gate.com/sm/maintaining-and-upgrading-sql-monitor/upgrading-sql-monitor/automated-installation-and-updates/setting-up-automated-installs

 Are you able to confirm which major release of SQL Monitor you are working with, it may have had some context changes if you aren't on current release v13, and we can check into that if needs be.

 

Immediately it does look correct with passing in the I_AGREE_TO_THE_EULA=yes statement for the web.msi to run

.\web.msi I_AGREE_TO_THE_EULA=yes

 

Can you share a screenshot of the error and possibly try without the /q and share any other information that is processing before/after the EULA error