Sitecore 9.0.2 xp0 installation using Sitecore Complete Install Assistant (Step-by-Step)

Prior to Sitecore 9.1 the xp0 installation zip didn't have the prerequisites.json. The SCIA installer auto-generates the prerequisites.json for the 9.0.x versions and installs the same so that you don't need to hunt and install those Windows prerequisites one after another!


Now, let's get to the actuals:

Prerequisites: SQL Server 2017  

1. Download the latest SCIA installer:



I downloaded the installer tagged 3.14 since that's the latest release at the time of this writing.

2. Copy over the installer to a file system folder. In my case, I created a SCIA folder in c:\ and copied over my SCIA.exe there - 

3. I installed SQL Server 2017 and configured mixed mode so that I can login with a sa username and password. Once SQL Server 2017 is setup, I decided to check logging in to SQL Server using the SCIA installer. So, right clicked the SCIA.exe and "Run as Administrator":

4. When SCIA main form opens up, provide the sa password and  click Connect button:


If the login credentials are correct, the login dialog disappears. This means you are successfully logged-in to the SQL Server DB!

5. Next, let's populate the SCIA DB in order to work with different Sitecore versions:


In the above form, just click the Create button.

6. Once you click the create button, the status message must display "DB Tables Setup Successfully" as follows:


Close this form.

7. You can now cross check that DB is created by logging in to SQL Server and finding a db named SCIA now. The other way to check without leaving the SCIA application is to check the versions list by clicking the button show here below:


If we click the Sitecore Version dropdown, we can see the various Sitecore versions. 

8. Since we are going to install 9.0.2, we will select the same in the Version Selector and save the same:


9. When I clicked the save button, since this is a brand new machine, I get this message that says PowerShell module is missing in the specified path:


10. So, minimize the above form. In order to install the PowerShell module, click the "SIF Module install" button and it automatically launches PowerShell window as shown here below:


11. In the launched PowerShell window, press Y for all prompts:


12. Once the PowerShell installations are complete and the PowerShell prompt returns, close the PowerShell Window and return to the SCIA application. Open the Sitecore Version Selector one more time and select 9.0.2 in the drop down and save. This time the form should disappear. This means the version is set correctly!

13. Once the version is set, you should be able to see new buttons enabled in the menu bar:


14. Since this is  a new machine, I'm going to install Solr 6.6.2 required for Sitecore 9.0.2. So, once I click the Solr installer button in the main menu bar, the installer form will appear:


Since I'm going to install version 6.6.2 , I keyed in that info in the above form. I also added a prefix to make the service name unique but prefix can be left blank if you are sure there is no service with the name displayed in the Solr Service field. Don't tamper other auto-filled fields!

15. To be sure that the Port 8983 is free, you can use the Port Availability Checker button and enter 8983 and check if its free. Since this is a new machine, the concerned port is free:


16. So, back in the Solr installer form, when you click the install button, PowerShell Script is launched to install Solr in port 8983:



17. Once the PowerShell command comes back, you can check the Solr service running fine by entering https://localhost:8983/solr in the browser:


18. Since Solr is installed, let's start our Sitecore 9.0.2 instance installation by clicking the highlighted main menu button for SIF installer launch:


Note that the DB credentials are prefilled.

19. Click on the DB Connect button to traverse to the next tab:


20. Since I'm using this application for the first time in this machine, I get a pop-up with prefilled settings. I wish to retain the default settings. So, will press the Save button:


21. The Braintree settings are more relevant to Commerce installation so, just provide random values for now and press save button again:


22. Close the settings form as well as the SIF installer and re-open the SIF installer again. Now, when you press the DB Connect button, you should be able to traverse to the Site info tab:


23. Provide a Site prefix and press the next button to traverse to the next tab:


Note that the SiteNameSuffix is picked from the values we saved in the settings form.

24. In the General tab too you will find pre-filled values. We'll retain the same:


25. Press next button and you should be able to see the Website instance install location and Sitecore admin credentials with the famous password defaulted to b. So, its good to keep these defaults as-is:


26. In the Solr tab, provide the Solr url and press the Solr Check button in the menu:


If the Solr url is correct, the Solr details will be prefilled for you. Don't forget the https in the solr url!

27. You can also note that the Install/Uninstall and Generate Scripts are enabled now. Click on the Install button:


Lazy me! I didn't download the prerequisites for Sitecore 9.0.2 installation. So, I need to setup my prerequisites before I start the actual installation process.

28. I can launch the prerequisites form by clicking the prerequisites button from the menu bar:


29. Copy over the license.xml to c:\SCIA - 



30. Since I'm yet to download the prerequisites, I click the "Download and Setup All Prerequisites" link in the prerequisites form, this goes off to the Sitecore Site and downloads the prerequisites and unzips locally:



31. Wait until the PowerShell prompt returns. Once the prompt returns, go to the file system and check if the prerequisites are downloaded and unzipped as desired. Looks good in my case:


32. Next, its time to install the prerequisites. So, click the "Install prerequisites" button in the prerequisites form:



PowerShell is launched again to perform the installation. Most importantly, restart the machine as soon as prerequisites installation is over. Otherwise, you would get errors while accessing sqlcmd during installation of WDPs to db. Like this one:

PS>TerminatingError(Get-Command): "The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: The term 'sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again."
>> TerminatingError(Invoke-CommandTask): "Cannot validate argument on parameter 'Path'. The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: The term 'sqlcmd' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again."
Install-SitecoreConfiguration : Cannot validate argument on parameter 'Path'. The running command stopped because the 
preference variable "ErrorActionPreference" or common parameter is set to Stop: The term 'sqlcmd' is not recognized as 
the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was 
included, verify that the path is correct and try again.

33. Once our prerequisites installation is over and having restarted the machine, we are ready to restart the Sitecore 9.0.2 installation. So, re-open the SCIA.exe, provide Site prefix and this time click on the Validate button to re-enable the buttons after re-filling the Solr url:



34. You must receive a Congrats status message on clicking the Validate button and all buttons are enabled:


35. PowerShell would prompt for consent to execute script. Press A so that there are no further prompts. So, the install should cruise on:


36. No wonder, All ends well :











Comments

Post a Comment