Upgrading Sitecore isn’t just a technical checkbox; it’s a necessary, strategic investment in the digital experience platform. Version 10.4 brings meaningful improvements in performance, security, and scalability that help organizations stay future-ready.
In a recent client engagement, the upgrade path from Sitecore XP 10.2.1 to 10.4 underscored a familiar truth: the first step in any upgrade journey is installation. While many guides outline the basics, real-world environments often surface unique challenges that official documentation doesn’t fully address.
This post kicks off a multi-part Sitecore Upgrade Series, starting with the installation process for Sitecore 10.4 and highlighting troubleshooting lessons from hands-on experience.
For the most part, you want to keep the default options. For the feature selection step, check Database Engine Services. Nothing more, nothing less.
Now, we want to make sure that the sa account works because the Sitecore Installation Assistant will use the sa account to create new databases for our Sitecore install. Try to connect to your local database using the sa account. If you kept the default options for your SQL install, you should be able to connect with the server name localhost.
If you run into the issue below, you will need to first connect using Windows Authentication and enable mixed mode authentication. Right-click on your local server in SSMS Object Explorer and click properties to get to the Server properties in the screenshot below. Make sure to restart the SQL Server service after this step!
After restarting SQL Server, finish configuring the sa account. Right-click the sa account in SSMS Object Explorer, and click properties. Give it a password that you will remember, you will need to provide this password for the Sitecore Installation Assistant later.
On the status page, make sure to grant permission to connect to the database engine and enable login:
Now validate the connection to your local SQL Server using the sa account.
Unpack the zip file for the Sitecore Installation Assistant for XP Single, and run the setup application.
Proceed with installing the prerequisites:
If you run into the error below, you will need to restart your machine to enable IIS if it has not been enabled on your machine as a feature yet. The Installation Assistant will enable IIS for you, but you will need to restart your machine and rerun the installation tool.
For the Solr and SQL server settings:
Optionally, for the SXA step, check the box if you need SXA. In this instance, this was left unchecked.
Proceed to the Summary and Validation pages and validate that all values are correct. Once validated, proceed to the installation step.
If your installation finishes without any issues, you will be able to navigate to your new Sitecore 10.4 instance.
Completing the installation is a crucial first step in realizing the benefits of Sitecore 10.4. From performance and scalability to future-ready security, upgrading ensures your digital experience platform continues to meet evolving business needs.
This post is Part 1 of a series. In Part 2, we’ll cover how to resolve a common Azure PaaS issue during upgrades: “No supported provider for blob is configured.” Together, these lessons will provide both the why and the how of moving to Sitecore 10.4.