Step 7: -
Once setup support files are installed, SQL Server setup will now look for support rules. We need to fix the ones, which failed before moving forward. We may ignore warning status for Windows Firewall. These settings we can do even after installing SQL Server. (Will be discussing more on Windows Firewall configuration on Windows 2008 R2 in future articles)
You may get warning for other rules also like Windows PowerShell in below slide. Use below link to install Windows PowerShell. Use below link for Installing PowerShell
Step 8: -
Here select “SQL Server feature installation” as we have to install SQL Server database Engine, SSIS, SSAS, SSRS and all the shared components.
Step 9: -
Click on “Select All” in-order to select all the database and shared components.
Here, we have to also provide path where we want the SQL Server shared features to install.
Step 10: -
Setup will check for installation rules and will show if any operation failed. If all operations completed without failures, move to next step.
Step 11: -
We have to select, what type of instance we want to install (default or named instance), provide path where binaries are to be copied.
Installer will also show, if any SQL Server instance already exists on this server.
Step 12: -
Installer will check for the available disk space and the required space for the installation to complete successfully. If everything is green, proceed to next step.
Step 13: -
Provide the account names against which the respective services should run. As a best practice we select all the services to run automatically, until or unless there is any specific reason as not to do so.
Step 14: -
Change collation setting if required. Installer will generally take the OS settings.
Step 15: -
Select the mixed mode authentication and provide ‘sa’ password. We can also add additional users as administrators at this point.