SQL Server 2005 Install failed on MS Windows 7

Background

Unfortunately, failed while trying to install Microsoft SQL Server v2005 on a MS Windows 7.

Warning

Got the warning pasted below, but chose to ignore it.

Textual

To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 from the command prompt and include SKUUPGRADE=1 parameter

Image

SKUUpgrade

Diagnosis

Reviewed “C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap” and found the error message posted below.

Please keep in mind that 90 is version specific. 80 is SQL Server 2000, 90 is SQL Server 2005, 100 is SQL Server 2008, 110 is SQL Server 2012, 120 is SQL Server 2014.

 

Error Message


Microsoft SQL Server 2005 9.00.5000.00 
============================== 
OS Version      : Professional Service Pack 1 (Build 7601) 
Time            : Thu Aug 27 10:28:19 2015 
 
OAKWSHP001 : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features.  Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
OAKWSHP001 : Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS).
OAKWSHP001 : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
OAKWSHP001 : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. 


Resolution

Add Internet Information Server

Accessed Control Panel \ Programs \ “Programs and Features” \ “Turn Windows Features On and Off”:

AddIIS

Add Client Components

The error message says that we can not initiate setup via Control Panel, but through command line.

And, so here we go


set appPath=D:\Downloads\Microsoft\SQLServer\v2005\x64\CD1
Start /wait %appPath%\setup.exe SKUUPGRADE=1  UPGRADE=SQL_Engine INSTANCENAME=V2005 ADDLOCAL=Client_Components

Steps

Feature Selection

Please be sure to indicate that you want “Client Components“.

FeatureSelection

 

Setup Progress

SetupProgress

 

Program Compatibility

Choose “Run Program” button…

ProgramCompatibilityAssistant

 

Completing Microsoft SQL Server 2005 Setup

CompletingSetup

 

 

Summary

Again, not paying attention to Warnings, “you must run SQL Server 2005 from the command prompt“, cost me time.

In retrospect, we chose a full install without paying attention that we did not have IIS installed.  In SQL Server v2005, Reporting Services (RS) needs IIS.

Because of the failure that we experienced while trying to install RS, Client Components was not installed.

Later install of Client Components can not be initiated via Control Panel, but through Command Line.

 

Quotes

Roger Staubach

There are no traffic jams along the extra mile

It’s okay to have personal ambitions, but you have to take someone with you

More

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s