Post reply

Unable to install client component of sql server 2005

  • April 5, 2007 at 6:22 pm

    #116371

    When I install only client component on my desktop, I keep on getting the following error and it failed to install:

    There was an unexpected failure during the setup wizard.

    I search the web to find solution and did exactly what it instructed but I still the same error. Below is what I found:

    CAUSE

    <script type=text/javascript>loadTOCNode(1, 'cause');</script>

    This problem occurs because the folders that contain the files that are required during the installation of SQL Server 2005 do not have a correct layout.

    This problem is most likely to occur if you start the SQL Server 2005 installation from a folder on a network share or on a hard disk when the folder was copied from the SQL Server 2005 installation CDs.

    Back to the top

    WORKAROUND

    <script type=text/javascript>loadTOCNode(1, 'workaround');</script>

    To work around this problem, set the folders in the correct layout for the SQL Server 2005 installation.

    The SQL Server 2005 installation uses the following two folders:

    •Servers
    •Tools

    These two folders must be under the same level of a folder or the root folder of a drive. The names of these folders must be exactly Servers and Tools. The Servers folder contains all the files that are required to install major SQL Server 2005 components, such as database engine. The Tools folder contains tools components and Books Online for SQL Server 2005.

    Back to the top

    MORE INFORMATION

    <script type=text/javascript>loadTOCNode(1, 'moreinformation');</script>

    To copy the files from the SQL Server 2005 installation CDs to a location and then install SQL Server 2005 from that location, follow these steps:

    Note In this example, the D:\SQLServer2005 folder is the location to which you want to copy the files from the SQL Server 2005 installation CDs.

    1.In the D:\SQLServer2005 folder, create the following two subfolders:

    •Servers
    •Tools

    2.Copy all the files from the SQL Server 2005 installation CD that is named Servers to the D:\SQLServer2005\Servers folder.
    3.Copy all the files from the SQL Server 2005 installation CD that is named Tools to the D:\SQLServer2005\Tools folder.
    4.Open the D:\SQLServer2005\Servers folder, and then double-click Setup.exe to start the SQL Server 2005 Setup program.

    -----------------------------------------------------------------------------------------------------

    What else could be the problem? My computer is XP, prof.V 2002. with SP 2.

    Thanks for any help in advance,

    Roxie

     

  • April 5, 2007 at 9:54 pm

    #698973

    Do you get the same failure if you run the instalation from CD?

  • April 6, 2007 at 10:42 am

    #699049

    I don't have CD to test. It's only on the network so I copied to the local machine c:\sql2005\servers folder that I created it. 

    Roxie

     

  • April 6, 2007 at 10:47 am

    #699052

    You also created the "tools" folder?

  • April 6, 2007 at 11:32 am

    #699061

    No, I didn't install any developer tools.  Also my desktop is xp pro v2002, sp2 and installaton edition is Standard (32-bit).

  • April 6, 2007 at 11:59 am

    #699070

    I reviewed the article again and found that I do need to create Tools folder. The reason I didn't do it is that I don't find any tools folder after installation zip file extraction.

    The downloaded zip installation file's name is SW CD SQL Svr Standard Edtn 2005 W32 English #1 32 bit MLF.x11-57658 and SW CD NTRL SQL Server 2005SP1 W32 English #1.X12-14491 and I'm wondering if some files are missing.

    Please advice,

     

    Thanks,

    Roxie

  • February 5, 2008 at 7:41 am

    #775127

    i had the same problem and just fixed it....

    here is some more text from M$

    Similarly, if you downloaded SQL Server 2005 Developer Community Technology Preview (CTP) from the MSDN download site, the full product is split into two separate downloads. To perform a complete installation of SQL Server 2005, you must download both the Servers and Tools files to folders that are named Servers and Tools. Additionally, keep these folders under the same level of a folder or the root folder of a drive before you start the installation.

    basically i downloaded both sql2005 disk from m$. created folder called sqlserver2005 on my desktop created a Servers and a Tool folder under the sqlserver2005 unziped disk 1 into servers folder and uzipped disk 2 in the tools folder. and the client components installed perfectly!!

    hope this helps....took me all day to fix

  • February 6, 2008 at 3:38 am

    #775501

    You might find http://www.codeplex.com/SQLServerFineBuild helpful. It is something I published that helps you get a 1-click install and configuration of SQL Server 2005. One of the standard builds it does is for Client Tools only.

    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

  • February 7, 2008 at 7:45 am

    #776017

    For Tools/client component installation use CD #2. CD #1 is for installing the database engine, reporting services, etc. with the exception of the client tools and SQL Books Online and so for Client component installation use CD #2

    Regards,

    Ambrosius Bekti

  • October 31, 2012 at 7:37 pm

    #1554820

    Great 🙂

Viewing 10 posts - 1 through 9 (of 9 total)

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