In this article, we will be installing SQL Server onto our Rock server. Let's begin. Start the SQL Server installer and on the first screen click on New SQL Server stand-alone installation or add features to an existing installation. On the next screen, agree to the license agreement and then click Next. Keep the Include SQL Server Product Updates checkbox checked and click Next. Next, the SQL installer will prepare to set up. On the Feature Selection screen, we recommend using the settings shown in Figure 4.8. These are the minimum required settings needed for Rock. Click Next to continue. On the Instance Configuration screen, click on the Default Instance button. Click Next. NoteWarningBe sure to use Default Instance if you are unfamiliar with SQL Server. This will simplify our Rock setup. We only recommend using Named Instances if you are familiar with them. Leave the default settings on the Server Configuration screen and click Next. On the Database Engine Configuration screen, set the Authentication Mode to Mixed Mode and set a password for SQL Server. Click Next. NoteKeep this password handy since it will be needed later to set up the Rock RMS database. But remember to keep this password secure, and only share it with those who truly need it. Skip past the Error Reporting unless you would like to send Microsoft error reports. Click Next. Installation will begin, so hold tight. Once it's complete with the installation, you can close the installer. Now, the SQL Server Installation Center (the first screen of the installer) should still be open on your desktop. Whereas you clicked the first option last time, now we need to click Install SQL Server Management Tools. This will launch the web browser, pointed to the SSMS Download page. You need to download SQL Server Management Studio, not just the upgrade package. Download and then run this package. (You can close the Installation Center window now). There aren't many options in the installation of this package- just accept the license and let the installer run.