Can we install SQL Server 2008 R2 on Windows 10?

SQL Server 2008 R2 is not supported on Windows 10 or Windows Server 2016.

How do I start SQL Server 2008 R2 after installing?

SQL Server 2008 R2 Setup

Double-click on the application to launch the installer:
Select the New installation or add new features to an existing installation link – the License Terms screen will display:
Tick the I accept the license terms box and click the Next button – the Support Files will be installed:

How to use Microsoft SQL Server 2008 R2 best practices analyzer (BPA)?

Once you have installed Microsoft SQL Server 2008 R2 Best Practices Analyzer (BPA). You can use the tool by clicking Start | Programs | Microsoft Baseline Configuration Analyzer 2.0. In Microsoft Baseline Configuration Analyzer 2.0, Select a Product as SQL Server 2008 R2 BPA as shown in the below snippet.

What is the SQL Server 2008 R2 BPA drop-down box?

This is a drop-down box that allows you to select the SQL Server 2008 R2 BPA to run. As I mentioned earlier, the Microsoft Baseline Configuration Analyzer is a wrapper program, and is where the Microsoft SQL Server 2008 R2 Best Practices Analyzer runs from.

How to connect SQL Server 2008 R2 BPA to another computer?

In Microsoft Baseline Configuration Analyzer 2.0, Select a Product as SQL Server 2008 R2 BPA as shown in the below snippet. Next, click Connect to Another Computer and choose Local Computer and then click OK to close Connect to Another Computer window.

How do I use the Microsoft baseline configuration analyzer?

As I mentioned earlier, the Microsoft Baseline Configuration Analyzer is a wrapper program, and is where the Microsoft SQL Server 2008 R2 Best Practices Analyzer runs from. If you want to scan a remote SQL Server instance, then click the “Connect to Another Computer” link, select the instance to scan, then click on the “Start Scan” link.