Wednesday, January 19, 2011

SQL Server 2005 Installation Error: "Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS)"

Summary.txt tells you: "Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS)"

This error will occur with SQL Server 2005 on some 64-bit versions of Windows.

How to resolve it:

Go to Control Panel>Programs (or Programs and Features)>Turn Windows features on or off

Select the following items circled in red. Other items will auto-select as a result:


Click OK and wait for installation to complete.

Go to an elevated command prompt and do the following commands in order:

cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1

and then…

%SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i

Now you can reinstall SQL Server 2005 and you should not receive the ASP.NET error anymore.

EDIT 5/22/17: SQL Server 2005 Extended Support ended April 12, 2016. That means no more security patches. You really should not be running this software any longer, and should upgrade to a newer version

7 comments:

didinko said...

this really helped me out -very useful :) now I can install sql 2005 on my windows 7 machine. Thanks a lot

Andrew James said...

What if cmd.exe comes up with

Permission denied
ErrNumber: 70 (0x46)
Error trying to get to the object: W3SVC/AppPools

David T. said...

Ensure you are logged on to an administrative account, then right click setup.exe and choose Run As Administrator.

Windows Techupdates said...

The solution of this issue is to allow 32bit ASP.net on that machine. please follow the under given link for complete process.
http://www.windowstechupdates.com/asp-net-version-registration-requirement-during-installation/

Afifah Harmayanti said...

What if "Input Error: Can not find script file "C:/inetpub/adminscripts/adsutil.vbs"" showed up? Am I missing something? Help please!

David T. said...

Afifah,

Make sure you install the Windows components as shown in the screenshot I posted. Specifically check these individual components:

Under Internet Information Services>Web Management Tools>IIS 6 Management Capability:
IIS 6 Management Console
IIS 6 Scripting Tools
IIS 6 WMI Compatibility
IIS Metabase and IIS configuration compatibility

Under Internet Information Services>World Wide Web Services>Application Development Features
ASP.NET
(any and all versions listed)

Abdullah Dahlan said...

trims for trik :)