Installing SQL Server 2008 R2 on a Stand-alone Server


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. image 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.

  1. After log on to the server, open Computer Management (Start –> Administrative Tools –> Computer Management).
  2. Expand System Tools, and click on Local Users and Groups. Expand Local Users and Groups, and click on Users.
  3. 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:

image

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.

image

 

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.

image

 

image

 

 

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.

 

image

 

 

 

 

 

 

 

4. The above screen will opened the SQL Server 2008 R2 Installation Center.

image

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.

image

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.

image

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.

Specify the addition

8. Accept the Licensing Agreement to continue further.

image

9. Click on Install to start the installation of the Support Files.

image

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.

image

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.

image

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.

image

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.

image

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.

image

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.

image

16. The Server Configuration Page consists of two tabs; Service Accounts Page and Collation Page.

image

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.

image image

 

 

 

 

 

 

 

 

 

 

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.

image

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.

image

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.

image

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.

image

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.

image

22. Once the installation is completed, we will get the following screen: Click on Close to complete the installation process.

image

Thus, we have successfully installed SQL Server 2008 R2 on the test environment.

About these ads

About Sudeepta Ganguly

A SQL Server User... Still Learning
This entry was posted in SQL Server Installation. Bookmark the permalink.

4 Responses to Installing SQL Server 2008 R2 on a Stand-alone Server

  1. joel embry says:

    You don’t mention what permissions to give the new user.

    My installation has two network service entries, one is “NETWORK SERVICE” and the other is “networkservice”. What is the difference??

  2. Hello Joel,
    Which user account are you talking about? If you are talking about the user rights for the accounts used to run SQL Server Services (Database Engine Service & SQL Agent Service), I didn’t give any additional permissions. These are normal domain accounts, without any additional rights.

    Apart from the above, I have added the user account (which was used for running the setup) to the member of SQL Server Administrator Group. Let me know, if it answer your query.

  3. Wilfredo de Jesus-Rivera says:

    Thanks to your above post, I completed installation of SQL Server 2008 R2 on my stand alone server with Windows Server 2008 standard 32-BIT after two weeks of trials with other sources. At present I have to train myself on creating reports in the Business Intelligence Development Studio (BIDS) for a new opening job.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s