Unfortunately, failed while trying to install Microsoft SQL Server v2005 on a MS Windows 7.
Got the warning pasted below, but chose to ignore it.
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
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.
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.
Add Internet Information Server
Accessed Control Panel \ Programs \ “Programs and Features” \ “Turn Windows Features On and Off”:
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
Please be sure to indicate that you want “Client Components“.
Choose “Run Program” button…
Completing Microsoft SQL Server 2005 Setup
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.
There are no traffic jams along the extra mile
It’s okay to have personal ambitions, but you have to take someone with you