Installing SQL Server 2005 Express in Windows Vista x64
When 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”.
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
- Common HTTP Features
- Web Management Tools
- IIS 6 Management Compatbility
- IIS 6 Scripting Tools
- IIS 6 WMI Compatibility
- IIS Metabase and IIS 6 configuration compatibility
- IIS 6 Management Compatbility
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%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
After this just reboot and both warnings will be gone.
February 24th, 2008 at 15:47
Thanks allot buddy!
March 30th, 2008 at 08:19
it’s really useful….thanks a lot
June 16th, 2008 at 21:45
thanks!
straight to the point!
August 30th, 2008 at 11:39
Thnx a lot, you’ve saved my lot of time
September 12th, 2008 at 22:32
Thanks alot. finally someone explains it right. thumbs up
September 17th, 2008 at 08:31
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
September 17th, 2008 at 22:50
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
September 18th, 2008 at 06:17
Thanks,MG. I’ll try that and let you know.
September 18th, 2008 at 17:30
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
September 20th, 2008 at 09:06
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.
September 21st, 2008 at 03:38
One more question, please: Should I install framework 2 for x64 and the SP1?
January 18th, 2009 at 16:22
[...] machine to test it…) And I’ll suggest you to read the following blog (Not tested by me yet): http://www.tryexcept.com/articles/20…ows-vista.html — Ekrem