IS install after SP1 fails

Subject says it all; I need to install IS, but the installer says v.2047 of IS is already installed; it it NOT installed. When I go to add/remove programs, under the Sql Server 2005, it allows me to try to install IS, but that also fails, as no components are found for installation. This is SS dev edition, W2003.

I can uninstall SS2005 and start over, but is there a quicker way to fix this?

I don't think this is a known issue. If time to solution is your top priority, probably uninstall/reinstall is the way to go. Otherwise, post links to both the RTM Setup logfiles (%Program Files%\Microsoft SQL Server\90\Setup Bootstrap\Files) and the SP1 Setup logfiles (%Windir%\Hotfix) and we'll see if we can't help you figure out what's going on here.

Paul

|||

I'm kind of curious; I'm not sure which log files you need (and they are too large to post?). The hotfix.log is from April (sp1), and here is a snip:

04/25/2006 08:10:44.168 Found Report Server 2005 product definition
04/25/2006 08:10:45.371 Found DTS 2005 product definition
04/25/2006 08:10:46.871 Determining QFE level for product instance
04/25/2006 08:10:46.917 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\DTS\\Binn\DTSPipeline.dll
04/25/2006 08:10:46.933 Found following QFE level for product instance : 1399
04/25/2006 08:10:46.933 Determining GDR branching Hotfix for product instance
04/25/2006 08:10:46.949 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\DTS\\Binn\DTSPipeline.dll
04/25/2006 08:10:46.964 No GDR branch Hotfix found for product instance
04/25/2006 08:10:46.996 Successfully opened registry key: SOFTWARE\Microsoft\Windows\CurrentVersion
04/25/2006 08:10:47.011 Successfully read registry key: CommonFilesDir, string value = C:\Program Files\Common Files
04/25/2006 08:10:47.027 Successfully opened registry key: SOFTWARE\Microsoft\Windows\CurrentVersion
04/25/2006 08:10:47.042 Successfully read registry key: ProgramFilesDir, string value = C:\Program Files
04/25/2006 08:10:47.105 Attempting to check IA 64 platform
04/25/2006 08:10:47.121 Result of IA64 check: 0
04/25/2006 08:10:47.136 Last error: 0

And there is a good logn sqlsetyp0006_qsqlca1_support.log, note the line that says:

MSI (s) (0C:60) [07:14:04:228]: File: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Microsoft.SqlServer.DTS.UpgradeAdvisor.dll; Won't Overwrite; Won't patch; Existing file is of an equal version

logging stopped: 6/16/2006 7:14:06 ===

|||

Yes, the logs will be too big to post here. Instead, you'll need to post a link to the files.

I think this is your scenario; please correct me if I'm wrong:

1. You installed RTM, but didn't include IS in the install. [Log files for the original install will be in the %Program Files%\Microsoft SQL Server\... location]

2. You installed SP1 [Log files will be in the %Windir%\Hotfix location]

3. You attempted to add IS to the product by going to Add/Remove Programs (ARP) and selecting "Change" for the SQL Server 2005 entry. [Log files will also be in the %Program Files%\Microsoft SQL Server\... location]

Does this make sense?

|||

1. yes

2. yes

3. yes, after install of IS from media failed.

'post a link'....sorry, I don't get how to allow you to securely access an internal server?