Problems with install of SQL Server 2005 Developer (Evaluation Edition)

  • Installing on Windows XP with Service Pack 3, with or without .net 2 Framework installed from a separate download from Microsoft.

    Got the message 'The specified image file did not contain a resource section'.

    This applies to two separate computers, producing the same error.

    Could anybody please advise how to overcome this ?

    Thanks

  • Try to check if maybe your setup file is not at fault, if the setup fails at initial phase.

    What you don't know won't hurt you but what you know will make you plan to know better
  • Thanks Dudu.

    This is running from a CD provided by a training company - presumably a branded version of a Microsoft supplied image. I think the problem is when it runs the dotnetfx, dated 14 October 2005, that is provided on the CD as a part of the installation batch of three jobs, ie it always does this first, irrespective of if .net 2 framework is in place but then fails, before it even gets to SQL Server itself.

  • Try running from CD after uninstalling the .Net from the machine.

    MJ

  • Hi Richard,

    If you go to the location below in your C drive you will see that you already have .NET 3.5 SP1 because you are in XP SP3. So just verify the.NET version and download and install the SQL Server 2005 trial from the links below. If your XP is home then you will not install SSRS because the installer disables SSRS if IIS is not running. The other thing is to run the installer in your C drive and don't answer many questions of the installer and choose all components.

    C:\WINDOWS\Microsoft.NET\Framework

    http://www.microsoft.com/sqlserver/2005/en/us/trial-software.aspx

    Kind regards,
    Gift Peddie

  • Please advise if this works as I'm also interested in your OS version.

    What you don't know won't hurt you but what you know will make you plan to know better
  • Thanks - will try this Friday - but the reason for installing SQL Server 2005 is to practise the stuff we covered on a Reporting Services course, so will be a nuisance if SSRS does not install ! !

  • You need to make sure IIS is installed before you run the installer or it is disable the SSRS as an option in your choose components. So check control panel Admin tool and make sure IIS is there or go to Add remove programs choose add Windows component and use your operating system CD to install IIS.

    Kind regards,
    Gift Peddie

  • SQL Server needs components that are at the .Net 2 level and will not use the equivalent .Net 3 components.

    Do not be surprised if you have problems installing .Net 2 if you already have .Net 3 installed. Google can help you find a number of other people who have had this problem. The bad news is that the most effective means of overcoming this problem if you hit it is to re-install Windows, and then install .Net 3.5 SP1. The .Net 3.5 installer will install .Net 2, then .Net 2 SP2, then .Net 3, then .Net 3.5, then .Net 3.5 SP1. The gotcha in all this is that .Net 2 SP2 is only available in the .Net 3.5 SP1 install package, so if you want to install this and already have .Net 3 installed you may hit the problem in upgrading your .Net 2 environment to .Net 2 SP2 and need a Windows rebuild to get past this.

    If you are not confused by this time, maybe you have not understood how badly packaged the .Net 3.5 SP1 install is.

    OK, I know the OP only wants .Net 3 today, but when you decide to use .Net 3.5 you should plan today how to get there without risking having to do a Windows rebuild.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • The level of .NET framework above 2.0 is not really relevant to the trial version that is the reason it installs even in XP home. And I know system restore fixes most framework related problems and I have not told any of my users to reinstall Windows.

    The reason the product owners of the .NET framework within Microsoft have cleanup utilities that can be used and I don't think the OP needs that at the moment.

    Kind regards,
    Gift Peddie

  • Gift, you are right. On re-reading the thread I see the OP problem has nothing to do with the .Net level.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • Could his SQL 2005 installation issue be related to the MSXML 6.0 SP2 issues that are now Hindering every new install of SQL Server 2005? Occurring since about Nov 2008 because XML SP2 are now 'Protected' files, and SQL's Setup.exe totally craps out as a result.

  • Thanks for your help. Seems a little inconclusive. I do not think IIS is installed - this is a stand-alone desktop PC, not being used as an Internet server in any sense. Does this mean I still meed IIS in order to install SQL Server 205 with SSRS. By the way, SQL Server 2008 installed fine - but I need 2005 to run the course exercises !

  • SQL Server 2005 SSRS needs IIS on the box before it will install. All other components will install without IIS being on the box.

    SQL Server 2008 SSRS does not use IIS and therefore will install without it.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply