Installing SQL Server 2005 Express in Windows Vista x64

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.


Posted

in

by

Tags:

Comments

21 responses to “Installing SQL Server 2005 Express in Windows Vista x64”

  1. Steven H Avatar
    Steven H

    Thanks allot buddy!

  2. kinjal Avatar
    kinjal

    it’s really useful….thanks a lot

  3. zahi Avatar
    zahi

    thanks!
    straight to the point!

  4. Anshul Avatar
    Anshul

    Thnx a lot, you’ve saved my lot of time

  5. Steven Avatar
    Steven

    Thanks alot. finally someone explains it right. thumbs up

  6. FEOL Avatar
    FEOL

    Hi. This is my problem: I’ve installed SQL 2005 Express in Vista Home Premium x64, also installed SP2, but I have no instances of a server. When I look into the Configuration Manager – SQL 2005 Services I get “There is no items to show in this view”. What did I miss? What can I do?
    I’ve run the command and I get “Input Error: Can not find script file “C:\Users\Fernando\inetpubAdminScriptsadsu
    til.vbs”.
    I’ve also install all IIS items.

    Thanks in advance.
    Regards from México.

    FEOL

  7. mg Avatar

    Hi FEOL. The correct path for the script is:
    %SystemDrive%\inetpub\AdminScripts\adsutil.vbs (i have fixed the article already).

    About you the missing services in the Configuration Manager: Run the adsutil.vbs first, as stated in the article, then install (or reinstall) SQL 2005 Express – in your case, the SQL Server service is probably not installed.

    MG

  8. FEOL Avatar
    FEOL

    Thanks,MG. I’ll try that and let you know.

  9. Rob Avatar
    Rob

    For some reason my Vista Home Premium x64 does not have adsutil.vbs on it. Any ideas on how to get this script or a work around?

    Rob

  10. FEOL Avatar
    FEOL

    No, MG, it doesn’t work. I still have the “SQL Server Edition Operating System…” and the “IIS Feature Requirement” errors. Once, one of my Unix instructor said “The more I know Microsoft the more I love Unix” I guess he was right. Maybe I have to downgrade to XP. Any way, thanks a lot for your help.

  11. FEOL Avatar
    FEOL

    One more question, please: Should I install framework 2 for x64 and the SP1?

  12. User Avatar
    User

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

  13. Reddy Avatar

    Still My Problem is not Solved.
    I Installed Every thing Mentioned Above(IIS and Config the Script).

    But Still Showing the
    IIS Feature Requirement” and “ASP.Net Version Registration Requirement” same messages.

    Pls Suggest me.

    Reddy

  14. AndrewBoldman Avatar

    Hi, good post. I have been woondering about this issue,so thanks for posting. I’ll definitely be coming back to your site.

  15. pater Avatar
    pater

    Cheers – had troubles trying to install the management engine, and thought that VS2005 had installed the 32bit version. After reinstalling several times, I found that you have to install the management engine from an elevated command prompt. Microsoft don’t seem to have mentioned the fact that the engine is only 32bit. Have to wonder why they’ve even made an x64 install. I wish they would fix something for x64 to check the prog files (x86), as restoreing databases that were on a 32bit machine try to restore to the wrong place.

  16. asan Avatar
    asan

    TITLE: Microsoft SQL Server Setup
    ——————————

    None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel.

    For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28108

    ——————————
    BUTTONS:

    OK
    ——————————
    failure . this is trouble

  17. Seejee Wazir Avatar
    Seejee Wazir

    Hi, thanks for this help. it save me a lot. I was facing one more issue to run command on vista 64 bit, after running this command:
    cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

    command prompt shown me error:
    Permission denied
    ErrNumber: 70 (0x46)
    Error Trying To Get the Object: w3svc/AppPools

    STEP 1:
    If anyone one facing this issue then don’t worry just open control panel -> user accounts -> Turn user account control on or off and just off (disable by removing tick on “UAC to help protect your computer” and then OK.
    STEP 2:
    Run again on command prompt: cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
    STEP 3:
    Reboot
    Finally:
    Start installation of MS SQL SERVER and Enjoy.

    Seejee Wazir

  18. Lucias Avatar
    Lucias

    awesome dude
    i looking for this trouble shooting along time

  19. Mengkong Avatar
    Mengkong

    After i install completed, i can not log in SQL Server 2005. what wrong with it?
    Please help me!

  20. Mengkong2 Avatar
    Mengkong2

    how to remove all component of sql server 2005 in my computer?
    i had removed it with ‘Program and Feature’ and after that i install it a gain but
    it said ‘None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install’ so, how could i do?

Leave a Reply to AndrewBoldmanCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from try {} except

Subscribe now to keep reading and get access to the full archive.

Continue reading