Installing SQL Server 2008 R2

This is a step-by-step guide on how to install SQL Server 2008 R2. You can use this installation as the basis for the SQL instance, where you will store the database for XenApp 6.5 or System Center Configuration Manager 2012. We will only install the Database Engine Services in this guide, because that’s the only requirement for a basic Citrix XenApp 6.5 or Microsoft SCCM 2012 installation. The other services are used to perform optional tasks only.

1. Installation of SQL Server 2008 R2

1.1 First of all you will have to add the .Net Framework 3.51 feature on the server, as its a prerequisite for installing SQL Server 2008 R2.

1.2 Now start Setup.exe

1.3 Choose Installation, and then choose New Installation or add features to an existing installation.

1.4 Setup Support Rules are ran. Click OK.

1.5 Specify the Evaluation version, or enter the product key

1.6 Obviously you will have to accept the license terms

1.7 Install the Setup Support Files

1.8 Setup Support Rules are ran next, and they might reveal warnings or errors. Review and correct those, if possible.

Microsoft .Net Application Security Warning – The machine I am installing SQL Server on, does not have a connection to the internet. Therefore I am getting this warning.

Windows Firewall Warning – You can see a list of Firewall ports used by the SQL server in this article on Technet. Just make sure to at least open port 1433, otherwise you will not be able to make remote connections to the SQL Server.

1.9 Next up is the Feature Selection Screen. Choose Database Engine Services, Management Tools- Basic and Management Tools – Complete. You can also install SQL Server Books Online if you like, those are the help files for SQL Server 2008 R2. When you are done choosing which features you want to install, click Next.

1.10 Installation Rules are ran. Click Next.

1.11 Here you can choose the name of the SQL instance you are installing, or you can keep the default instance name, which is MSSQLSERVER. Click Next, when you have made your choice.

1.12 Click Next again

1.13 You can choose to have different service accounts for the different SQL services, or you can choose to use the same account for all SQL Server services. I am choosing the latter.

1.14 Which then lets me specify the name and the password of the account I want to use.

1.15 Now click on the Collation tab of the Server Configuration screen.

1.16 Choose SQL_Latin1_General_CP1_CI_AS, then click OK.

1.17 Now click Next on the Server Configuration screen.

1.18 Specify which authentication mode you would like for the Database Engine, then specify SQL server administrators. As you can see I am choosing Windows authentication mode, and I am choosing to specify a group. Which means that I can just add members to that Active Directory group, whenever I need to give someone administrative access to the Database Engine on this SQL Server installation.

1.19 Click the Data Directories tab. Here you can choose to store these directories on different volumes if you like. Then click next.

1.20 Make your selection and then click Next.

1.21 Installation Configuration Rules are ran. Click Next

1.22 Click Install

1.23 Click Close when finished.

Next, install SQL Server 2008 R2 SP3, which is pretty much a next -> next -> finish session.