Quick-Start Installation of SQL Server 2008 R2. The SQL Server Installation Wizard is based on Windows Installer.
It provides a single feature tree for installation of the following SQL Server components: Database Engine Analysis Services Reporting Services Integration Services Master Data Services Data Quality Services Management tools Connectivity components. Ports and Protocols used by SQL Server 2008. Enable a network for cluster use: Server Clusters (MSCS) Configure the Windows Firewall to Allow SQL Server Access.
Firewall systems help prevent unauthorized access to computer resources.
If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked. To access an instance of the SQL Server through a firewall, you must configure the firewall on the computer that is running SQL Server to allow access. The firewall is a component of Microsoft Windows. How to Install SQL Server 2008 R2. Run SQL Server 2008 R2 setup.
First, setup checks to determine software requirements are installed. If not, you will be prompted to install. As mentioned above, SQL Server 2008 R2 requires Windows Installer 4.5 and .Net Framework 3.5 SP1 to be installed.