In order for you to begin installing SQL Server 2008 on Windows Server 2008 R2, you will need to add required Server Roles and Features.
First, add the .NET Framework v3.5.1 that SQL Server 2008 requires. Go to the Server Manager –> Features and select add features.
Put a check in the .NET Framework 3.5.1. Features.”. That will pop up a new dialog that says that it will also install some additional roles and features, such as the Web Server (IIS). That is fine, since you will need them anyway.
Click “Add Required Role Services”.
Click Next.
Click Next.
Put a check in the Box Common HTTP Features, which will select :
- Static Content
- Default Document
- Directory Browsing
- HTTP Errors
- HTTP Redirection
In the Application Development check the following:
- ASP.NET
- .NET Extensibility
- ISAPI Extensions
- ISAPI Filters
In the Security, check these:
- Basic Authentication (Optional)
- Windows Authentication
- Client Certificate Mapping Authentication (Optional)
- IIS Client Certificate Mapping Authentication (Optional)
- Request Filtering
In the Performance, check these:
- Static Content Compression (Optional)
- Dynamic Content Compression (Optional)
In the Management Tools, check the following:
- IIS Management Console
- IIS 6 Management Compatibility (Optional)
- IIS 6 Metabase Compatibility (Optional)
- IIS 6 WMI Compatibility
- IIS 6 Scripting Tools
- IIS 6 Management Console
Click Next.
Click Install.
When finished
Click Close.
this is good article helped me installing sqlserver
Good Article for newbies
Thanks for these great instructions – very helpful.
I would wish that you also had a miniguide for how to install these features in Powershell. 🙂
otherwise great article.
Straight forward and good steps
Thank you. Thank you. Your guide saved me twice. I am not a SQL guy, and I got a 2008 install dumped in my lap. Your guide made it possible for me to confidently and effectively install the server. Then a few days later I had to do a SQL Express 2008 R2 64 bit install. I have done several of these and they are usually click click click done. This one puked and I could not get through the install successfully. I went back to your guide and did all the pre-reqs you outline, re-tried the install again and it worked!
good work