Once you have IIS installed, re-run the Microsoft SQL Server installation Wizard. If you get the IIS warning, click next to continue then cancel out of the SQL setup and follow this guide to install IIS 7 in Windows Server 2008 For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again.

Without IIS, some SQL Server features will not be available for installation.

IIS is required by some SQL Server features. Microsoft Internet Information Services (IIS) is either not installed or is disabled. If you get a warning that IIS is not installed, ignore it for now as we will install it later. In the Welcome to the Microsoft SQL Server installation Wizard, click next Next you'll see a window system configuration check, but behind it is the actual SQL Server Setup Wizard, You'll be informed that setup has to install some prerequisites (Microsoft SQL Native Client and Microsoft SQL Server 2005 Setup Support Files) When the splash screen appears, choose the Server components, tools, Books Online, and Samples choice under the Install menu.ĭepening on your version of Windows Server, you may get a warning about known combatibility issues as below, but that's safe to ignore as we will be upgrading this install to Service Pack 2 as part of the process.Ĭlick on Run program and accept the licensing aggreement. Insert the Microsoft SQL Server 2005 Standard Edition DVD (or mount the ISO available on MSDN called en_sql_2005_std_x86_dvd.iso) using Daemon tools or similar. The screenshots for this guide were taken from a Windows Server 2008 which had been preinstalled and configured with AD, DHCP, DNS, WDS This guides main purpose is to help you install SQL 2005 SP2 standard edition on Windows Server 2008 (while we wait for SQL 2008).

Install sql server 2008 r2 64 bit