visit www.iGnani.com
Click here for the Video Tutorial of this article.
The steps below will show with some pictures about installing SQL Server 2008 R2
- In case you have an .iso file, you can either burn the file into a DVD or use any tool that can extract the content from the iso file onto your hard disk. Either way, the steps do not change. You can also use any virtual CD/DVD tools that can mount the .iso file and create a virtual drive.
- Find the installable files where ever they are, either on the DVD or network folder or on a folder on your machine or in a virtual drive. From the root folder, double-click Setup.exe. To install from a network share, locate the root folder on the share, and then double-click Setup.exe.
- This will launch the package and you will then see the contents extracted to a temporary location as shown below
- First, the setup will check for the prerequisites to be installed. If the setup does not find them it will prompt you to install.
SQL Server 2008 R2 requires Windows Installer 4.5 and .Net Framework 3.5 SP1 to be installed. Click OK button to install .Net Framework.
If the .NET Framework 3.5 SP1 installation dialog box appears, select the check box to accept the .NET Framework 3.5 SP1 License Agreement.
Click Next. When installation of .NET Framework 3.5 SP1 is complete, click Finish.
Windows Installer 4.5 is also required, and might be installed by the Installation Wizard. If you are prompted to restart your computer, restart it. - When the prerequisites are installed, the Installation Wizard runs the SQL Server Installation Center.
To create a new installation of SQL Server, click New Installation or Add Features to an Existing Installation.
In this article we will look at installing a New installation of SQL Server. Hence select the "New Installation" option. - This is the window that you will see next. Click on the Installation option
This screen displays the various types of installation available. Select the first option available "New installation or add features to an existing installation".
This will take you to the Setup Support Rules. Setup will run the test to see all the rules pass through. Though its not necessary that all have to pass, sometimes some does not pass and show up a warning. But the Next button is available only if all check results have Passed or ends up with a warning. If there are any failed rules, then you will have to fix them before the installation can proceed.
Click OK button to continue. Now this will show the following page - Next is the Product Key page as shown below.
On the Product Key page, select an option button to indicate whether you are installing a free edition of SQL Server, or a production version of the product that has a PID key. If you would like to get more details on Editions and components, check out “Editions and Components of SQL Server 2008 R2.”
For this article, let us select “Enterprise Evaluation Edition”.Next we will be taken to the License Terms page as shown above. Read the license agreement. If you agree with it, check the "I accept the license terms" check box, and then click the Next button. However, if you don’t agree with the license agreement, you have only one option that is to cancel and stop the installation, since the next button only appears when you accept the license.
Other than the License check box, there is also another check box which is optional. By clicking it, you are authorizing the installer to send feature usage data to Microsoft. This is to help improve SQL Server, by sending feature usage and related reports to Microsoft. The link below the check box will give you complete details, in case you want to know what all will be sent and also about the privacy statement.
- Once you click on “Next” button after accepting the license agreement, you will be taken to the next page where the System Configuration Checker verifies the system state of your computer before Setup continues. One of the things to resolve here is the Windows Firewall Warning issue, which I will take up in the next article.
- The next page is the Setup Role page, where in you will be provided with three options:
- Choose "SQL Server feature installation" to install SQL Server Database Engine Service, Analysis Services, Reporting Services, Integration Services and other features.
- Choose "Analysis Services with SharePoint Integration" if you want to install Analysis Services as a shared service in a new or existing farm and to add PowerPivot for SharePoint.
- Choose "All Features With Defaults" to install all features of SQL Server in one box.
- On the Feature Selection page, select the components that you need for your installation. A description for each component group appears in the right pane after you select the feature name. You can select any combination of check boxes. You can also click on the “Select All” button below to select all the features and “Unselect All” to clear all the selections that you have made.
If you would like to get more details on this, check out “Editions and Components of SQL Server 2008 R2”.
All the shared features or shared components will be by default installed in “C:\Program Files\Microsoft SQL Server\100\”. However, you can also specify a custom directory for shared components by using the field at the bottom of the Feature Selection page.
To change the installation path for shared components, either update the path in the field at the bottom of the dialog box, or click Browse to move to an installation directory. The default installation path is C:\Program Files\Microsoft SQL Server\
Once you click on the next button, you will be taken to the Installation Rules Screen. The setup will now run another set of checks which to validate whether the selected features can be installed on the server. This is to make sure that the installation process is not blocked in-between. Once the checks are done, we will get the following screen.
Click next to continue. - Now you will be taken to the Instance Configuration page.
On the Instance Configuration page, specify whether to install a default instance or a named instance.
Instance ID — By default, the instance name is used as the Instance ID. This is used to identify installation directories and registry keys for your instance of SQL Server. This is the case for default instances and named instances. For a default instance, the instance name and instance ID would be MSSQLSERVER. To use a non-default instance ID, select the Instance ID check box and provide a value.
If you would like to get more details on this, check out “Instance Configuration”. Click Next to continue.
Note: Typical stand-alone instances of SQL Server 2008 R2, whether default or named instances, do not use a non-default value for the Instance ID check box.
Instance root directory — By default, the instance root directory is C:\Program Files\Microsoft SQL Server\. To specify a non-default root directory, use the field provided, or click Browse to locate an installation folder.
All SQL Server service packs and upgrades will apply to every component of an instance of SQL Server.
The Installed instances grid shows all the instances of SQL Server that are on the computer where Setup is running. If a default instance is already installed on the computer, you must install a named instance of SQL Server 2008 R2, by selecting the Named Instance option and by providing a name.
The above two screen show the how it appears when we select the Default Instance (in the first screen shot) and in case if you already have a default instance, how it will appear when we select the “Named instance” and enter the name as “Demo” in the text box. If a default instance is already installed, you can also see the error message that will appear (check the messages in yellow background just above the Next button at the bottom of the page in the second screen shot.)
For this article, we shall go ahead with a default instance option. Click Next.
- The next page that you will be presented with is the Disk Space Requirements page.
Disk Space Requirements page calculates the required disk space for the features that you specify. Then it compares the required space to the available disk space.
If you would like to get more details on this, check out “Disk Space Requirements”. - The rest of this topic behavior depends on the features that you have specified for your installation. You might not see all the pages, depending on your selections. For this article, I have selected to install all the features. (See step 10 above).
- When you click on the Next button you will see the Server Configuration Page.
On the Server Configuration — Service Accounts page, specify login accounts for SQL Server services. The actual services that are configured on this page depend on the features that you selected to install. You can assign the same login account to all SQL Server services, or you can configure each service account individually. You can also specify whether services start automatically, are started manually, or are disabled.
Microsoft recommends that you configure service accounts individually to provide least privileges for each service, where SQL Server services are granted the minimum permissions they have to have to complete their tasks. If you would like to get more details on this, check out “Server Configuration - Service Accounts and Setting Up Windows Service Accounts”.
To specify the same logon account for all service accounts in this instance of SQL Server, provide credentials in the fields at the bottom of the page.
Security Note: Do not use a blank password. Use a strong password.
When you are finished specifying login information for SQL Server services, click Next.
- When you click on the Next button you will see the Database Engine Configuration page.
In the Database Engine Configuration - Account Provisioning Tab, you can configure the following:-
Authentication Mode — Select Windows Authentication or Mixed Mode Authentication for your instance of SQL Server. If you select Mixed Mode Authentication, you must provide a strong password for the built-in SQL Server system administrator account. Mixed Mode authentication enables both Windows as well as SQL Server based authentication system.
After a device establishes a successful connection to SQL Server, the security mechanism is the same for both Windows Authentication and Mixed Mode. If you would like to get more details on this, check out “Database Engine Configuration - Account Provisioning”.
-
SQL Server Administrators — You must specify at least one system administrator for the instance of SQL Server.
Click “Add Current User” button to add the account under which SQL Server Setup is running (in other words the currently logged on user).
To add or remove accounts from the list of system administrators, click Add or Remove, and then edit the list of users, groups, or computers that will have administrator privileges for the instance of SQL Server.
If you would like to get more details on this, check out “Database Engine Configuration - Account Provisioning”.
When you are finished editing the list, click OK. Verify the list of administrators in the configuration dialog box.
Now don’t click on the Next button but click on the “Data Directories” tab.
In the Database Engine Configuration - Data Directories page you can specify non-default installation directories. To install to default directories, leave them unchanged and continue.
If you would like to get more details on this, check out “Database Engine Configuration - Data Directories”.
There is also another tab named “FILESTREAM” to enable FILESTREAM for your instance of SQL Server. We have left it at default mode and that should be sufficient.
If you would like to get more details on this, check out “Database Engine Configuration – Filestream”.
Click Next to continue.
-
- Check out this step only if you have selected the “Analysis Services” in the Step 10 above. This page does not appear if you have not selected to install “Analysis Services”
In the Analysis Services Configuration — Account Provisioning page you can specify users or accounts that will have administrator permissions for Analysis Services.
You must specify at least one system administrator for Analysis Services. To add the account under which SQL Server Setup is running, click Add Current User. To add or remove accounts from the list of system administrators, click Add or Remove, and then edit the list of users, groups, or computers that will have administrator privileges for Analysis Services.
If you would like to get more details on this, check out “Analysis Services Configuration - Account Provisioning”.
When you are finished editing the list, click OK. Verify the list of administrators in the configuration dialog box.
Next move onto the Analysis Services Configuration — Data Directories page to specify non-default installation directories for default Analysis Services. To install to default directories, leave them unchanged and continue.
If you would like to get more details on this, check out “Analysis Services Configuration - Data Directories”.
Click Next to continue.
- Check out this step only if you have selected the “Reporting Services” in the Step 10 above. This page does not appear if you have not selected to install “Reporting Services”
In the Reporting Services Configuration page you can specify the type of Reporting Services installation to be installed. We have the following options and can select one among them:
-
Native mode default configuration.
-
SharePoint integrated mode default configuration
-
Un-configured Reporting Services installation
Though some of the information for each of these options is provided in the Reporting Services Configuration page, If you would like to get more details on Reporting Services configuration modes, check out “Report Server Installation Options”.
Click Next to continue.
-
- You will not be shown the “Error Reporting” page.
Here you can specify the information that you want to send to Microsoft to help improve SQL Server. The links on the page provide you more information on the Privacy Statement and also on Microsoft update and Automatic Update. If you would like to get more details on this, check out “Error Reporting”.
- Click next and you will be shown the “Installation Configuration Page”.
The System Configuration Checker will run another set of rules to validate the computer configuration based on the SQL Server features that you have selected/entered.
-
Click next and you will be shown the page “Ready to Install”, which displays a tree view with all the installation options that were specified during Setup. To continue, click Install.
-
Now you are done with answering the questions for the installer. Relax while the installation continues. You will be displayed the “Installation Progress” page provides status so that you can view installation progress as Setup installs your requirements.
-
Once the installation completes, you will see the “Complete page” which provides a link to the summary log file for the installation and other important notes.
To complete the SQL Server installation process, click Close.
Note:
- If the system asks you to restart the computer, do so now, it is important for the Setup to finish properly.
- Read the message from the Installation Wizard after the setup finishes. If you would like to get more details on this, check out “How to: View and Read SQL Server Setup Log Files”.
Hope I have provided the information sufficiently for you to do it on your own.
Click here for the Video Tutorial of this article.
visit www.iGnani.com
No comments:
Post a Comment