In this tutorial, you will learn how to install the foundation SPA site. In mid-2020 this new react sample site was released. This foundation SPA is Episerver's first foray into giving some information on how to build a full SPA within Episerver. As the sample site uses more technologies than the normal Alloy you may encounter a few more surprises when setting it. While the steps to install the foundation SPA are fairly simple, I have encountered a few issues whenever I have tried to clone and install it. In this guide, I will give a quick walk-through of my experiences installing the site and how I overcame some of the issues. First, to install the site you will need to clone it from here:

https://github.com/episerver/Foundation-spa-react

After cloning the code. Check that you have the correct dependencies installed. Open a terminal within admin mode and run:

In order for the installer to run correctly a version over 12.16.3 needs to be returned. Next, before running the installer ensure that you can manually log into your local SQL instance using SQL server authentication.

Within the terminal run the setup.bat. This will kick off the installer. When the installer kicks-off you will be asked to add a few configuration options, the important ones are the SQLSERVER. Ensure this value matches the server name yo uuse to log into SQL. The ADDITIONAL_SQLCMD should be set like this:

One issue I encountered that prevented the SQL database from installing, was this error:

Error: Microsoft ODBC Driver 13 for SQL Server

I overcame this issue by uninstalling and re-installing, ODBC Driver 13. If you encounter the same issue then you can download the driver here:

ODBC Driver 13.1 for SQL Serverhttps://www.microsoft.com/en-us/download/details.aspx?id=53339)

Installing the driver fixed the installer on my home laptop. When installing the sample site on my home laptop I encountered a separate SQL issue. For whatever reason, the SQL scripts failed to run and the database was not installed. To check if the database installed using SSMS to login into the server, check the foundation database exists and it has tables installed. If the installer failed you can make some manual tweaks within the SQL script in order to get it to work, Online 155 I updated this line:

To:

Where 'LDNPLMDEV1147' is the name of my SQL server. On line 65 you will also notice this script:

As you can see the password is hardcoded. I updated the script like this:

For good measure I also updated line 52, like this:

After doing these updates the database installed as expected. After the installer finishes the site will load with and you may encounter an exception. Open up Visual Studio and compile the website and everything should now install. Enjoy!