SQL 2008 Server R2 Installation
An evaluation copy of SQL Server 2008 R2 can be downloaded from here.
Recommendations Before Installing SQL Server 2008 R2
- Use NTFS file system.
- Do no try to install SQL Server 2008 R2 on a compressed drive, because setup will block the installation.
- Do not install SQL Server on a Domain Controller.
- Configure your firewall to allow SQL Server access.
- The user account that is running SQL Server Setup must have administrative privileges on the computer.
- Verify Windows Management Instrumentation service (Control Panel -> Administrative Tools -> Services) is running.
- The computer where you are planning to install should be connected to the Internet.
- Do not install SQL Server 2008 R2 side-by-side with SQL Server 7, because it is not supported.
Software Requirements
- .Net Framework 3.5 SP1 is needed.
- Windows Installer 4.5 or later is required.
- Internet Explorer 6 SP1 is required.
Hardware Requirements
- At least 2.0 GB of available hard disk space
- Supported Operating Systems: Windows Server 2008 ; Windows Server 2003 Service Pack 2; Windows Server 2003 Small Business Server R2; Windows Vista; Windows XP Service Pack 2
- 1024 x 768 video resolution
Installation Instruction
Run SQL Server 2008 R2 setup. First, setup checks to determine software requirements are installed. If not, you will be prompted to install
- Install .Net 3.5 and Windows Installer 4.5
In SQL 2008 R2 Installation > New Installation / Add features to an existing Installation.
The following is a new page on SQL Server setup, its name is Setup Role. Here you have three options:
This page is just for the purpose of reviewing disk usage. Click on the "Next" button to continue setup.
It is recommended to create a local user or domain user account to start SQLServer services, the next page setup will display is all about SQL Server service accounts.
If the computer is not part of a domain, use a local user account without Windows administrator permissions. You can create this account using Control Panel -> User Accounts.
Use a Domain User Account if the service must interact with network services or access domain resources. This account should be pre-created by a domain administration in your environment.
- Choose "SQL Server feature installation" to install SQL Server Database Engine, Analysis Services, Integration Services, Reporting Services.
- Choose "Analysis Services with SharePoint Integration" if you want SQL Server setup to add PowerPivot for SharePoint to a SharePoint farm.
- Choose "All Features With Defaults" to install all features of SQL Server in one box.
The page below belongs to the second set of Setup Support Rules.
It is recommended to create a local user or domain user account to start SQLServer services, the next page setup will display is all about SQL Server service accounts.
If the computer is not part of a domain, use a local user account without Windows administrator permissions. You can create this account using Control Panel -> User Accounts.
Use a Domain User Account if the service must interact with network services or access domain resources. This account should be pre-created by a domain administration in your environment.
On the Database Engine Configuration page, choose the authentication mode to use for your SQL Server installation.
Enter and confirm the password for the (sa) login when you choose Mixed Mode Authentication.
Post a Comment
Thanks for your views.....