Required to create an Application through .exe after every SQL Install----Need help for this task autoamtion

Greetings,

I am very new to PS and I am a SQL DBA.

Kindly help me with the below situation.

After every SQL Installation,I need to install an agent by running a .exe file.

I copy that .exe file from a remote server and the path look like this:

\\Servername\d$\SQLAdmin\************Installer.exe

As I have to install this agent regularly after every SQL install,am trying to automate the process through powershell.

As my first step:

1) Start-Process -FilePath "\\Servername\d$\SQLAdmin\************Installer.exe"

Next i do get a message box which says Run or Cancel.

Till I say Run it will not proceed further.

My Requirement:

There are four Message boxes I do get  during this installation:

Run or Cancel

Next

Ok

Success,Failure

How can i make this applciation installation a silent installation,I mean all by itself based on the powershell script for this task and I want this script to be attached to the SQL Silent Installation.ps1 immediately after the Installation of SQL Server is successful.

============================

Experts,

 Can you kindly help me with this automation as it helps me with lot of ************Installer  installations after every SQL build.

Please help me automate the process.

 

Regards,Vkumar

  • Ho Vkumar,

    The first thing to do is to check to see if your software actually supports an unattended installation.  Otherwise, you're either going to have to package it to a format such as msi, or go down the AutoIT route for programmatically pressing those buttons for you.

    Have you checked this?

  • Actually,

    We use powershell script for SQL 2012 Installation,and most of the installations I am doing these days are of SQL 2012.

    So,if the script is working for SQL Installation,hope I  can automate even the agent installation from .exe file through powershell script and add that script to SQL 2012 powershell script.

    Once the installation is completed along with it this agent should be installed,this is what I am thinking of.

     

    Kindly undstd me as I am completely not aware of this powershell,but I guess it works.

    Regards,

    VKumar

  • It's a good plan to do that.

    The thing you need to check though is whether the agent program you are talking about has unattended parameters.

    Can you give any more details about the program it is that you wish to install after SQL installation?