Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to install client component of sql server 2005 Expand / Collapse
Author
Message
Posted Thursday, April 5, 2007 6:22 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 9, 2007 11:57 AM
Points: 14, Visits: 1

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

 

Post #356466
Posted Thursday, April 5, 2007 9:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 1:30 PM
Points: 183, Visits: 209
Do you get the same failure if you run the instalation from CD?
Post #356483
Posted Friday, April 6, 2007 10:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 9, 2007 11:57 AM
Points: 14, Visits: 1

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

 

Post #356574
Posted Friday, April 6, 2007 10:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 1:30 PM
Points: 183, Visits: 209
You also created the "tools" folder?
Post #356577
Posted Friday, April 6, 2007 11:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 9, 2007 11:57 AM
Points: 14, Visits: 1
No, I didn't install any developer tools.  Also my desktop is xp pro v2002, sp2 and installaton edition is Standard (32-bit).
Post #356588
Posted Friday, April 6, 2007 11:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 9, 2007 11:57 AM
Points: 14, Visits: 1

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

Post #356598
Posted Tuesday, February 5, 2008 7:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 27, 2009 7:31 AM
Points: 1, Visits: 2
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
Post #451637
Posted Wednesday, February 6, 2008 3:38 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 19, 2014 2:46 AM
Points: 2,879, Visits: 3,229
You might find 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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #452095
Posted Thursday, February 7, 2008 7:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 3:09 PM
Points: 6, Visits: 437
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
Post #452743
Posted Wednesday, October 31, 2012 7:37 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 16, 2014 9:15 AM
Points: 15, Visits: 672
Great :)
Post #1379580
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse