PowerShell Install for AWS or Azure Servers Deployment

File Location:

ftp://microix.com/workflowmodules_2021/WorkflowModulesInstaller/PowerShellDeployment/servconsole.zip

NEW SERVER INSTALLATION SCRIPT:

Step 1: Run the srvconsole.exe along with the parameters matching your SQL environment - C:\Users\guest\Desktop\ServerSilentInstall\srvconsole.exe InstallType="NEW" SQLServerName="LocalHost" UserID="sa" Password="1234" MIPDB="NTO"

Log File (SilentInstallLog.txt) example after server installation is completed

06/04/2021 11:17:09 AM - Microix Workflow Modules New Server Install Started.... LocalHost

06/04/2021 11:17:09 AM - Downloading Microix Share files...

06/04/2021 11:17:32 AM - Download Completed.

06/04/2021 11:17:32 AM - Installing Microix databases...

06/04/2021 11:17:33 AM - Reading file : C:\Microix Share\Autoupdates\SQLScript\MWFMSys_CreateDatabase.sql

06/04/2021 11:17:33 AM - SQL script MWFMSys_CreateDatabase.sql completed. Total scripts executed - 68.

06/04/2021 11:17:33 AM - Reading file : C:\Microix Share\Autoupdates\SQLScript\MWFMData_CreateDatabase.sql

06/04/2021 11:17:35 AM - SQL script MWFMData_CreateDatabase.sql completed. Total scripts executed - 2283.

06/04/2021 11:17:35 AM - Reading file : C:\Microix Share\Autoupdates\SQLScript\MWFMAttachment_CreateDatabase.sql

06/04/2021 11:17:35 AM - SQL script MWFMAttachment_CreateDatabase.sql completed. Total scripts executed - 19.

06/04/2021 11:17:35 AM - Registering New Database...

06/04/2021 11:17:35 AM - Upgrading SQL databases...

06/04/2021 11:17:35 AM - SQL script completed for MWFMSys. Total scripts executed - 29.

06/04/2021 11:17:42 AM - SQL script completed for MWFMData. Total scripts executed - 1117.

06/04/2021 11:17:42 AM - Acquire Activation Codes...

06/04/2021 11:17:42 AM - New Installation Completed!

STEP 2: WORKSTATION INSTALLATION SCRIPT:

\\Microix Share\Setup\wssetup.msi SQLSERVERNAME="EnterSQLServerNameHere"

UPGRADE EXISTING SQL SERVER:

Step 1: Run the srvconsole.exe along with the parameters matching your SQL environment - C:\Users\guest\Desktop\ServerSilentInstall\srvconsole.exe InstallType="UPGRADE" SQLServerName="LocalHost" UserID="sa" Password="1234"

Log File (SilentInstallLog.txt) example after server installation is completed

06/04/2021 11:21:51 AM - Microix Workflow Modules Upgrade Started.... LocalHost

06/04/2021 11:21:51 AM - Downloading Microix Share files...

06/04/2021 11:22:08 AM - Download Completed.

06/04/2021 11:22:08 AM - Upgrading SQL databases...

06/04/2021 11:22:08 AM - SQL script completed for MWFMSys. Total scripts executed - 29.

06/04/2021 11:22:15 AM - SQL script completed for MWFMData. Total scripts executed - 1117.

06/04/2021 11:22:15 AM - Acquire Activation Codes...

06/04/2021 11:22:15 AM - Upgrade Process Completed!

WORKSTATION INSTALLATION SCRIPT:

\\Microix Share\Setup\wssetup.msi SQLSERVERNAME="EnterSQLServerNameHere"