Installing SQL 2005 on Windows 2008 R2

As part of a performance test for an application at a client, we needed to setup a temporary server running Windows Server 2008 R2 and SQL Server 2005. When you install SQL 2005, it indicates that IIS must be installed. Back in Windows Server 2003 this was easy because IIS was installed as a single lump. Starting in Windows Server 2008, IIS is installed as multiple role services. This makes it difficult to determine which role services are required.

Here is a list of the IIS 7 role services that must be installed for SQL 2005:

• Common HTTP Features
• Static Content - Common HTTP Features
• Default Document
• HTTP Redirection
• Directory Browsing
• Application Development
• ASP.NET
• ISAPI Extension
• ISAPI Filters
• Security
• Windows Authentication
• Management Tools
• IIS Metabase
• IIS 6 WMI