SQL Server 2005 Setup errors in VistaWhen you try to install MSSQL Server 2005 Express with Advanced Services in Windows Vista x64, with IIS7 already installed, you will get two warning messages: “IIS Feature Requirement” and “ASP.Net Version Registration Requirement”. This should not happen if you try to install SQL Server 2005 Express alone, as it doesnt need IIS or ASP.net.

To fix the first problem (IIS Feature Requirement) go to “Control panel” -> “Programs and Features” and click in “Turn Windows features on or off”.

Turning Vista feature on or off

Enable the following options:

  • World Wide Web Services
    • Common HTTP Features
      • Static Content
      • Default Document
      • HTTP Redirection
      • Directory Browsing
    • Application Development
      • ASP.Net
      • ISAPI Extension
      • ISAPI Filters
    • Security
      • Windows Authentication
  • Web Management Tools
    • IIS 6 Management Compatbility
      • IIS 6 Scripting Tools
      • IIS 6 WMI Compatibility
      • IIS Metabase and IIS 6 configuration compatibility

After this, click ‘OK’ and watch your hair grow (yes, its slow) as the features install. This warning basically happens because MSSQL 2k5, more specifically the Reporting Services part, was design to use IIS6, not IIS7, and v7 doesnt have all the v6 compatibility options enabled by default.

The second warning

The “ASP.Net Version Registration Requirement” warning is a different beast. SQL Express 2005 only runs in 32-bit mode, even if you have Vista 64 (or XP64). The same is true for MS Reporting Services 2005 included in this ‘Advanced Services’ edition – the problem is that only ASP.net x64 is installed, so you have basically three options: 1 – Dont install Reporting Services; 2- Install asp.net x32 (tricky) or 3- Enable the “32bit app on Win64” option for IIS – how? Open a command prompt and run the following command:

cscript %SystemDrive%\\inetpub\\AdminScripts\\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

After this just reboot and both warnings will be gone.

Pin It on Pinterest

Share This