Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Microsoft SQL 2005 installation Errors in Win 7 x32

17 Mar 2010   #1

Windows 7 x32
Microsoft SQL 2005 installation Errors in Win 7 x32

[This post has dual intent. (i) to solve my problem; (ii) to provide a complete solution to other users with common issues they will face in the installation of SQL 2005 Server on Windows 7 x32.]

I am running a Windows 7 (32 bit) OS, and I am attempting to install Microsoft SQL 2005. I am encountering several problems, namely that the Management Studio doesn't install.

Problem I: IIS Errors. Resolved.
When I first began the installation, I enountered an error informing me that the IIS feature was either not installed or not enabled. I went into the Control Panel/Turn on off Windows Features, then under IIS I have enabled the following options:

Internet Information Services
--FTP Server
----FTP Extensibility
----FTP Service
Web Management Tools
--II6 Management Compatibility
----II6 WMI Compatibility
----II6 Metabase and IIS Configuration Compatibility
World Wide Web Service
--Application Development Features
----.NET Extensibility
----ISAPI Extensions
----ISAPI Filters
--Common HTTP Features
----Default Document
----Directory Browsing
----HTTP Redirection
----Static Content
--Request Filtering
--Windows Authentication
Internet Information Services Hostable Web Core

I have IIS v.6 installed, and while I'm aware that v.7 is available, I have not upgraded. (At least one forum recommended I retain v.6).

Problem II: Management Studio Doesn't Install.

First Install.
I previously had the free version of Microsoft SQL Server 2005 (Express). Then, I uninstalled the Express version using the Control Panel/Remove Program feature to uninstall. My first attempt to install SQL Server 2005 failed because of the IIS error, or so I thought. The install didn't even ask me to insert CD II. So, I uninstalled SQL using the same method. I did some research on the IIS issue, made the changes noted above, and I thought all my problems were resolved.

Second Install.
I again attempted an installation, I didn't receive the IIS error, and it again didn't install the Management Studio. And, it still didn't request that I insert CD II. I uninstalled. At this point, I realize I'm probably making an ugly mess out my registry and have scattered fragments of files all over the place.

Third Install.
I read some forum postings again, and I realized that I missed installing the Service Pack 3 (SP3). I installed the Native Client first. Then, I installed SP3. Then, I began my installation of the SQL Server 2005. I read on another forum not to install the Reporting Services, because it would cause other errors. No IIS error, and the install DID request CD II. (I thought, ALAS! It will surely install now....) The install went relatively fine, but I received two errors and Management Studio did not install.

The two services that "failed" during install were:
(1) Visual Studio integrated Development
(2) Workstation Components, Books Online

Proposed Solution to Problem B
I am really tired of installing, unintstalling and reinstalling. At this point I am considering uninstalling and then running a new install from the command prompt, because there were previous versions and may be some inner-computing confusion. I am advised (via another Forum) to install using the following line:

E:\>Setup.exe SKUUPGRADE=1

Please let me know if I'm on the right track, or if I'm missing something huge.

Please do not ask me if my computer is plugged in. It is. ... anything else, I may have missed, though. :)

Thank you.

My System SpecsSystem Spec
09 Jul 2010   #2

Windows 7 Ultimate

Same problem here.I tried installing SQL Server 2005 Developer edition,but installation fails half way(it says something like "failed to start SQL database services automatically").I click cancel,it continuos to install.At the end,database engine,reporting and integration services fail to install. The Management studio is missing,all i see is the Visual Studio.
Tried uninstalling/reinstalling(using "arpwrapper.exe /remove" in cmd prompt) several times,still nothing....

When i was searching on google,i came across website that said something about "cpu prefetch missing" being an issue. Another thing is that your CPU is the new Intel i3,mine is i7,is it something to do with new cpu's.?
My System SpecsSystem Spec

 Microsoft SQL 2005 installation Errors in Win 7 x32

Thread Tools

Similar help and support threads
Thread Forum
Microsoft SQL Server 2005 End of Life
As this is no longer supported by Microsoft and I have no intention of upgrading to Windows 10, can I delete this from my computer? I'm not even sure what this does or if I need it. Secunia reports that hackers are already exploiting this. Any help at all will be sincerely appreciated.
Windows Updates & Activation
Cannot install Microsoft SQL Server 2005
Hi, I'm trying to install Microsoft SQL Server 2005 from CD onto my Windows 7 64 bit OS. I get as far as entering the second CD and receive three errors in the order: "Error 1311", "Error 1935" and an unlabelled error. (Please see attached for details of the errors). Any help and...
sql server 2005 installation fails on windows 7
Hi, sql server installation fails on windows 7. Any ideas to resolve this problem.
How do i remove Microsoft Visuals 2005 C++?
As the title says, i can't delete Microsoft Visuals 2005 C++ Whenever i try it says that it cannot find the specified path where it should have been installed. Also a update for Microsft Visuals is popping up all the time, i don't really know if it's relevant. But the exact update is :...
iI Can't Uninstall Microsoft Visual C++ 2005 Redistrib
hello friends i am enjoying the windows 7 and everything but, i have 1 problem my anti-Virus which is AVG needs to update and for it to do that the manager on their forum told me i would have to uninstall and reinstall Microsoft Visual C++ Redistributable. the problem is that whenever i attempt...

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 06:01.
Twitter Facebook Google+