To complete this post, we are going to install SQL Server 2008 R2 Enterprise Evaluation edition on a virtual machine running on Windows Server 2008 Service Pack 2. To see a complete list of Hardware and Software requirements for the installation of SQL Server 2008 R2, click here. You can download the SQL Server 2008 R2 Enterprise Evaluation Edition from here. Before starting the SQL Server installation, we are going to create the accounts, which will be used to run the SQL Server services. As we are going to deploy on a stand alone machine in a workgroup environment, we are going to use local windows accounts. In a domain environment, use domain accounts to run the SQL Server services.
Creating Service Accounts for SQL Server
In this part, we are going to create two service accounts for SQL Server 2008 R2 installation. For this demo, we are going to create two accounts; TestLab3_Data and TestLab3_Agent. From the screenshot we can find that Service Pack 2 of Windows Server 2008 has been installed. Follow the steps mentioned below to create the service accounts for SQL Server 2008 R2.
- After log on to the server, open Computer Management (Start –> Administrative Tools –> Computer Management).
- Expand System Tools, and click on Local Users and Groups. Expand Local Users and Groups, and click on Users.
- Right-click on the Users folder and select New Users. Enter the User name, Full Name, Descriptions, and Password for the user account and click on Create. The new user account will be created.
Verifying the Service Accounts
Once the accounts are created, make sure the passwords for the accounts are working properly. To test the accounts, we can execute the following commands from the command prompt:
runas /user:<machinename>\<username> cmd
Enter the password for the user account when prompted.
So when we verify the SQL Server database engine service account, we will get the following result:
Similarly, we can also verify the service account for SQL Server Agent service. Now, its time to start the SQL Server 2008 R2 installation.
SQL Server 2008 R2 Installation
After downloading the SQL Server 2008 R2 Enterprise Evaluation setup, we need to extract it. Once the extraction is completed, we are ready to start the SQL Server installation.
1. Inside the extraction folder, right-click on the Setup.exe, and click on the option Run as Administrator. Note, in Windows Vista / Windows Server 2008, always execute the setup program by right-click on it and choose Run as Administrator from the drop down menu. This setup is going to install .Net Framework 3.5 SP1, which is a pre-requisites for installation of SQL Server 2008 R2.
2. Accept the License Agreement to continue the .Net Framework setup, and click on Install.
3. Click on Exit, once the .Net Framework installation is completed. This will start the SQL Server installation. You will get the following screen once the .Net Framework installation is completed.
4. The above screen will opened the SQL Server 2008 R2 Installation Center.
5. Click on the Installation tab present on the Left side of SQL Server Installation Center. We will get the following screen. To install on a stand alone server, click on the first option.
6. After you clicked on New installation or add features to an existing installation, SQL Server will run a set of checks which need to be passed before the setup will continue further. There are 7 checks which must be passed, if failed, you need to take corrective actions before continuing further. Once all the tests passed, you will get the following screen. Click on Ok to continue.
7. Specify the version of SQL Server you are going to install. For completion of this blog post, I am going to install the Evaluation edition. Click on Next to continue the installation.
8. Accept the Licensing Agreement to continue further.
9. Click on Install to start the installation of the Support Files.
10. Once the support files are installed, you will get the following screen. Don’t worry about the following two warnings. The first warning says that the server is not connected to the internet and the second error says, the Windows Firewall is enabled. Its fine for my testing, however, in the production environment, we need to make sure that all the checks are passed. Click on Next to continue further.
11. Select the SQL Server features which you want to install. Since the objective of this post, is the installation of SQL Server 2008R2, we are going to choose the default option: SQL Server Feature Installation. Click on Next to continue.
12. Select the features of SQL Server we are going to install. If we take a close look at the available features, than we can see that SQL Server Integration Service is not listed in the above list. For the current deployment, we are not going to install Reporting Service & Analysis Service. Click on Next to continue.
13. SQL Server will run another set of checks which will validate whether the selected features can be installed on the server. Once the checks are done, we will get the following screen.
14. On continuing Next, we will get the Instance Configuration Page. Since this is the first instance to be installed on the server, we will make it as Default instance. Click on Next to continue.
15. On the Disk Space Requirements page, the setup will check whether the required disk space is available. It will give us the details about the required disk space for the installation along with the available disk space on the system hard drive.
16. The Server Configuration Page consists of two tabs; Service Accounts Page and Collation Page.
On the Service Account tab, we are going to provide the details of the service accounts, which will be used to run the various SQL Server services. On the Collation tab, we are going to choose the collation setting which will be used by SQL Server. Please find both the screenshots mentioned below. Click on Next to continue.
17. The Database Engine Configuration page consists of three tabs; Account Provisioning, Data Directories and FILESTREAM. The Account Provisioning tab is used to determine the Authentication Mode for the SQL Server. Also we can add a group/user to become a part of SQL Server Administrators. The Data Directories tab is used to specify the path for the root directory along with the path for System databases, User databases, TempDB and Backup locations. FILESTREAM is a new feature available with SQL Server 2008 and will not be part of this post. We will configure FILESTREAM on a later post. To continue further, we are going to add the current login account to the SQL Server Administrators group. Click on Next to continue further.
18. The Error Reporting page ask you whether or not you want to share the error messages with Microsoft. You can choose this option based on your requirement.
19. By executing certain rules, the setup will detect whether the installation process will be blocked due to some reasons. Click on Next to continue.
20. The SQL server 2008 R2 setup will prepare a list of selected features which are going to install. Click on the Install button to start the installation of the SQL Server.
21. Once you clicked on Install, you will get the following screen. It will take some times to complete the SQL Server 2008 R2 installation process.
22. Once the installation is completed, we will get the following screen: Click on Close to complete the installation process.
Thus, we have successfully installed SQL Server 2008 R2 on the test environment.